How to force MDB NOT to create .ldb file on server?

As topic~~~

the locking file created by MDB itself has bugging me for a while....

sometimes whena client machine screws up end up with a 'dead' .ldb file on the server, which cause my entire web app. to crash when trying to revisit the site by the same/other client machines.


Does anyone has solution to this besides upsizing my MDB to SQL DB??

HELP WANTED

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

There's no way to access the mdf file without it creating the ldf.


The best you can do is put as much error trapping into your code so you close the connection 100% of the time.


This is a big pain though, so many people with this problem upgrade to SQL.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Yep, i notice that....

the company i am working for is not looking for upsize to SQL at this point ....maybe they will be thinking about it in the long run!

Gosh...I already put way too much Try 'n Catch block in my code...

I m worried about too much Try 'n Catch would slow the app. down...

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

Accessing the database is thousands of times slower than a try catch block. The performance difference will be immeasurable with or without it.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

that's great!

One more question...how many users are able to simultaneously access the web site without causing instability of the underling MS Access db?

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>

 

no one really knows. Also, the issues get worse as the size of your database grows.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

May god bless my client company


I have recommend my client company to utilize MS SQL....but the "manager" said "NO!"


I just wish they won't blame my web app. when the 'time' comes.





oh..thx, Joel

J. L.
Technical Support/IT Admin/MIS Developer
Maxtop Enterprises Inc.
http://www.maxtop.ca</CODE>