msaccess does not stop running

[Guest]

I have a shortcut on my desktop I use to start Access with
a particolar database ""C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" c:\rod\access\mydata.mdb".
This works fine, but when I close the appllication, the
MSACCESS process continues to run. If I click my shortcut
again, I get another MSACCESS process running. Where this
is causing me the most pain, is when I update my Access
database from my FrontPage web site (by double-clicking
the mdb file in the fpdb directory). I have to make sure
no MSACCESS processes are running before I can open up the
file, otherwise it just hangs. Also, let's say I have no
MSACCESS processes running, I can bring up the mdb file in
Access, but when I'm done, it's EXTREMELY SLOW to save
changes and return to FrontPage. I have Windows XP Home
edition, using Office 2000 Professional and FrontPage
2000. I attempted to get this answer from the FrontPage
newsgroup, but was referred here since I kept talking
about MSACCESS. Can you please help?
Rod

 

[Scott McDaniel]

First, check for the existence of a stray .ldb file in the same directory as
your .mdb file (same name as your database: mydata.ldb). Turn off Name
Autocorrect.

1) make sure to close all objects (i.e. recordsets, db connections, etc)
2) compact and repair your database
3) Access 2000 saves all objects in one blob file, so design changes will
take a while
4) Hitting an Access db through the internet is notorious for poor
performance, and you're almost certain to experience db corruption. If your
database is not well structured, then you'll run into problems even faster.
5) Frontpage uses ODBC to connect and manipulate data ... instead switch
your connections to use the OLEDB provider, which will (normally) greatly
improve performance. I doubt you'll be able to do this using drag-n-drop
frontpage ... you'll have to go under the hood for this.
6) consider switching to a client/server database, if your host supplies
access to one.