Migration to XP

[stephanie.white]

I am currently working on a project to migrate our
systems to Windows XP. I am a novice with Access and
need steps to assure the smooth conversion of Access 97
databases and other Access database versions we may have
to XP. Can anyone help me or direct me somewhere to get
these steps. I have browsed around but have not found
the exact answer I am looking for.

Sincerely,

Stephanie White

 

[Meulen; Tjeerd van der]

With regards to the hanging of Access 2002, you might want to check wether
"Opportunistic Lockking" has been disabeled on bothe server and
workstation(s). If not, do so. This is a common problem with databases that
can cause various problems

 

[Manuelo]

Un saludo atento

We have just done this at our company - taking Access 97
applications with a SQL Server 6.5 backend to Access 2002
and our W98 clients to WXP.

The only issues we have is that Access 2002 freezes
periodically with no warning (and not with any pattern)
and the only way to get out of it is Ctrl-Alt-Del. When
this happens the network connections are all open and
every other application is fine except for access!

Also - you cannot be in Access 2002 and Microsoft Money
at the same time as one or other will hang.

Plus there is often problems where Access cannot print a
report (it periodically thinks there are no printers
installed and so you cannot print or design reports).

A bit of a headache at present but apart from that it
works 80% of the time.