[AccessD] MS access shaky

[Dan Waters]

Hi Chester,

Many IT departments have had bad experience with Access.  What happens is
that someone in a department develops a nice access database (a single file)
and then wants to share it.  They will put it on a server and several people
will create a shortcut to it.  So of course when several people try to run
it at the same time it will corrupt and lose data.  Then the department head
will head over to the IT folks and casually ask them if they can fix up
their now 'must have' departmental database.  And the IT folks now have a
significant piece of 'emergency' work that is unplanned and without budget.
A few times of that and they hate Access.  What they usually don't see is
the applications that are properly split and designed well.  So almost all
of their experience is bad.

Two things you can do to help ensure things run well.

1) In the database file on the server, go into properties and set Compact on
Close = True.  This will automatically compact and repair the data tables
every time the last person closes their app file.  Apparently this will fix
the little problems before they become big problems.

2) In the opening code sequence set a Static database variable to the
database file on the server.  This will significantly speed up the user's
experience.

Static dbsBE As DAO.Database
Dim stgBEFullPath As String

stgBEFullPath = BEFullPath
Set dbsBE = DBEngine(0).OpenDatabase(stgBEFullPath)

Good Luck!
Dan

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kaup, Chester
Sent: Tuesday, May 24, 2016 1:10 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] MS access shaky

Our IT department is trying to say MS Access is a shaky platform. I like
access and don't agree with them. Anyone have any good comments?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com