BUG: Subdatasheet=[None]

[John Avitt]

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in the
user interface. I am able to set the value programmatically, so the problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

 

[Allen Browne]

I believe this bug is another of the long list associated with Name
AutoCorrect.

Try unchecking the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilites | Compact
If the table is attached, do that in the back end database as well.

Note that if it is an attached table, and the back end does not support
subdatasheets (e.g. an attached Access 97 database), the setting won't stick
because the property does not exist. With an A97 back end, you can
CreateProperty() on each TableDef so the property does exist, set it to
"[None]", and the front end will respect the setting.

For other problems caused by Name AutoCorrect:
http://members.iinet.net.au/~allenbrowne/bug-03.html
(There's more than a dozen in that list.)

 

[John Avitt]

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John

 

[tina]

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to open a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically). When I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in the
user interface. I am able to set the value programmatically, so the problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

 

[John Avitt]

I am working exclusively with Access 2000 format databases. I don't have any
choice at this point. Not all my users have Access 2003 yet.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to

open

a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically).

When

I

set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug

in
the

user interface. I am able to set the value programmatically, so the problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

 

[John Avitt]

This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003,
whether or not AutoCorrect is on.

When I create an Access 2002-2003 database, it works okay. Unfortunately, I
must use the Access 2000 format for now, since all my users are not yet
upgraded. I have no control over that.

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto], although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to

open

a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John

I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically).

When

I

set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug

in
the

user interface. I am able to set the value programmatically, so the problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

 

[Allen Browne]

John, it is possible to get A2003 to set SubdatasheetName to [None] for
tables in an A2000 database.

I have personally experienced the problem caused by Name AutoCorrect, as
have others. Once the database is corrupted in this way, Tina's suggestion
for rebuilding it is the way to go.

If your database is split, turn off Name AutoCorrect and set the property in
the back end as well. If it is split, and the back end in Access 97 format,
post back for specific instructions on how to handle that.

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

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

This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003,
whether or not AutoCorrect is on.

When I create an Access 2002-2003 database, it works okay. Unfortunately,
I
must use the Access 2000 format for now, since all my users are not yet
upgraded. I have no control over that.

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet Name to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still [None]. so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the
same
"reversion" problem as before.

hth

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto],
although I
don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to

open

a
module and run the code to change this property back to [None]. This is VERY
ANNOYING!

HELP!!!

John


I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically).

When

I
set the property to [None], save and close the table, then re-open
the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000.
I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention of the
appropriate person(s).

Thank you.

John

 

[tina]

oh, sorry, i misunderstood.
i do normally use A2000 format in A2003 software, myself, and have had not
had the problems you describe in setting the Subdatasheet Name to [None] in
design view. so i'm still thinking it's probably not a bug in the A2003 user
interface.
at any rate, starting "fresh" as i outlined before may work. good luck!

This issue apparently has nothing to do with Name AutoCorrect. It only
occurs when I am using an Access 2000 format database in Access 2003,
whether or not AutoCorrect is on.

When I create an Access 2002-2003 database, it works okay. Unfortunately, I
must use the Access 2000 format for now, since all my users are not yet
upgraded. I have no control over that.

Thank you.

John

does this happen in every A2003 database that you build? or just a
particular database?
my copy of A2003 is set to create new dbs in A2000 format. i just changed
the default to A2002-2003, and created a new db. i turned off Name Auto
Correct in the new db, then created a table and set the Subdatasheet

Name

to
[None]. after saving and closing the table, i re-opened it and found that
the setting was still [None]. i added another field to the table, saved and
closed. on re-open, the setting was still [None]. i compacted the db, closed
it, closed Access, then re-opened db and table - setting is still

[None].

so
it looks like the problem you describe is probably not a bug in the
software.
suggest you try creating a new, blank db and immediately turn off Name Auto
Correct. then import all the objects from your current db. set the
Subdatasheet Name to [None], and then test it and see if you have the same
"reversion" problem as before.

hth

Additional information.

Whenever I make *ANY* change to a table in design view, then save and close
the table, the Subdatasheet Name property is changed to [Auto],

although

I

don't notice the change until the next time I open the table.

This apparently has nothing to do with Name AutoCorrect. I turned that
feature off and it still does the same thing.

Now, every time I make a change to a table in design view, I have to

open

a
module and run the code to change this property back to [None]. This

is
VERY

ANNOYING!

HELP!!!

John


I have Microsoft Access 2003 and am trying to set the "Subdatasheet Name"
property on a table to [None] manually (i.e. not programmatically).

When

I
set the property to [None], save and close the table, then re-open the
table, the value has reverted back to [Auto]. This seems to be a bug in
the
user interface. I am able to set the value programmatically, so the
problem
is in the user interface. I never had this problem with Access 2000. I
typically make this change programmatically, but when I have just one
table
to fix, it is much easier to do it "by hand".

I cannot find anywhere on the Microsoft website to report a bug, so
hopefully someone will see this post and bring it to the attention

of
the

appropriate person(s).

Thank you.

John