BUG: Subdatasheet=[None]

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

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


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


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

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


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


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


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

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


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


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


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

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


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


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


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

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


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


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


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

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


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


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


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

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


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


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


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

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!


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


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


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


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

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!


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


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


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


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

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!


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


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


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


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