|
-
Sep 2nd, 2002, 07:44 AM
#1
Thread Starter
Frenzied Member
Transactions with Dao on SQL-Server
How can i use transactions on SQL-Server wiht DAO ?
I am working on an access mdb which must be transfered to sql db instead of access db.
Most updates and data access was writing using docmd's and dlookups , dmax, dcount.
When using same code on sql-server i encouter problems with locks on tables.Where I get a sql-server timeout error.
My boss wants DAO is still used so I can't change it to ADO.
Anyone know how to use dao with transactions ??
Code:
If Question = Incomplete Then
AnswerNextOne
Else
ReplyIfKnown
End If
cu Swatty
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