General discussion


opening Access 97 file in Access 2003???

By luv2bike2 ·
I need to open an Access file and I am not sure if it was created in Access 97 or not. I am thinking it was created in Access 97 because of the message that I am receiving. I have Access 2003 and when I try to open it I get the following 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.

in the Help section of this error message box says:

This error is usually associated with opening or converting a security enhanced Access 97 or earlier databass. If you are not the owner of the DB, you most likely will not have the nescessary 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.

My question is:
if it was created in Access 97 and I do not have Access 97 on any of my workstations, how can I convert it to Access 2003? I am a complete Novice when it comes to Access, I have not work with it before so what ever help I can get would be greatly appreciated!
We just need to look at the data in the DB we do not need or want to make any changes to it.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by 3xp3rt In reply to opening Access 97 file in ...

You?re right. Probably is an access 97 database. Usually is no problem to convert in access 2003 format but how I see your account have no rights to do this. Log in with administrator rights and you can convert and open the database. If you made some modifications to data and you want to use the database in access 97 environment you must convert it back to access 97 formats.

Collapse -

by 3xp3rt In reply to

If you are logged in with desired rights and you open the database in Access 2003, you will see a windows with a message that this database will be converted to access 2003 format, and you just need to give a name for the converted database.

Collapse -

by luv2bike2 In reply to

thank you for your assistance. I forgot to mention that I am logged in as adminstrator rights for the network and I still get that message. the person who created the DB is no longer with the company. I have no clue as to what is in the DB, how it is set up and all the other good stuff. it is like the blinid leading the blind here in the office. there is no *.mdw file for security that someone else mention to me for changing security stuff.

Collapse -

by ICB's corner In reply to opening Access 97 file in ...

I think it's something about permission because Access 2003 invites you to convert the database if you have an older one. Did you try to open it with Excel or other application which knows .mdb?

Collapse -

by luv2bike2 In reply to

I could not open it with Excel or any other software. thanks for the suggestion.

Collapse -

by luv2bike2 In reply to opening Access 97 file in ...

This question was closed by the author

Related Discussions

Related Forums