connection error ms access database

  • Thread starter Thread starter csgraham74
  • Start date Start date
C

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
 
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!
***************************
 
Back
Top