Database Discussion

Print Page | Close Window

Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3246
Printed Date: 28 March 2026 at 4:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access

Posted By: Gullanian
Subject: Access
Date Posted: 03 June 2003 at 12:34pm

Got a client made the site using an access 2000 database.

Some strange problems are occuring:

Database frequently corrupts
Database permamently split into a *.ldb and *.mdb files

I know access is not designed for web use, I dont really need a lecture on how I should upgrade, going to SQL is too costly, however if you have any other database types you know and have tried in the past that are good and compatable with WW apps please let me know....

Every page load from this site uses around 40-50 SQL queries, a lot I know but its what the client wanted.... Im almost 100% positive im closing and dropping all the objects as well...

Many many thanks for help resolving this issue

Replies:

Posted By: michael
Date Posted: 03 June 2003 at 1:10pm

There are not so many databse types that are supported by hosts. If he has access to the server make sure that SP3 is installed in case it is W2000. SP2 and below has an issue with Opotunistic locking...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 03 June 2003 at 1:34pm

He runs the server himself, so if you have any good databases which are free and suopport WWG apps please tell!

Thanks!

Posted By: michael
Date Posted: 03 June 2003 at 2:00pm

msde

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 03 June 2003 at 2:32pm

you dont have a url to direct download by any chance

Posted By: michael
Date Posted: 04 June 2003 at 9:14am

You can download MSDE from http://www.asp.net/webmatrix/download.aspx?tabindex=4 - here thus you might have it as it comes with Every Office 2000 Prof. and up.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker