Start Database

[Greg]

Hello,
I have several 2003 databases that I launch from a main database using code.
Is there a way to make a database so it can only be opened from another
database? I do not want the end user to be able to navigate directly to the
database and double click it to open.
Thanks
Greg

 

[Brian]

I don't know exactly, but perhaps you could have the users log into the main
database, record the user ID, pass that over to a temporary table in the
secondary DB via a link to that temporary table, and then grant access to the
second DB based on the existence of that user's record. Just an idea...

 

[Chris Mills]

If you let them open one database, there is no inherent better security in any
other MS-Access database file, if that's what you're asking.

Apart from simple obfuscation that is. Such as not knowing the folder, hidden
files and things, renaming your mdb to winxyz.sys or something, that sort of
thing. Hell, not even I would open winxyz.sys!

People may say these methods are not really secure. Of course they are not.
But they sure help?

Why does "opening multiple databases", as a technical issue, make your app any
more or less subject to security than if it was all in one app in the first
place? I mean, you are doing this for some other technical reason, right? All
navigable databases (I mean Back-End databases) should have the same security.
Assuming you have already used the Access security methods available, there is
no better inherent security, no.

Chris