Linked database password

N

NevilleT

I have a typical split database and am trying to create a non workgroup
secuity environment. In order to protect the tables, I thought I could
create a database password, and somehow provide that password through VBA
when I opened the front end application so that the links worked. Has anyone
done this, or are there any other suggestions as to how to protect the back
end database?
 
K

kingston via AccessMonster.com

If possible, use VBA to create links on the fly via the command:
DoCmd.TransferDatabase acLink...

Make sure to delete the link quickly and appropriately (trap errors):
DoCmd.DeleteObject acTable...

Make your front end a .mde file to hide the code. Yes, you are only keeping
the honest people out, but I think that this makes it much harder.

I welcome and would appreciate other people's ideas and suggestions
concerning a solution to the OP's question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protect new workbooks from template 0
Check if back end is (still) password protected 0
How can I open a secured database? 3
2003 User&Permissions Problem in 2007 2
Microsoft Access Table Security 2
Accessing password-protected databases from .Net Framework 2
my password protection has backfired! 0
Database Password - Command Line Switch 8

Top