SQL error on 1st execution of new application

[vabki]

I recently completed an Access project in which the object (.mdb of queries, forms, reports, modules) is expected to run locally with the data (.mdb of tables) running on a network server. I sent the “setup” to our lab, where they built a machine with an “image” of the destination machine (which did not have Access installed), then ran setup to install the components. When we tried to run the application, it launched, but the first attempt to use any functionality resulted in some sort of SQL error (-2147024894). Is there some code or a website that documents what these error codes mean?

BTW, upon returning to my desk, I was able to run the application from my developer platform accessing the back-end server data without any errors, so the error references some failure in communicating from the new setup to the backend data.

Thanks

 

[Pat Hartman]

That is not an Access error code. Access error codes are still 4 digits and I think less than 5000. Search for the error code in your RDBMS documentation.

 

[Ron_dK]

Is there some code or a website that documents what these error codes mean?

There are many sites which might have your answer. Just google for : error 2147024894

 

[vabki]

I might have found the source of the problem

1. I googled for the error # with the minus sign attached, which fails.

2. If the machine on which the application is installed does not have folders (directories) and paths equivalent to those already present in the application then the application gets an automation error. (In other words, a reference to a file location that does not exist, because of operator or set up error, then the application ignores any error handling built into the application and yields an automation error. Once the path exists, then the error routines come back into use and yield the traditional messages, like "53 File not found".)

Thanks for the assistance, especially on better googling.