Cannot Set recordset in A2003

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

On one workstation, Access won't get past certain lines in an app, like

Set dbs = CurrentDB

Or

If Me. RecordsetClone.Recordset = 0 then

I just installed A2003 on my PC and have no problems. My Client's PC is ok
also.

The libraries are ok and I set Access on Sandbox mode (and off).

Any ideas?

Thanks and God Bless,

Mark A. Sam
 
You don't mention which libraries you have a reference to. You need DAO
3.6. It sounds like you may have a reference to ADO instead...or maybe
neither. Press Ctrl-G, select Tools|References....make sure DAO 3.6 is
checked and doesn't say MISSING.
 
Hello Paul,

The references are:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft Office 11.0 Object Library
Microsoft DAO 3.6 Library
Microsoft ActiveX Data Objects 2.5 Library

I turned off the ActiveX on the offending machine, but that didn't correct
the problem.

God Bless,

Mark
 
Probably having a problem with ambiguity.

1. Try disambiguating the syntax by being Explicit:

Dim rst As DAO.Recordset
Dim db As DAO.Recordset

2. Make sure that the Microsoft ActiveX Data Objects 2.5 Library is
positioned below the DAO library or that it is turned off.

3. Try saving, compiling, then saving again after turning it off. Build a
new empty database with only the DAO reference, and importing everything
afterwards. Then compile and save it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin Meyer said:
Probably having a problem with ambiguity.
Click to expand...

Hello Arvin,

1. Try disambiguating the syntax by being Explicit:

Dim rst As DAO.Recordset
Dim db As DAO.Recordset
Click to expand...

I tried it. It didn't help
2. Make sure that the Microsoft ActiveX Data Objects 2.5 Library is
positioned below the DAO library or that it is turned off.
Click to expand...

It is. I even tried turning off the ActiveX Objects
3. Try saving, compiling, then saving again after turning it off. Build a
new empty database with only the DAO reference, and importing everything
afterwards. Then compile and save it.
Click to expand...

I'll try that. If it works, I'll give the user her own copy of the Front
End.

God Bless,

Mark
 
Thank you Paul. It was Cause 1 and the user is a happy camper (which is
important, becuase she writes my check) ;)

God Bless,

Mark
 
Back
Top