How to share db's with Access 2000 & 2003 clients ?

[tmb]

I have clients with Access 2000 and some with Acess 2003 and they must be
able to create and share Access db's.

The 2000 clients can't move to 2003 now and the 2003 clients cant go back to
2000.

Is there a common format or way to do this?

(Will Access 2003 create and save db's in 2000 format? Any problems with
this? What is the best solution as I'm sure all the world hasn't moved to
2003 yet.)

thanks for any help.

 

[Brendan Reynolds]

Like Access 2002 before it, Access 2003 uses the Access 2000 file format by
default. It will not use the new Access 2002/2003 format unless users
explicitly choose to do so.

Of course, any new features that were introduced in the more recent versions
will not work when the MDB is opened in an earlier version.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Douglas J. Steele]

In actual fact, the default file format for Access 2003 is the Access 2000
format, so you shouldn't have any problems, unless someone chooses to
convert a file to the new format.

In general, your applications should be split into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing just the tables). The back-end should be in Access 2000 format,
and should be on the server. Each user should have his/her own copy of the
front-end, in the appropriate version, preferably on their hard drive.
Development work should continue to be done on the Access 2000 version of
the front-end, and converted to the Access 2002/2003 format once completed.