Linking to tables on another database

N

none

I have a live database (DataB) that is used by someone else that I am
connecting to. I have no control over the DataB database and all I
want to ever do is pull information without modifying any of the data.

If I set up linked tables from my database to DataB, how do I ensure
that I set up my database correctly so that it does not modify any of
the data on DataB?

Thanks!
 
T

Tom van Stiphout

Options include:
* Put DataB on a readonly share.
* Use workgroup security to give the user only readonly rights
* In your forms, set Allow Additions, Allow Edits, Allow Deletes to
false.
* Deliberately design queries underlying your forms to be readonly.
* Set Cancel=True in all Form_BeforeUpdate events.

I'm probably missing a few.

You like any of these?

-Tom.
 
N

none

Options include:
* Put DataB on a readonly share.
* Use workgroup security to give the user only readonly rights
* In your forms, set Allow Additions, Allow Edits, Allow Deletes to
false.
* Deliberately design queries underlying your forms to be readonly.
* Set Cancel=True in all Form_BeforeUpdate events.

I'm probably missing a few.

You like any of these?

-Tom.
Click to expand...


Thanks for the tips. The first one is not a possibility (I cannot
control where the file resides and the folder properties), but I will
look into the other ones. Thank you very much for your help!
 
Top