Error

[Liwons]

Can you help me to fix this pls. Ty :)

[djjeavons]

Hi

How are you trying to connect to the database? Is it DAO, ADO? What version? Also, what version of Access did you use to create the database?

[Liwons]

Microsoft jet 3.51 OLE DB Provider sir

[djjeavons]

And what version of Access did you use to create the database?

[Liwons]

I dont know sir. How to see if what version im using sir?

[djjeavons]

Do you have Access installed on your computer? Sorry for all of the questions but it is hard to determine what the problem is without knowing what version of the database it is.

Have a look at these two links that may be able to assist:

• How Can I Determine Which version of Access was used to create a Database - This will require that you have Access installed on your computer. You will need to create a script file (text file with a .vbs extension).
• Why won't Access 2013 open an .mdb file - This may hold some additional info while not answering your question directly.

[Liwons]

Its ok sir, yes it is installed in my computer sir

[mridul.ahuja]

Try this out

Get an original copy of the previous Access DB that has not been attempted to be open with a newer version.
Open a blank Access copy of the newer version
From the newer version, go to Import Objects. Go through all the tabs and import all objects including macros.
Once it is imported, go back to the DB Options and match the old DB version's Options.

Even if this is the same version of Access, this will improve the DB.
The Repair and Compact does little of either. Using the steps described above, I have salvaged broken databases.
It also compresses differently when the import objects are used.
It has also repaired corrupted controls on several occasions.

Just a note on Office 2013. Make sure the Service Packs are installed. There are pages of known issues for the original version.