Subdatasheet Name keeps resetting to [Auto]

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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
 
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
 
That should have read-->
backup and compact the database


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Jeanette Cunningham said:
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 said:
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
Click to expand...
Click to expand...
 
That should have read-->
backup and compact the database


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Jeanette Cunningham said:
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 said:
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
Click to expand...
Click to expand...
 
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.
 
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.
 
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.
 
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.
 
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
 
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 said:
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.

AG said:
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.
Click to expand...
Click to expand...
 
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 said:
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.

AG said:
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.
Click to expand...
Click to expand...
 
Back
Top