Version Conflicts

[rachel_maybury]

ea have access databases that are used by apx 50 people some are on NT and
some are on 2000. We all have access 97 installed.
If a user with 2000 uses the database and sends an e-mail from the database
the NT people can not untill the references are changed back to 97.
Is there a perminent fix to rsolve this as it will be a long time till we
are all upgraded to XP?

 

[Douglas J Steele]

Depending on which reference is getting changed, you could switch to Late
Binding, so that no reference is required. Tony Toews talks a bit about this
at http://www.granite.ab.ca/access/latebinding.htm

Have you split your database into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships)? That's the normal recommendation for multi-user
applications. Only the back-end goes on the server: each user has his/her
own copy of the front-end, preferably on their hard drive.

 

[rachel_maybury]

Thank you Douglas, I will give it a try and let you know how I get on.
Please may I have some more information about splitting the DB.

Kind Regards
Rachel

 

[Douglas J Steele]

Tony's got information about splitting at
http://www.granite.ab.ca/access/splitapp/index.htm and/or check what Albert
Kallal has at
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm