Front End / Back End

[Rosemary]

Hello,

I have a small database application in MS Access 2002. Our organization is
roughly 250 people, but this application is only used by my department -- 8
people. On our network the application is stored on one of the drives.
Currently, both front end and back end are in the same folder. We are
starting to experience concurrency issues.

Our IT department is not allowing me to place the front end on each user's
PC. They have decided it has to remain on the network drive. Here is my
question: Every user on our network has their own personal drive. If I were
to copy the front end to each user's personal drive, would that serve the
same purpose as installing it on their PC?

Many thanks,

 

[Alex White MCDBA MCSE]

Yes and No,

From a bandwidth perspective, it is the same as having the file in the same
directory, as you are running code across the network rather than db data so
no gain there.
From a shared access perspective it is better as you are not running
multi-user on the front-end.

How big is the database?

 

[Rosemary]

Hi,

Thanks -- right now, the front end is 1124 kb and the back end is 1860 kb.
In one day the back end grew by 268 kb, and I would say that is fairly
typical data entry for one day.

Rosemary

 

[Alex White MCDBA MCSE]

Your database is small and the volumes of data you are inputting are small
too, so try and make each user use a different version of the front-end,
e.g. as you said in the personal drive see if that makes a difference.

Another thing to check, make sure your anti-virus is not scanning any of the
mdb's it tend's to drive the anti-virus software mad.

 

[Rosemary]

I will do that. Thanks a lot, Alex.

Your database is small and the volumes of data you are inputting are small
too, so try and make each user use a different version of the front-end,
e.g. as you said in the personal drive see if that makes a difference.

Another thing to check, make sure your anti-virus is not scanning any of the
mdb's it tend's to drive the anti-virus software mad.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk