migrate DAO to ADO : Connection issue

[Craig Buchanan]

I would like to migrate my DAO code to ADO. I've got most of it working,
however the Connection is an issue.

Is there an ADO equivalent to CurrentDB? When I try to use a connection
string pointed to my MDB file, I get a locking error message, even if I use
Shared Deny None and Admin.

Is there a better way?

Thanks,

Craig Buchanan

 

[Roger Carlson]

Dim cnn as ADODB.Connection
Set cnn = CurrentProject.Connection

There is a great Microsoft whitepaper called "Migrating from DAO ot ADO"
that has this and other issues. You can download it from Microsoft. I also
have a copy on my website that you can download.