ADO Connection Problem 
Author Message
 ADO Connection Problem

Hi, I am using the following:

Function testcon()

'Const adOpenForwardOnly = 0
'Const adLockOptimistic = 3
Const adCmdTable = &H2

Dim oConn, RS, sConnString

Set oConn = CreateObject("ADODB.Connection")
sConnString = CurrentProject.Connection
oConn.Open (sConnString)
Set RS = CreateObject("ADODB.Recordset")

RS.Open "tblname", oConn, adCmdTable

RS.MoveFirst

MsgBox RS("SSN")

RS.Close

End Function

I get an error that says the database has ben placed in a
state that prevents it from being opened or closed. I have
no problems using other controls.

Any suggestions?

Thank you



Tue, 30 Aug 2005 23:05:23 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADO Connection Problem and Windows 2000 - multiuser problem

2. ADO connection problem

3. ADO connection problems

4. ADO Connection Problem

5. ADO Connection Problem!

6. ADO Connection Problem

7. ADO Connection Problems

8. ADO Connection Problem

9. ADO Connection problem with requery

10. ADO Connection Problem!

11. ADO Connection Problem

12. ADO Connection Problem

 

 
Powered by phpBB® Forum Software