How to change current Access 97 user

[donishere]

I recently upgraded someone to a new machine. Copying files and settings from the old to the new computer has been largely ok. However, we are having an issue with an Access 97 database.

When opening the Access database on the old machine, Access would ask the user for a login and password.

Now on the new machine, Access is not asking for any login credentials when opening the database file. The copy of Access on the new machine doesn't even have the same list of users that other people on other machines are seeing from the same database file (it's on a network share). I tried creating a new user in Access, but then I can't figure out how to switch the current user in Access.

Is there a way I can get this list of database users back into the new machine? If not, how can I switch the current user in Access?

 

[DBAMJA]

It appears that the database was linked to a .mdw file on the old machine. You need to find that .mdw file on the old machine and move it to the new machine.

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[PHV]

And what about the .mdw file ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[me2you]

Hi Donishere,

Was the Access db in question created with an MDW? and was appropraite Permissions and password set for users?

Peace,
me2you

 

[donishere]

It was the MDW file. Copied it to the user's computer and all is now well.

thanks again!