connection error ms access database

[csgraham74]

I have an ms access database that runs perectly fine locally - when i
upload it to the server i get "exception has been thrown by the target
of the invocation" on any database connections.

I have had this error message locally so i added full permissions to
everyone and this solved the issue.

My problem now is that i dont have access to permission setting on my
host server - my hosts assure me all settings are correct.

Has anyone else encountered this issue or can help me ??

Im beginning to think my code may be wrong - but why would it work fine
locally ???

Any help or guidance appreciated.

CG

[Cowboy (Gregory A. Beamer) - MVP]

Make sure they allow creation of the lock file on the server by the anon user
account. That is where 90%+ of the Access errors occur.

I would also consider, if offered, moving to MySQL or SQL Server (usually a
charge for SQL Server, but many offer MySQL for free). You avoid so many of
the Access problems by headin this direction.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"csgraham74" wrote:

I have an ms access database that runs perectly fine locally - when i
upload it to the server i get "exception has been thrown by the target
of the invocation" on any database connections.

I have had this error message locally so i added full permissions to
everyone and this solved the issue.

My problem now is that i dont have access to permission setting on my
host server - my hosts assure me all settings are correct.

Has anyone else encountered this issue or can help me ??

Im beginning to think my code may be wrong - but why would it work fine
locally ???

Any help or guidance appreciated.

CG