Software

General discussion

opening Access 97 file in Access 2003???

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 DBImport all the objects from the database into a new databaseNote: 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. Thanks,

All Comments

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.

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.

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.

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.