Subdatasheet Name keeps resetting to [Auto]

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

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


"Paul" wrote in message
...
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

That should have read--
backup and compact the database


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Jeanette Cunningham" wrote in message
...
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


"Paul" wrote in message
...
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

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.

--

AG
Email: npATadhdataDOTcom


"Paul" wrote in message
...
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'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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AG" wrote in message
...
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.

--

AG
Email: npATadhdataDOTcom

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

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

--

AG
Email: npATadhdataDOTcom


"Allen Browne" wrote in message
...
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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"AG" wrote in message
...
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.

--

AG
Email: npATadhdataDOTcom