Access Help Please!

[Nuggs]

Hi Folks

I'm putting together a Database using MS Access. Problem is that my machine runs Access2000, while other users are running Access97.

No doubt this brings up some compatibility issues. Any ideas how best I could deal with these?

TIA

[SneakyNeil]

/Upgrade everyone to 2000/xp/2003

/Downgrade yourself to 97

/Do the database in something else, openoffice has a database now. Or you could use SQL with a web front end?

/Can't exactly remember but 2000 may have some options regarding 97 compatability?

[Nuggs]

SneakyNeil said:

/Upgrade everyone to 2000/xp/2003

Would be lovely, but my employer has short arms and deep pockets when it comes to IT.

SneakyNeil said:

/Downgrade yourself to 97

As above, if there's any way to do this without cost, then that would be great.

[pdV6]

SneakyNeil said:

/Downgrade yourself to 97

Easiest option. By far

[Nuggs]

pdV6 said:

SneakyNeil said:

/Downgrade yourself to 97

Easiest option. By far

Thanks - how would one go about this in the most cost-effective way possible?

[BliarOut]

MySQL/PHP? Your boss'll love it cos it's free

[.Flyer]

Are you just using Access as a database, or are you creating an application using Forms, Reports, VBA, etc.? In theory, it shouldn't matter...

In Access 2000: Tools > Database Utilities > Convert Database > To Prior Access Database Version

Save it with a new filename. Open it in Access 97. Click OK to the info dialog about converting code to current version of VB (even if there is no VB). You now have an A97 version.

Not the ideal solution, but will do what you need

[Nuggs]

.Flyer said:

Are you just using Access as a database, or are you creating an application using Forms, Reports, VBA, etc.? In theory, it shouldn't matter...

In Access 2000: Tools > Database Utilities > Convert Database > To Prior Access Database Version

Save it with a new filename. Open it in Access 97. Click OK to the info dialog about converting code to current version of VB (even if there is no VB). You now have an A97 version.

Not the ideal solution, but will do what you need

I love you (in a manly non-gaye way).

Thanks chief!