Multiple Users

ASP and Microsoft Access

[ASPhopeful]

Hi All,

I am hopefully on my last ASP and Microsoft Access project as we are updating to .Net and SQL soon. However, I can't change over for this project.

I realise Access is no good with multiple users but I cannot change that for this project. I am wondering if anyone can help me. I experience intermittent problems where my ASP code throws back a 80004005 error and mentions about the database being held open exclusivly.

My connection strings use

.CursorType = adOpenForwardOnly

to limit the access to ReadOnly whereever possible.

Can anyone help?
Helen

[RainMaker]

I feel bad for you. LOL getting a project like that whilst you are frothing for something a little better such as sql or mysql. Anyhoo If you are getting errors as such it really could be a number of things with Access. I said before that Access's internal threading for connecting users is alot to be desired and the security really isn't up to par. so I am thinking that maybe you have a decent size DB maybe in Access and you are returning a number of rows that could take a lot longer than others and it's a possibilty those larger calls to the db may take priority over others. So ("I don't know") you may want to optimize some of your SQL statements like only selecting what you 'want' out of the DB not just *. Also you may want to close open connections if you still have them open for a period of time. Open...get what you want and close ...so that the other person can acess as well.

[ASPhopeful]

Hi RainMaker,

Thanks for the advice.

The databases are quite small so sadly that's not an option.
The SQL statements only get the information they need.
All open connections get closed as soon as the statements are run.

Sadly, I feel I'm at a loss :(.

[txbakers]

Usually that error comes when someone has the Access table open in another window in Design mode. Data mode will allow it, design mode won't.

[ASPhopeful]

The database is definitly shut. The server that holds it is locked and only I have a login for it. It's got to be code related but has me baffled.

Thanks,
Helen