Re: Corrupt Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"WayneS" <WayneS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E995B1B9-705C-4A51-A6DD-D0C32940647E@xxxxxxxxxxxxxxxx

MS Access 2003 SP2

MDB file

The Record Source of my form is a SQL table. The form has 174 textboxes.
Each textbox is bound to a column in the SQL table. The form has a filter
and an Order By. Navigation Buttons are set to Yes.

When the form is opened the user can navigate through the rows in the
table
with the navigation buttons.

This form suddenly disconnected from the SQL table. No record appears
when
the form is opened. All the other forms in the mdb remain connected to
their
Record Sources.

I have tried:

Compact and Repair

I changed the Record Source to a query that includes all the columns of
the
table.

I opened another mdb file and imported the form into this file. Then I
imported the form back into the original mdb.

The form still remains disconnected from the table.

I do not believe that a user accidentally opened the form in Design Mode
and
made a change.


I can open a new form and copy and paste all the text boxes from the
original form. I set the Record Source, Filter, and Order By to agree
with
the original form. The new form connects to the table and behaves
normally.
We also keep a backup of this mdb and the form in the backup is connected
to
the Record Source so recovery was not an issue.


I would just like to know what happened to this form?

Thanks,

Wayne



.

Relevant Pages

  • Re: Corrupt Form
    ... make it impossible for a repair service to fix it. ... The Record Source of my form is a SQL table. ... All the other forms in the mdb remain connected to ... the original form. ...
    (microsoft.public.access.forms)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)