Database Corruption Again

[kurtsimons]

Twice in the last two months I have received a "the database could not be opened, it might now even be a database."

or something like that.

I DB has become a multi-user from multiple-apps

clearly, its me because it keeps happening.


Do I need a real DB engine??

I am using the MSJet right now and an Access DB


any input would be great

[tumblingdown]

more details...

how many users?
how many apps?
how many concurrent connections?
bandwidth useage?
how much data our we talking about?
do you have budget to move to other platforms (sybase/sql server) ?
platform/network?

[kurtsimons]

Ok,


----

NT network, local network, bandwidth not an issue
no budget (but what could be done with be appreciated)
database consists of about 6,000 records in the main table
about 20 columns of misc data DB size about 1 GB (recently compacted)

what I get that error I run a repair an all is fine.

----

It started with two apps that both maintaining 1 connection apiece.

then it grew into 4

then I added a VB CGI that a few others use.
with CGI creates a new database connecdtion each time a web page is requested. example:

set db = dbeninge.opendatabase("\\computeer01\db.mdb")
set rs =

SQL

rs.close
db.close
set rs = nothing
set db = nothing


---------------------------------
if there a disadvantage to opening a db like this or should I be using a FILE DSN or something.

When it is time for a db engine like sql server. What makes SQL server such a great engine over something like what I have done.


Answer all you like!

thanks
kurt


[Edited by kurtsimons on 10-18-2000 at 11:12 AM]