Access 2K CurrentProject.Connection

S

Stephen Knapp

A couple of postings report receiving the error "run-time error'-2147024769
(8007007f) Method 'Connection' of object '_Current Project' failed" when
attempting to open a new ADODB connection to the existing project using the
CurrentProject.Connection property. One respondent suggested a problem with
permissions presuming that the data files (possibly the back-end data) was on
a remote server. My database is not split and resides solely on my machine.
My code ran correctly under Windows 2000 Pro but will not execute under XP
Home. Attempts to use ".OpenConnection" returns an error that indicates that
the operation cannot be completed because the connection is closed or does
not exist. I am reading articles from the Knowledge Database and will look
for any recent Service Packs. Any suggestions will be warmly received.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top