Converting from Access2000 to Access97

[lauritz]

Hi,

I have recently built a small app using Access 2000. I need this app to run on an NT machine running Access 97. I am having all sorts of problems. I have "fiddled" with the references and overcome most of the errors but still have a major one. It is a data access issue.
This is the code that just won't compile. (I know the dim is poor programming)

Dim oConn
Set oConn = CurrentProject.Connection

I am very knew at this type of programming and don't quite understand what the problem is.

Really appreciate any help.

 

[danvlas]

Replace
Set oConn = CurrentProject.Connection
with
Set oConn = CurrentDb

You're going from ADO to DAO, so you could change the object variable names to something closer to DAO (especially Connection objects that will be replaced by DAO.Database objects => instead of oConn, oDb)

Dim is poor programming? Argumentative...

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[lauritz]

Fantastic! Thankyou very much.