I have an old database developed (we think) in a pre-97 version of access. It has been used in 97.
Now we need to convert to Access 2000 and there are multiple compilation errors.
The primary type of error consists of code of which the following is an example:
Set db = DBEngine.Workspaces(0).Databases(0)
Set rst = db.OpenRecordset("TherapyDataBase")
'Stop
Do While Not rst.EOF
' is the client a match?
If Trim(UCase(SaveClientName)) = Trim(UCase(rst.Client)) Then
' got a client match
TypeMatch = False
The syntax "rst.Client" generates an error. The database is full of statements using "rst.".
I am pretty new to programming. How could I convert this old style code to code accepted by A2K?
Thanks
Now we need to convert to Access 2000 and there are multiple compilation errors.
The primary type of error consists of code of which the following is an example:
Set db = DBEngine.Workspaces(0).Databases(0)
Set rst = db.OpenRecordset("TherapyDataBase")
'Stop
Do While Not rst.EOF
' is the client a match?
If Trim(UCase(SaveClientName)) = Trim(UCase(rst.Client)) Then
' got a client match
TypeMatch = False
The syntax "rst.Client" generates an error. The database is full of statements using "rst.".
I am pretty new to programming. How could I convert this old style code to code accepted by A2K?
Thanks