Access XP vs SQL Server

[Deb Roberts]

I have recently developed a database in Access XP, which when tested on my pc locally works beautifully. I have since installed it across a network and performance is now almost non existent.

I have split the database into two - a front end & back end, and have saved both front & backs as .mde files.

The back end is on a server, and the front end is stored locally on each user's pc.

The front end is just under 10mb, and the back end is about 1.8mb at present, although there's very little data stored in the tables at this point. There is a bit of vba code involved, and several Access macros, but in terms of Access' capability, I think it's actually a fairly small database.

I am wondering whether the database should in fact have been developed in SQL (which I don't have!).

I would really appreciate some advice.

Many thanks.

Deb Roberts

 

[John Vinson]

I have recently developed a database in Access XP, which when tested on my pc locally works beautifully. I have since installed it across a network and performance is now almost non existent.

I have split the database into two - a front end & back end, and have saved both front & backs as .mde files.

The back end is on a server, and the front end is stored locally on each user's pc.

See Tony Toews' excellent Performance FAQ:

http://www.granite.ab.ca/access/performancefaq.htm

There are several suggestions there; one of the key ones is to open a
connection to the backend on startup of the frontend, and keep it
open.

Note also that there are "networks" and "networks". Access is a
network hog; it demands a fast, solid LAN. I have lost a couple of
clients who insisted on trying to run over a WAN - it *won't* work (or
worse, it *sort of* works and then kills you with performance and
corruption).

 

[Deb Roberts]

Thanks for this info.

My database is quite small - the back end is approx 1.8mb, and the front end
approx 8mb, and both files have been saved as .mde files.

There will only be 4 main users, with about 5 other people using the
database on rare occassions to extract data, but not modify it.

Am I correct in assuming that Access XP should deal with this size of file
across a network OK, and that perhaps the network it's running on is far
from ideal?

Thanks in anticipation.

Deb



my pc locally works beautifully. I have since installed it across a network
and performance is now almost non existent.

 

[Tony Toews]

Am I correct in assuming that Access XP should deal with this size of file
across a network OK,

Very nicely.

and that perhaps the network it's running on is far
from ideal?

Not at all. Read the performance FAQ John mentioned. It will almost
certainly solve your problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm