Access 2000 and Access 2002 conflicts

[Guest]

I have created a database in Access 2000, we have many people working in this
database. Recently some people have been moved to Access 2002. We have
recently run in to some Macro problems with the database. That did not exist
before. Does anyone know if multi users working on different versions could
cause this problem.

Please help

 

[Douglas J. Steele]

Is your database split into a front-end (containing the queries, forms,
reports, macros and modules) and a back-end? It should be. Each user should
have his/her own copy of the front-end, preferably on their hard drive. Then
you shouldn't run into problems.

 

[Guest]

I am not familiar with the “front end†and “back end†set up. What is the
advantage to this and is it difficult to maintain.

 

[Tony Toews]

I am not familiar with the “front end” and “back end” set up. What is the
advantage to this and is it difficult to maintain.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm