ADO Recordset Problem

Question

4.33/5 (3 votes)

See more:

Hi All,

I have an access 2002 application, I'm using ADODB to insert a record into a table in a SQL Server 2000 backend. I am using a connection object and a recordset object.

The code for works fine for 40 users, but simply will not work for 2 particular people.

When I step through the code as these users I see that the recordset never opens, I have tested my connnection object at this point and it is open.

At the point below the recordset does not open.

VB

Set rs = New ADODB.Recordset
rs.Open strSQL, dbRDDTCnn, adOpenDynamic, adLockOptimistic

I cannot fathom why vba code that works perfectly for so many people would not work for just two people.

I would be very grateful for any suggestions you might have

Thank you!!

Posted 25-Aug-11 11:45am

Jennifer McCartthy

Updated 25-Aug-11 14:21pm

walterhevedeich

v2

Add a Solution

Comments

Dr.Walt Fair, PE 25-Aug-11 23:13pm

Does it give any error message? What are the values of the rs.Open parameters for those 2 users?

Jennifer McCartthy 26-Aug-11 8:51am

Your answer
thank you for your reply.

Yes, after the rs.open line it tells me "ERROR #3704 Operation is not allowed when the object is closed"

The parameters for rS.open are

rs.Open strSQL, dbRDDTCnn, adOpenDynamic, adLockOptimistic
strSQL is a simple SQL statement, and dbRDDTcnn is my connection object that tests to open.

Thanks again

Maciej Los 29-Aug-11 5:20am

Which Office application: Excel, Word, Access? Which version? MS Office versions are the same on all computers? Have you try to reinstall MS Office?

Jennifer McCartthy 29-Aug-11 12:07pm

Afternoon, thank you for your reply.
we are using Access 2002. We are in a terminal services environment so they are all the same version. I haven't tried to reinstall office as the users are sharing the same instance of access and yet this problem is only happening for two users.

Maciej Los 31-Aug-11 2:23am

Without knowing more details about connection object we can't help you (security settings). It looks like the connection is closed. Is it happend only for those 2 users no matter of terminal?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-04-10T08:23:00

First of all, read my (losmac) comment to your question. Before you call open method[^] for recordset, you need to open connection. If connection is open, try to change CurstorType[^] parameter, from: adOpenDynamic to: adOpenStatic or adOpenUnspecified.

More: How To Open ADO Connection and Recordset Objects[^]