Hi guys,
I've got a very important question for me, I wrote a program in VB4 which deals with two tables in a database, this program at some point displays a form which asks the user to specify the records to be deleted (or modified) in the first table, the second form WHICH COMES AFTER displaying the first one however asks the user to specify the fields to be deleted (or modified (just the field name is modified)).
The problem is I get a "Could not lock table; currently in use" error every time I press OK in the second form. If I start the second form firstly then it goes fine!!
I thought that there was a variable that'd been still assigned to the table and that's why database engine could not do anything with the table before removing all variable referencing to that table, BUT I DID THIS and nothing happened, now my question would be something else: I use "Set Tbl = Nothing" statement to deallocate "Tbl" variable, is this enough for the database engine to consider that there's no longer any variable referring to "Tbl" object ?????????
Can I have assistance from you guys ??
I highly appreciate your participation.
poor Wesam !!
------------------
