Help! transferring to new server

[Digger442]

I've been asked to assist a local non-profit transfer an Access DB to a new server. The DB was set up a number of years ago and the designers are no longer available.

The old server is set up as a workgroup server, and the new server is set up as a domain server. (I am completely unfamiliar with how networks are set up...I've never dealt with this end before.)

The designers set up a .mdw file which (I believe) controls permissions etc. After much wrangling, we finally uncovered the admin password. However, even signed in on a workstation as the admin w/ full rights, I still can't copy a functional version of the DB to removable media in order to move it to the new server.

The server does not have MS Access loaded....only the .mdb and .mdw files.

I *think* I have to replace the 'secured' .mdw file with a generic, clean .mdw. Do I need to do this on the server, or the workstations, or both?

What am I doing wrong????

Thanks!

 

[gemma-the-husky]

you need access

the mdw is the "rights" workfile - effectively it unlocks the database

the mdb is the database itself

but you need the access environment to read and use the data. If you get access 2003 say, it will offer to update your database to access 2003