I have a large table in a database (MS-ACCESS - about 150,000 records).
I have just started working with Visual Basic 4.0, and I am having a
problem with creating and dropping tables.
After getting user input, the program creates a table which is a subset
of the large table with the "SELECT * INTO NEW_TABLE FROM ...." command.
From this smaller table, I created several snapshots to perform various task.
When the user selects new data, I attempt to close the snapshots, and drop
the smaller table. When I attempt to Drop the table I get the following
error: Run-time error '3211': Couldn't lock table NEW_TABLE, currently in use.
It appears that the snapshot has locked the table and is not releasing it.
Any help would be appreciated.
Thanks,
Mike Zabkowski