copying database with login to another computer

1 Jul 2005 6:01 PM

Dan

I have created a database and I recently added the security feature to it.
Then I made it a MDE File. Everything works great on the computer that I made
the changes to but When I copy the front end to another computer it says you
don't have permission to use ...filename... Have you system administrator
establish appropraite permissions for you. However it never brings up the
long in screen.

1 Jul 2005 8:01 PM

John Slattery

Sounds like Access on the other computer is still a member of the default
workgroup or some other workgroup but not the one you created when you
secured things. The login form doesn't appear because Access successfully
logs you into the workgroup it is using as Admin with no password but this
Admin user has no permissions on the database.

One way to handle this is by giving your users a shortcut to start the
application that specifies the workgroup to use. In Access 2002, go to
Help, Index, press Clear, paste startup;command;line; into key words, press
Search, and look at the Startup command-line options topic. Another way
would be to open Access on the PC and go to Tools, Security, Workgroup
Administrator and join the workgroup. In most cases, the shortcut approach
proves to be least problematic. And yes, the workgroup information file you
created must be accessible to the PC, either on a local hard drive or a
network share. The network share will prove to be the least hassle for
administration.

1 Jul 2005 9:51 PM

John Slattery

If what I described turns out to be the problem, you should take a look at
some links like the following:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_AcSecurity.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;289885

It would be likely that you missed some other apsects of securing your
application.