Re: Field 'disappears' from table ...

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

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.

--
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:%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 ...
    ... Something is wrong with the database. ... Explanation of why: ... Compact the database to get rid of this junk: ... I've had this happen a couple of times (and have worked out a workaround) ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access crashes when opening form
    ... Allen Browne - Microsoft MVP. ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it ... database works correctly there. ...
    (microsoft.public.access.forms)