Disappearing Forms, Reports, & Tables

  • Thread starter Thread starter Stumped
  • Start date Start date
S

Stumped

I'm stumped and need some expert help. I have a Access
(2000) application that utilizes a Switchboard form and
allows for data entering using a form (it also has queries
and reports). When the users use this application and
exits properly out of the application, upon going back
into the application the switchboard form and data entry
form are gone. The reports and tables have also been
deleted but queries are ok. Does anybody have any idea
why this is happening? It is a simple and small
application and is being used by multiusers on a network.
Thanks in advance for your help!
 
It sounds like you may have a corrupted database. Try creating a brand new database, and
then import all objects from the possibly corrupt database, one object group at a time
(ie. all tables, then all queries, then all forms, etc. as separate import operations).
You can import all objects in a single operation, but the experts at FMS (www.fmsinc.com)
have indicated in the FMS Community newsgroup that they have seen problems when doing
this.

Did you have the entire database stored on the file server? There are several things that
you should do to convert from a single user database to a multiuser database. First and
foremost is to split the database into a front-end / back-end, and install a copy of the
front-end on each user's PC. Other suggestions include disabling NameAutocorrect, setting
SubDatasheets to [None] and ensuring that all users have the same service pack levels for
Access and Jet (should be SP8 for Jet). Tony Toews has a good site with all kinds of
suggestions that you should follow:

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm

and

Microsoft Access Performance FAQ
http://www.granite.ab.ca/access/performancefaq.htm

Tom
_______________________________________


I'm stumped and need some expert help. I have a Access
(2000) application that utilizes a Switchboard form and
allows for data entering using a form (it also has queries
and reports). When the users use this application and
exits properly out of the application, upon going back
into the application the switchboard form and data entry
form are gone. The reports and tables have also been
deleted but queries are ok. Does anybody have any idea
why this is happening? It is a simple and small
application and is being used by multiusers on a network.
Thanks in advance for your help!
 
Back
Top