Cannot change subdatasheet name

We have just converted to Office 2003.  I have created a new table and I changed the subdatasheet name to None and hit save.  When I go back into the table design, the subdatasheet name says "Auto".  Every time I change it back to None and save, Access seems to change it back as soon as I close the table.  We have tables that were set to "None" before the conversion and they are still set to "None".  This seems to only happen on creation of new tables after the conversion.  How do I get this setting to stay on "None"?
msanzenbAsked:
Who is Participating?
 
ArjiConnect With a Mentor Commented:
The only other thing I can think of is to make sure and clear out the master and child link fields in the table properties when you set subdatasheet to [None].  I would think Access should automatically clear those fields when [None] is selected but just wanted to see if that it a possibility.
0
 
ArjiCommented:

are you using the Insert menu to turn on or change the subdatasheet?
0
 
msanzenbAuthor Commented:
No, I'm using the properties dialog to change it
0
 
msanzenbAuthor Commented:
I still didn't figure it out but I'll give you points anyway...thanks for your help!
0
 
ArjiCommented:
thanks for the points.....wish I could help you more but what's happening defies logic.  Are you setting a Primary Key in your table?  Sorry if that sounds like a dumb question but I felt I had to ask.  Also, is this an Access Project(SQL Server) or just a database(MDB)?
0
All Courses

From novice to tech pro — start learning today.