Changing Access file to SQL Server

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a database in MDB-format, which consists of a back-
end and a front-end.
The back-end is constantly accessed by 7-12 users and it
often "hangs" so that one needs to repair it.
Will it help if I transfer the back-end to SQL Server and
leave the front-end databases in mdb-format, receiving
data from ODBC source?
 
depends on many factors:

1.Does each user have a local copy of the frontend on his
pc (except using terminal services or alike)

2.Is the design of the database good with proper indexing?
(called normalisation)
3.Forms aren't retrieving more data than necessary?
4.How many users are effectively writing to the database?

more about "hanging" db's and how to avoid it on:
http://www.granite.ab.ca/access/corruptmdbs.htm

some additional informative sites:
http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.able-consulting.com/ado_conn.htm
http://www.mvps.org/access/api/api0001.htm

http://www.mvps.org/access/tables/tbl0009.htm
http://accdevel.tripod.com
http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html
http://www.lebans.com/mousewheelonoff.htm
http://support.microsoft.com/?id=258049
http://www.mvps.org/access/general/gen0005.htm
http://www.trigeminal.com/usenet/usenet001.asp?1033
http://www.pksolutions.com
 
Mike said:
I have a database in MDB-format, which consists of a back-
end and a front-end.
The back-end is constantly accessed by 7-12 users and it
often "hangs" so that one needs to repair it.
Will it help if I transfer the back-end to SQL Server and
leave the front-end databases in mdb-format, receiving
data from ODBC source?
Click to expand...

Are you installing the front end on each computer right now?

If you are allowing multiple users into the same front end..then you can
still experience a lot of trouble..and moving to sql server will NOT help.

On the other hand, if each user has their own front end now, then YES,
moving the backend to sql server will eliminate corruption completely.

So, first make sure that each user's workstation gets their own copy of the
front end (no doubt..this is a mde...right?).

So, either way...you need to put those front ends on each computer. And, as
mentioned, if that is your setup now..then yes...using sql server will
eliminate the corruption.

So, simply don't allow multiple users into the front end. This rule applies
if you use a mdb back end, or sql server for the back end.
 
Back
Top