Exclusive Opening

[INFOS]

If I have one access mdb file called "DATA" that contains tables and two access applications as mdb files: "app1" and "app2". Both applications has links to tables in access mdb file "DATA". Is there a way to open access file "DATA" exclusively when I open "app1" and open it shared when I run "app2"?

 

[ghudson]

You can use the exclusive command line switch in a custom shortcut. Here is a sample target field [note this is all on one line].

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "X:\DatabaseFile.mdb" /excl

Nobody will be able to open the db until you close it if you use the /excl switch. Check the access help files for the key words "Set command-line options for starting Access" or "Startup command-line options" for more info on using the command line switches.

 

[INFOS]

reply

Yes, I know the shortcut - but I don't want to open database file directly (there's only tables in this file). I want to open application "app1" that has links to the database file and at the same time to lock the database file only for myself - and I'm going to approach those tables by application "app1".

 

[ghudson]

Then just add the links to the tables you want from the other db. You could password protect the other database which would require you to enter the password when ever you try to access the linked tables.