Last post Oct 04, 2009 09:00 PM by Sayre
Sep 24, 2009 01:17 PM|parkfield|LINK
My asp.net application accesses a MS Access 2003 database.
When the website has exclusive access to the database, response time is almost instantaneous.
If the database (mdb) file is open in MS Access, however, then the website slows to about 15 seconds per page.
Has anyone else come across this, and is there a solution?
Sep 24, 2009 01:52 PM|hans_v|LINK
Did you already 'splitt' the Access Database in a Data and application Database?
Sep 24, 2009 02:14 PM|parkfield|LINK
yes, the mdb contains only tables.
Oct 01, 2009 01:56 AM|Sayre|LINK
When it comes to database it's much good to use the SQL server most of all when it comes to speed matter. And even the connection.
Oct 01, 2009 02:53 AM|KumarHarsh|LINK
what i understood is ,website is accessing your mdb database and also you hv open your same mdb table at the same time.
Then mdb has this limitation.
Do not open your mdb file.If you hv to work then work on copy of it.
Oct 01, 2009 06:12 AM|parkfield|LINK
Yes, migrating to SQL Server will certainly get around the problem. I was just curious as to why MS Access, which claims to be a multiuser system, apparently slows down considerably with only two users connected - even when only one of those users is actually
querying the database. If I get time I'll do some more detailed testing and update this post with the result.
Oct 04, 2009 09:00 PM|Sayre|LINK
Ok, we will wait for the result.