Question Locked

Access 2003 error message

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

It is only happening on this new system. I get the below error message when I am logged into the system as the administrator to the domain or as the user.
I can log on to all my other systems and not get the below error message. All my other systems have Access 2003.

I have joined the user and the administrator to the workgroup on new system.

When I double click the DB I get the Logon Window, enter my password, than I get the below error message.

ERROR MESSAGE:

The current user account doesn't have permission to convert or enable this database.
To convert or enable a database, ensure the following:
You must join the workgroup that defines the user accounts used to access the database.
Your user account must have Open/Run and Open Exclusive permissions for the database.
Your user account must have Modify Design or Administrator permissions for all tables in the database, or it must be the owner of all tables in the database.
Your user account must have Read Design permission for all objects in the database.
Request the other users close the database.

The Help section of this error message says:

This error is usually associated with opening or converting a security enhanced Access 97 or earlier database. If you are not the owner of the DB, you most likely will not have the necessary access rights to open or convert it.
If you need to convert the database you can:

Attempt to change the permissions on the system tables to include Admin rights (if you are a member of the Admin group)
Have the owner convert the DB
Import all the objects from the database into a new database
Note: the security settings currently present in the existing db will not be present in the new db.

This DB was not created in Access 97, it is being used everyday by at least 10 or more users using Access 2003 and they do not have a problem accessing the DB.

I have limited experience with Access 2003, so with that said, what ever help I can get would be greatly appreciated!

Thanks,

7 replies

by oh smeg

Sounds as if you have hit the Concurrent Connections Limit that are allowed under Windows.

If this is XP Pro you can have 10 Concurrent Connections to 1 computer at a time. Any more and the computer in question can not open another connection

If it is XP Home or Media Center that limit is 5 Concurrent connections.

Col

by luv2bike2

I am able to get into the DB without any problems now. I uninstalled Office 2003 and rebooted and reinstalled Office 2003, applied all patches, rebooted and i was able to access the DB w/out any problmes. I am not sure why uninstalling and reinstalling worked but it did.
Thank you for your assistance, it is greatly appreciated!!!!

by shasca

Thats the second major rights issue you have had on this new PC. I'm concerned this might be a "problem Child" for you. You may want to look at a reimage at this early stage, before you get too far along into it.

As with most PC problems they are alot easier to fix at an early stage.

by luv2bike2

I figured it would be better if i did that.

Thank you for your suggestions!

by luv2bike2

and everything seems to be going well. the user has not had any problems.
Thank you for your assistance.

This discussion is closed to new replies.