D
DigitalVinyl
We just converted a A97 access MDB -> A2003. The conversion went very
smooth with almost everything works exactly as it has before. This is
a multi-user app, with a backend with data on a networked drive, and a
client locally on each PC. We also moved from WIn98 to WInXP on all
but the server.
The two major issues are
1) database corruptions. At least once-twice a week the database
crashes and Acccess says it is no longer a vlaid format. We must
compact and repair it. We have actually lost a few records now.
Although I think only in the largest table in the database (Clients).
ANyone know of any differences in 2003 that might cause greater
instability in a multi-user access environment?
2) the second thing which may be related is a list box on the forms,
which is linked to the CLIENT Table's key (client ID). Normally this
is in ascending order. However after any use by the clients, it
reorders itself. There is probably some field that is alphabetized but
I haven't spotted yet. If I open the table it is in order. But the
clients listbox is reordered in what looks haphazard, but is actually
a specific ordering sequence because it ALWAYS ends with the same
customers.
Anyone know of defaults that changed moving to 2003? None of us saw
this on tests with 2002--but the tests were not in a full multi-user
network environment.
DiGiTAL_ViNYL (no email)
smooth with almost everything works exactly as it has before. This is
a multi-user app, with a backend with data on a networked drive, and a
client locally on each PC. We also moved from WIn98 to WInXP on all
but the server.
The two major issues are
1) database corruptions. At least once-twice a week the database
crashes and Acccess says it is no longer a vlaid format. We must
compact and repair it. We have actually lost a few records now.
Although I think only in the largest table in the database (Clients).
ANyone know of any differences in 2003 that might cause greater
instability in a multi-user access environment?
2) the second thing which may be related is a list box on the forms,
which is linked to the CLIENT Table's key (client ID). Normally this
is in ascending order. However after any use by the clients, it
reorders itself. There is probably some field that is alphabetized but
I haven't spotted yet. If I open the table it is in order. But the
clients listbox is reordered in what looks haphazard, but is actually
a specific ordering sequence because it ALWAYS ends with the same
customers.
Anyone know of defaults that changed moving to 2003? None of us saw
this on tests with 2002--but the tests were not in a full multi-user
network environment.
DiGiTAL_ViNYL (no email)