Unanswered: Get Access User Name From Login Pop-up Box
I have recently been given the job of administrating a Access Database which was brought in from another company, the database works fine on the stand alone PC which the database arrived on and asks for a user login when the mdb is loaded and I enter the login name and password that was passed onto me and everything works fine. My problem is when I copy the mdb onto my company server the message "You do not have the necessary permissions to use '*.mdb' " appears, originally I thought this was because I needed to copy across the system.mdw files across but sadly this did not work either, any ideas on why this is happening?
I am relatively new to Access so any thoughts or suggestions would be sincerely appreciated. Thank you in advance for your assistance.
You may have copied the system.mdw, but you did not instruct Access to use that new system.mdw. Your command line needs to point to that system mdw or you need to use the workgroup administrator to change the default that Access will use for the system.mdw.