I have a Access 97 database that contains the following VBA code:
Dim tbl As TableDef
Dim db As Database
Dim myName As String
Dim Msg, Style, Title, Response
Set db = CurrentDb()
For Each tbl In db.TableDefs
myName = tbl.Name
Select Case myName
This db has now been updated to Access 2000 and whenever I try to start run the macro that runs the VBA code above I get the Error Msg 3211 which tells me that the MSysAccessObjects is in use by anothet process or user (It can't be another user since I am the only user).
Anybody know why my code does not work in 2000 - it works perfectly in 97.