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

[Guest]

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

 

[Margaret Bartley]

Have you moved the files recently? There is a limit of 128
characters you can have a linked table connection, including
the full path name, the database name, and the table name.

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?

 

[Guest]

Margaret

Yes, I moved my files to, "c:\Program Files\InBusiness\InBusiness_be.mdb\tables".

John

 

[Guest]

Margaret,

Yes I have, to "C:\program Files\InBusiness\InBusiness.mdb\tablenames", so I shouldn't have reached the 128 character limit; right?

John

 

[Guest]

Margaret,

Yes I have, to "C:\program Files\InBusiness\InBusiness.mdb\tablenames", so I shouldn't have reached the 128 character limit; right?

John

 

[Margaret Bartley]

Try creating a test directory, "c:\test]" and move your
files there, and see if that makes a difference.

It's the total number of characters in the fully-defined
tables that count, so extra-long table names would
also kick it up past the 128 char limit.