Suggestions:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html
2. If these are attached tables (not imported tables), open the back end
database and set the property in the tables there.
And if they are attached from an older database (Access 97 or earlier), post
back for details of how to create the property in the old database.
--
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.
"pic078 via AccessMonster.com" <u15923@uwewrote in message
news:714f18fa32735@uwe...
>I just installed Access 2003 on my pc; I imported some tables from an
Access
2002 DB into a new file. I cannot remove the subadatasheets in the
tables -
I cleared the relationships - I set the subdatasheet property to [None] -
as
soon as I save it - the subdatasheet property automatically resets to
[Auto].
Any ideas on why this is happening?