Subdatasheet Name keeps resetting to [Auto]

[Paul]

I have been told that you can improve performance of an Access database by
turning off the Subdatasheet Name property of the tables that don't require
this feature. However, I've noticed that in one of my applications, when I
reset [Auto] to [None] in some of the tables, and then save the change, the
next time I open the table I can see the plus signs at the left of the table
rows. When I check the property in design view, the property has reverted
to [Auto].

I've never experienced this in my other applications. What I can do to get
the table to understand that I want to set the Subdatasheet Name property to
[None]?

Thanks in advance,

Paul

 

[Jeanette Cunningham]

Hi Paul,
turn of Name Autocorrect, backup and save the database before you change the
subdatasheet name property to none.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

That should have read-->
backup and compact the database


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi Paul,
turn of Name Autocorrect, backup and save the database before you change
the subdatasheet name property to none.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have been told that you can improve performance of an Access database by
turning off the Subdatasheet Name property of the tables that don't
require this feature. However, I've noticed that in one of my
applications, when I reset [Auto] to [None] in some of the tables, and
then save the change, the next time I open the table I can see the plus
signs at the left of the table rows. When I check the property in design
view, the property has reverted to [Auto].

I've never experienced this in my other applications. What I can do to
get the table to understand that I want to set the Subdatasheet Name
property to [None]?

Thanks in advance,

Paul

 

[AG]

What version of Access are you using?
I have noticed similar behavior in 2003.
I turn off subdatasheets for a table, and it sticks. However, the next time
I make any design changes to the table, subdatasheet name goes back to
[auto].
If I make the design changes using dao code, it does not affect the
subdatasheet name property, so I am guessing that it is a bug in Access as
opposed to Jet.

 

[Allen Browne]

Jeanette Cunningham's answer (turn off Name AutoCorrect) should solve your
issue as well.

If the table is attached, make sure you turn off Name AutoCorrect in the
back end as well as front, and then compact.

 

[Paul]

Jeanette and Allen - you're right - I had Name Autocorrect turned on, and
after I turned it off, the change stuck.

Thanks for solving my problem.


AG - I'm using Access 2003.

Paul

 

[AG]

Thanks Allen.
I always turn off name autocorrect in the front end, but never thought about
it in the back end.

--

AG
Email: npATadhdataDOTcom

Jeanette Cunningham's answer (turn off Name AutoCorrect) should solve your
issue as well.

If the table is attached, make sure you turn off Name AutoCorrect in the
back end as well as front, and then compact.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

What version of Access are you using?
I have noticed similar behavior in 2003.
I turn off subdatasheets for a table, and it sticks. However, the next
time I make any design changes to the table, subdatasheet name goes back
to [auto].
If I make the design changes using dao code, it does not affect the
subdatasheet name property, so I am guessing that it is a bug in Access
as opposed to Jet.