Question converting db

[sevenzz]

can i convert ms access 97 (.mdb) directly to ms access 2010 (.accdb)?
thx for your help...
regards..

 

[HiTechCoach]

Have you tried it?

I find it best to create a new blank database in 2007/2010 format and import all the objects from the older version's database.

 

[pegsus]

Here is the info for Access 2007.

I would think for Access 2010 it is similar.

http://office.microsoft.com/en-us/a...-access-2007-file-format-HA010048406.aspx#BM2

 

[sevenzz]

Have you tried it?

I find it best to create a new blank database in 2007/2010 format and import all the objects from the older version's database.

i already tried it...but another problem come...i don't have permission to open it...how to low the database's security?

 

[HiTechCoach]

i already tried it...but another problem come...i don't have permission to open it...how to low the database's security?

Is it asking for a database password or a User anem and Pawword (ULS)?

If I rememebr correctly, you must remove a database password before you can convert. If I rememebr correctly, you can still import the object after entering the databse password.

If the databse is using User Level Security (asking for user name and password) ithen the databse can only be converted to Jet 4 (Access 2000/2002/20003) format. The new ACE database engine that handles the 2007/2010 foramt (.accdb) does not support User Level Security.


Have you tried running the Jet Comp 4 utiliy to compact the databae from Jet 3 to Jet 4 (Access 2000/2002/2003)?

 

[HiTechCoach]

Also, if the database is an MDE, you can NOT convert it. All the source has been removed in an MDE. You will have to use a MDB to convert or import.

 

[sevenzz]

Is it asking for a database password or a User anem and Pawword (ULS)?

If I rememebr correctly, you must remove a database password before you can convert. If I rememebr correctly, you can still import the object after entering the databse password.

If the databse is using User Level Security (asking for user name and password) ithen the databse can only be converted to Jet 4 (Access 2000/2002/20003) format. The new ACE database engine that handles the 2007/2010 foramt (.accdb) does not support User Level Security.


Have you tried unint he Jet Comp 4 utiliy to compact the databae from Jet 3 to Jet 4 (Access 2000/2002/2003)?

yes the database using ULS.lol..

how to unisnt the jet comp?i'm newbie using access.
thx a lot for your help...

 

[HiTechCoach]

You can download the Jet Comp utility from here:

Jet compact utility is available in download center