Remote database

[dbalargin]

I want to open a db holding the shift key.
Here's the catch... I have the db automated to open by itself.
I have other users, so when they open it, the autoexec macro runs. When I open it, I want to have access to the db window bypassing the autoexec macro.

 

[Len Boorman]

Why not set up your own front end.

Copy the database as it is.

Delete all tables from the copy.

Link to all tables in the original database

Set up autoexec as you wish

You now have all the data and functions of the original database but without the autoexec control


I use this quite frequently so that I can oversee and manage data using at times functions not available to Users.

Len B

 

[dbalargin]

Brilliant Suggestion!
Thanks!

 

[Len Boorman]

Not brilliant really

Damn clever though (and a bit sneaky)

len