-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You can run a report in one front-end using a query in another .mdb/e
file by using a RecordSource property like this:
SELECT * FROM qryOtherQueryName In "C:\My Doc\OtherDB.mdb"
See the Access Help topic on the In predicate.
- --
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBP6X79YechKqOuFEgEQIkAwCg2L3yBxd18LeNP0rw/k1arL3cvhAAoPC+
Ht36pw6nUAfhxZkuQYDrIQ2J
=5CRN
-----END PGP SIGNATURE-----
intl04 wrote:[color=blue]
> That worked great - thanks so much! Just another question: Is there
> any way to create and run reports in that second db that are based on
> queries in the main db? (The queries are built from 3-4 tables linked
> together, but I want only one table - the table in the second,
> data-entry db - to be modifiable.)
>
> It seems that if I replicate all the queries in the second db, all the
> other tables (from the main db) have to be there as well, to generate
> those queries. Of course, in that case, there's the risk that multiple
> tables' data will be accidentally modified by data inputters.
>
> I tried a database split that was recommended by another respondent,
> but all the tables in the front-end db were linked to the back-end db
> and were modifiable. Of course, when I deleted the other linked tables
> from the front-end db (the ones that I did not want to be modifiable,
> I could not run any queries that generate data from the tables linked
> together.
>
>
>
>
> "PC Datasheet" <spam@nospam.com> wrote in message news:<CpXob.1451$9M3.120@newsread2.news.atl.earthl ink.net>...
>[color=green]
>>Create a second database to your main database. Create one or more tables in
>>your second database to contain the data you want to use in the main database.
>>Create one or more forms in the second database to input the data into the
>>second database. In the main database create linked tables to the tables in the
>>second database. You can now give users access to the second database for data
>>entry. They will not be able to access the main database. However, you will be
>>able to use the data that was entered from the main database.
>>
>>
>>--
>> PC Datasheet
>>Your Resource For Help With Access, Excel And Word Applications
>>
www.pcdatasheet.com
>>
>>
>>"intl04" <intl04@hotmail.com> wrote in message
>>news:b72dab78.0311011325.786f3ba4@posting.google .com...
>>[color=darkred]
>>>How do I create a data input form in Access that is external to the
>>>Access database to which it's connected (if that's possible, which I
>>>believe it is)? For example, if someone clicks on an Access file icon
>>>on a computer desktop, it will open up a data entry form (that was
>>>created in Access). That way, the people who enter the data won't have
>>>direct access to the database at any point.
>>>
>>>I've seen that this can be done, but I don't know how it's done. Does
>>>it mean that the form and the database reside in two separate drives?
>>>Do I need to go into 'view code' in the design view when creating
>>>forms, to make any adjustments directly to the code?
>>>
>>>Thanks in advance for any help on this.[/color][/color][/color]
