(unspecified error) with asp-access database connection

[krappleby025]

HI all,

Thought i would pass this on.

i have recently been having problems with and unspecified error with a connection string to an access database, i have searched for 5-6 days for an answer, and have found many possibilities, some of which were easy to find some which were hard...
NONE OF THEM WORKED... well

after searching for ages on many different search engines, i found what could be the answer, and am testing it tonight, but still i am posting the info for you...

This info regards, connecting to an access database, and at the same time having the database recieve many many hits at a time..

I was using an DNS LESS odbc connection to connect to the database, and according to the documentation, this generates an unspecified error whenever three or more people try to access the database at the same time, This is because the connection string program, is not created to accept many hits.. SO the solution...
The documentation explained that the solution was to change the odbc connection string to an ole db connection string. i did that and i got a different error, which i am going to solve tonight, but this may be the reason for the error...

Just thought i would pass this onto you. I will keep you all informed on the progress, and if it works i will post the file here for you all to look at...

I hope this solves my problem

grin

keith

thank you for all your help