access 2000 and 2003

[ampal]

I have a database that was created in access 2000. The back end recides on a server, the front ends are on PCs running 2000. I have replaced one PC with a new XP machine and it is running access 2003. I have installed the front end, linked the tables, but when I run the DB I get an error on some forms. We have other XP/2003 machines running the same front end. Someone else installed them, What am I doing Wrong?

Thanks
Mike

 

[lameid]

First is everything patched?

Second, take a copy front end from one of the other XP 2003 machines and see if it works.

Third, what is the error?

 

[rjoubert]

I ran into a similar problem with a VB.NET application that was hitting an Access 2000 DB on a file server. The users of this application had been upgraded to Access 2003, and they were getting sporadic errors saying that the application could not find the database. I finally had to upgrade the backend DB to Access 2003, and the errors went away. If you have Access 2003, you can open up the Access 2000 DB, click on the Tools menu, goto Database Utilities, and check out the Convert Database option...use this to convert the DB to 2002/2003 format.

 

[ampal]

Thanks for your help, I will try to copy a front end from a 2003 machine and see if that works. The Convert Database option, will that convert the front end only or does that convert the back end?

Thanks
Mike

 

[rjoubert]

You would need to open the backend DB to convert the backend DB, and open the front end DB to convert the front end DB...since they are separate MDB files. I would suggest creating a copy of the backend DB and converting the copy to 2003. That way, you're not affecting any of the current Access 2000 users. Then, run test your XP/2003 machine against the converted 2003 backend DB.

 

[lameid]

The problem with multiple versions of access is that everone probably needs to be able to read and write to same backend or there is little point. This means using the lowest version of all users for the backend.

 

[ampal]

I just heard from the guy who wrote the data base. I had to go into the VBA editor, tools, refrences, deselect DAO Library, save it, go back in and select it. Then it worked fine. That was all the explanation I got from him, but he did tell me he had to do the same to the other XP machines.

Thanks for all your help.

Mike