|
-
Jul 4th, 2000, 07:31 AM
#1
Thread Starter
Fanatic Member
Does anbody know how to free locks on a database using ADO
I know in DAO you can use the DBEngine.idle method but this appears not to work as the I can't release the lock on the database. It claims I still have a connection to it.
AAARRRRRGGHHHHHH!!
 Gary Lowe
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip
-
Jul 4th, 2000, 07:39 AM
#2
Thread Starter
Fanatic Member
 Found it
He Hehh
I found that if I use the following it works
Code:
DBEngine.Idle dbFreeLocks
DBEngine.Idle dbRefreshCache
Gary Lowe
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip
-
Jul 4th, 2000, 09:48 AM
#3
Lively Member
Look at what is causing the lock
I would consentrate on what is causing the lock in the first place. You should look at what type of connection and the type of locking you have on your recordset (if it is a recordset you have the lock problem with).
Regards,
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote