Multiple User problem

[Spencerrr]

Hello Everyone,

I'm pretty new to Microsoft access and i'm having a problem with a database on a LAN ive been searching and reading for 2 days now and I haven't found the solution yet.

My problem:
I created a Database in MS Access 2000 i put all the files onto a local server. I created 2 MS Access data pages (HTML) and an excel file the problem is i have 4 older computers with either access 2000 or access 2003 it works fine on those. But i have 3 other computers which either have windows xp or windows 7 but none of them have access 2000 or 2003. The windows XP pc has access 2007 yet the excel and html pages do not work. When i open the file my input fields show #NAME?

To me this indicates that there is no connection to the database. I hope someone can help me out with this problem i'm happy to answer all questions to make the problem clearer

Regards
Spencer

 

[Trevor G]

Welcome to the Forum,

In brief you can't run a database in one version on a multi version system.

As you are using Access 2000 in real terms this will be Access 9 therefore there will be conflicts with other versions due to References, look at the following

MS Access 97 is MS Access 8
MS Access 2000 is MS Access 9
MS Access 2002 is MS Access 10
MS Access 2003 is MS Access 11
MS Access 2007 is MS Access 12
MS Access 2010 is MS Access 14

When you open your database the reference are set to Access 8
When another users opens your database using Access 2003 it resets the Reference to Access 11
If you try and open the database again you don't have Access 11 so the Reference will show as missing.

To see the reference you have to go into the VBA screen and then look at the Tools Menu and References (Use ALt + F11)

 

[ghudson]

Your database needs to be split and each user will need their own front end in the version of access that they have installed to their hard drive and each front end is linked to the shared backend. Access 2007 can open older versions of Access databases. It would be best if you could at least get all the older computers upgraded to Access 2003.

 

[Spencerrr]

Thank you for the replies i will try to split the database, But i realised that i might as well let them open the project file and let them fill forms out inside access its both just one click away! i will try to split it first though.
Once again thank you