Recordset returns Error 3709

[the9thdoctor]

The following code should generate a recordset, and (to test that the data is actually being picked up) returns the value from the LogNo field in a Message Box.

Set cnConnection = CurrentProject.Connection
Set rsCallsClosed = New ADODB.Recordset
rsCallsClosed.Open ("SELECT * FROM tblCALLHEADER &quot
Do Until rsCallsClosed.EOF
MsgBox "Call number " & rsCallsClosed!LogNo
rsCallsClosed.MoveNext
Loop
rsCallsClosed.Close

The only problem I can think of is that the tables exist in a seperate database, although the database the code resides in uses Linked Tables to connect to another database. Mick Snowden
Systems Support Engineer

 

[jimmyg423]

What version of MDAC are you using? I've run into numerous problems with Recordsets before I updated my MDAC from microsoft

http://www.microsoft.com/data/.

It might correct your problem or at least you will know it isn't a ADO problem.

 

[the9thdoctor]

Thanks, I'll try that. There are another couple of criteria that may affect it. The database the connection tables link to is part of a helpdesk system, that lives on a server at our other site. We only have a 64k link, which is shared by all 50 users at our site for data xfer between sites AND internet access. Could there be a timeout problem?
Mick Snowden
Systems Support Engineer