A guy who programmed a database in Access 97 has moved on to better opportunities. He set up the database with user-level security. I have admin rights to the database through the *.mdw file. I am converting the database to SQL Server 7.0, however I can't read anything except table names in the database because of the user-level security. I would hate to have to reenter the info (tens of thousands of lines).

I've read Microsoft's way of unlocking a database. (give all users all permissions, then copy the data into a new database). There's got to be a better way!