Access 97 to Access 2002 Issues

[Jay]

I have converted an access 97 front end to an Access 2002/XP front end, the
back end is still Access 97. Now I find that on certain systems the
application runs fine, on others it's slow as a snail or slower. The main
reports take around 2-3 minutes to run on some systems, on the others it will
take as much as 30 minutes. Is this a common pitfall of converting to XP?
I've downloaded SP3 for XP and nothing has changed in the performance speed.
Anyone know of a solution? Upper management is getting tired of the answers I
supply which are the answers found on the web related to this issue. HELP!!!!!

Upper management has threatened me with dying a slow and painful death if no
solutions are found soon!

Thanks,

 

[Allen Browne]

Suggestions:

1. Open the back end database in A97. For each TableDef that you will link,
CreateProperty() named "SubdatasheetName", type dbText, value "[None]".
Example below. You should now be able to set the SubdatasheetName to [None]
in the front end, and have it stick.

2. Make sure you have disabled Name AutoCorrect under:
Tools | Options | General
While you are there turn off Record Level Locking on the Advanced tab.

3. Make sure that the path name to the back end is short. If it is greater
than 128 characters, you're shot.

4. For any workstation running on WinXP (without SP2), see:
http://support.microsoft.com/?id=834350

5. More suggestions:
http://www.granite.ab.ca/access/performancefaq.htm


Code to create the SubdatasheetName property in your A97 tables:

Function SetSubDatasheets()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim prp As DAO.Property
Dim strTable As String

Set db = CurrentDb()
For Each tdf In db.TableDefs
strTable = tdf.Name
If Not (strTable Like "MSys*" Or strTable Like "~*") Then
If Not HasProperty(tdf, "SubdatasheetName") Then
Set prp = tdf.CreateProperty("SubdatasheetName", dbText,
"[None]")
tdf.Properties.Append prp
Debug.Print strTable
End If
End If
Next

Set prp = Nothing
Set tdf = Nothing
Set db = Nothing
End Function