PC Review


Reply
Thread Tools Rate Thread

copying database with login to another computer

 
 
=?Utf-8?B?RGFu?=
Guest
Posts: n/a
 
      1st Jul 2005
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.
 
Reply With Quote
 
 
 
 
John Slattery
Guest
Posts: n/a
 
      1st Jul 2005
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.


 
Reply With Quote
 
John Slattery
Guest
Posts: n/a
 
      1st Jul 2005
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/de...AcSecurity.asp

http://support.microsoft.com/default...b;en-us;289885

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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Database unable to Login for my computer Arvin Meyer [MVP] Microsoft Access Security 6 23rd Oct 2009 05:31 PM
copying database from one computer to another Denise Microsoft Access Queries 2 4th Mar 2008 07:28 PM
Cannot open database requested in login 'HumanResources'. Login failed for user 'companyDomain\BOSIIS$'. Homer Microsoft ASP .NET 3 25th Sep 2007 08:45 PM
Cannot open database requested in login ''. Login fails. Login failed for user ''. Nevena Microsoft ADO .NET 1 16th Apr 2004 06:55 PM
Copying a database to another computer Don Microsoft Access 1 22nd Dec 2003 07:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:53 AM.