"Method 'Connection' of object '_Current Project' failed. -2147024

I have created a front-end application and back-end database. I have code that automatically links the front-end application to the back-end database for whenever I provide a patch or upgrade. Everytime that I opened the program in the past using either Access 2002 and 2003, it open just fine with no errors when linking to the back-end tables.

Lately, I get the following error message whenever I open my application:

ERROR: "Method 'Connection' of object '_Current Project' failed. Check to see if you installed the tables used for storing data is in the default directory. -2147024769�

After clicking, "OK", my application continues to open and re-links to the back-end tables anyway. Yes, all the data displays in the application front-end data fields.

I removed all the links to the back-end tables; re-imported the back-end tables; same problem. This was then followed by with creating a new application re-combining the front and back-ends (no problems occurred in loading and using the application) and preceded to re-split the application again. I continue to receive the above error.

I went to backups and earlier versions of my application, up to 12 months, and now, they give out the same above error message. Could this be an Access problem?

Any ideas on what is going on?

John

Hi John,

It sound more like a missing references problem. Check for any references marked as MISSING on
the computers that are having a problem. If
you don't find any missing references, then try refreshing the references collection, by
selecting a new reference, clicking on OK, and then go back and deselect it.

Solving Problems with Library References
http://members.iinet.net.au/~allenbrowne/ser-38.html

Access Reference Problems
http://members.rogers.com/douglas.j....nceErrors.html

Tom

____________________________________

"John Phelan" wrote in message
...

I have created a front-end application and back-end database. I have code that automatically
links the front-end application to the back-end database for whenever I provide a patch or
upgrade. Everytime that I opened the program in the past using either Access 2002 and 2003, it
open just fine with no errors when linking to the back-end tables.

Lately, I get the following error message whenever I open my application:

ERROR: "Method 'Connection' of object '_Current Project' failed. Check to see if you installed
the tables used for storing data is in the default directory. -2147024769�

After clicking, "OK", my application continues to open and re-links to the back-end tables
anyway. Yes, all the data displays in the application front-end data fields.

I removed all the links to the back-end tables; re-imported the back-end tables; same problem.
This was then followed by with creating a new application re-combining the front and back-ends
(no problems occurred in loading and using the application) and preceded to re-split the
application again. I continue to receive the above error.

I went to backups and earlier versions of my application, up to 12 months, and now, they give out
the same above error message. Could this be an Access problem?

Any ideas on what is going on?

John

Hi John,

SYMPTOMS
When you attempt to use a wizard or to open a switchboard in Access 2000,
you receive the following error message:

Method 'connection' of object '_currentproject' failed.
CAUSE
This behavior can result from a damaged or a corrupted Microsoft Data
Access Components (MDAC) stack.
RESOLUTION
To resolve this behavior, download and install the latest version of MDAC
from the following Microsoft Web site:
http://msdn.microsoft.com/library/de...ist/dataaccess
.asp

This site also provides links to information about how to install MDAC.
MORE INFORMATION
You see this behavior most commonly with a switchboard form, the Lookup
wizard, the Combo Box wizard, or the List Box wizard. However, this
behavior can also occur with other wizards or builders.

For Further Information : Microsoft Knowledge Base Article - 306132

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.