security error on conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having issues converting a database from 97 to 2000 for a customer.
Here's the rundown.

I have an Access database with user-level security where the tables are
linked to a separate 'data' database. Both are in 97. Under the Admin
superuser account, I have given the Users group all permissions on all
objects. I then imported the Definition and all objects into a new blank
database. Finally, I removed security by removing the Admin password (this
is verified as the database no longer requires login).

I am now attempting to convert the database to 2000 format (for the
customers.. I have 2003). I have joined the proper workgroup and when I
attempt to convert the database, I receive the error "The Current User
Account Doesn't Have Permission to Convert or Enable this Database". No one
else is in the database.

Are there other avenues to tackle this issue? Any advice is much appreciated.
 
deo89 said:
I have an Access database with user-level security where the tables
are linked to a separate 'data' database. Both are in 97. Under the
Admin superuser account, I have given the Users group all permissions
on all objects. I then imported the Definition and all objects into
a new blank database.
Click to expand...

Actually you should exit Access; rejoin the standard system.mdw; create a
new database and import all objects. This ensures that Admin user now owns
everything. Then attempt to convert to 2000. Once converted you can then
resecure the mdb.
 
I joined the default system.mdw. I can create a new database and import the
'data' file just fine. However, when I create a new database and attempt to
import the main database, I get a permission error for each linked table it
is trying to import. The queries and other objects import fine. The
permission error for each table indicates I don't have permissions to use the
original 'data' file object.

Thanks for your assistance...
 
Don't attempt to import the linked tables. Import everything else, and then
recreate the links to your unsecured 'data' file.
 
Back
Top