Access login porblems - HELP

[cnadams]

Hi,

Before we start - I'm a web dev / sql server grunt. I don't have much experience with access.

We've just performed our PC roll-over and we've moved from Access 2000 to 2003. We have alot of DB's around and some of which have *.mdw's. After the rollover was complete I've gone to the required computers and from ther 'Joined' the work group through the work group administration tool. This allowes the users into the required DB via the correct login.

HOWEVER.... drum roll.

No other databases which don't have any workgroups or logins are displaying the same login from my first DB. Entering the log and pass from the first database will then let you into this unrelated DB.

Does anyone have any ideas on how I can fix this problem?

Thanks for reading

Cam

 

[Smart]

I had the same problems with our dbases.the problem turned out to be with the workgroup admin file (wrkgadm.exe) it had been linked inadvertantly to a dbase with a uname and password . If memory serves it was an access 97 dbase and this was how it was fixed
C:\programfiles\microsoft office\office\1033\wrkgadm.exe
double click on the file wrkgadm.exe
join
browse
C:\programfiles\microsoft office\office\system
click on system click on open

Not sure how to do it in later versions of Access
However if you select tools then security then user then user-level security wizard.
The first screen mentions work group information files

 

[ghudson]

The uses computers should be joined to the default System.mdw file so that they can open non secured db's and also open and create new db's without having to supply a login ID and password.

Access 2003 moved the workgroup admin process to the menu bar in Access 2003 @ Tools / Security / Workgroup Administrator

The users should be using a custom shortcut to open their custom secured dbs'. Here is an example of the Target: field to open a secured db [all on one line]...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime /wrkgrp "C:\Workgroupfile.mdw" "DatabaseFile.mdb" /user UserName

Technically, all Access db's are secured since they have to at least user the default System.mdw file to be opened.