Multiple users of one shared database on 2003 and 2007

[Higgins]

Hi

Our office recently upgraded 50% of our machines to office 2007,
unfortunately as 50% are still running office 2003 we are having issues with
functionality in the shared database (created in 2003) the command buttons
created using wizards in 2003 are not working in 2007, in addition to this i
have the added risk of 2007 users potentially saving the file in 2007 format,
making is inaccessible to the 2003 users. I understand that I can split the
database and create a new interface in 2007 for the 2007 users, (fixing all
of the buttons) however am I able to link front ends from 2 versions to a
2003 back end, and is anyone aware of what other potential hazards lie in
wait.

Many thanks

 

[Tony Toews [MVP]]

however am I able to link front ends from 2 versions to a
2003 back end,

Yes, I had a client who ran this way from A97 and A2000 front ends
against an A97 backend for years.

and is anyone aware of what other potential hazards lie in
wait.

None really although there might be a few minor items.

You need to look at performance and update the FEs on the client
systems.

1) The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

2) I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

You can make an A2003 format MDE available for both the A2003 and the
A2007 users to execute.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[NEWS]

hellooooooooooooooooooooooooooo
d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d
hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg d hgkjfhgkfjh kgj hghlg