Re: Field 'disappears' from table ...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You are saying that you eliminated the amazing Name AutoCorrupt feature as
suggested, performed a compact/repair, checked everything is okay, and then
as soon as you added a new field to your table, you instantly lost one of
your existing ones?

Something is *drastically* wrong here. Under rare circumstances, it is
possible for a field to go bad, but it is not possible for any normal
database to have a repeatable problem like that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robin" <robin_irving@xxxxxxxxxxxxxxxxxx> wrote in message
news:uGHisRFyGHA.1340@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the quick reply Allen.

Your suggestions don't seem to have made any difference - I think there
must be some more basic corruption creeping in.

The problem has occurred before - I thought I'd better check first around
the Web if it was a well known glitch before I asked on a newsgroup - but
apparently not...

Robin


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:u8IA70EyGHA.4392@xxxxxxxxxxxxxxxxxxxxxxx
Never seen that. Something is wrong with the database.

You haven't just typed over the top of one of the fields, replacing it
with something else?

Try these basic repair steps.
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database
by entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

"Robin" <robin_irving@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23RpkzoEyGHA.2208@xxxxxxxxxxxxxxxxxxxxxxx

I've had this happen a couple of times (and have worked out a
workaround) but was wondering whether anyone can shed any light on it.

I'll edit the design of a table by adding a new field and when I go to
enter data in it ... it's not there... so I attempt to remake the field
and (if I use the same name) I'm told that a field of that name already
exists - but I can't see it.

When this hapens in a table my workaround involves adding yet another
field (called something like 'empty') and the previous one reappears
(but the field called 'empty' is invisible)

Has anyone seen this before? Any explanations?


.

Relevant Pages

  • Re: Field disappears from table ...
    ... save the table and switch to data entry mode - and the *new* ... database to have a repeatable problem like that. ... Tools | Database Utilities | Compact/Repair ... I'll edit the design of a table by adding a new field and when I go to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Large file size
    ... Tools | Database Utilities | Compact/Repair ... If you have any graphics in the database (e.g. Picture property of the form, ... Office Button | Access Options | Current Database | Name AutoCorrect ... Import the queries, forms, and modules from the old database. ...
    (microsoft.public.access.forms)
  • Re: Problem with Compact/Repair
    ... Yes, again...split database with 5 users having the front end, and the main ... can use the files after the compact/repair. ... I even took the datafile in question to another office network and everyone ... To compact and repair, you simply have to ask all users to exit ...
    (comp.databases.ms-access)
  • Re: Field disappears from table ...
    ... What does Access report as the Attributes of this field? ... and see if Access reports any that don't show in table design ... I assume this is not a replicated database. ... feature as suggested, performed a compact/repair, checked everything ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Field disappears from table ...
    ... I've run your suggestion in the Immediate window and it merely returns the ... I assume this is not a replicated database. ... feature as suggested, performed a compact/repair, checked everything ...
    (microsoft.public.access.tablesdbdesign)