Cannot Set recordset in A2003

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
 
P

Paul Overway

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.
 
M

Mark A. Sam

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
 
A

Arvin Meyer [MVP]

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
 
M

Mark A. Sam

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
 
M

Mark A. Sam

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
 
Top