converting DB from Access 97 to 2K

[newbee23]

I need to convert a 24.5MB database from access 97 to 2000. What would be the easiet way to go about doing this. There are many links to Oracle and it is a shared database. Could anyone lead me in the right direction?

 

[fermo]

you can open your database from Access 2000 and then convert it to 2000.

 

[cheerio]

On the whole you just open in the later version and Access will convert.

However, if you have VBA code then Access 2000 may try to interpret your code using the ADODB library instead of the DAO library. This causes code to crash because both libraries have things like recordsets but the syntax is different. To avoid this you need to open a module and go to Tools, References. Tick the DAO library and move it above the ADODB reference.

There may be issues with Access security. However, I always use my backend database to provide security so I cannot comment.

 

[newbee23]

Thanks all! But...when I open Access 2K and try to open the DB that's in 97 it tells me it's an unrecognized format. We have tried several times to convert it and it hasn't been successful. I thought it would be easier than it has been. Is it possible it could be due to so many permissions put on the DB?

 

[cheerio]

As I said before I do not use Access security.

You might like to look at the Microsoft advice at:

http://support.microsoft.com/defaul...port/kb/articles/Q237/3/13.ASP&NoWebContent=1

 

[newbee23]

So I decided to create a new database in 2000 and link the queries and tables to it so that 97 is sort of a data warehouse, but it's usable in 2000. Haven't started yet, but thought i'd let anyone out there interested know. I will keep you posted.