Settiing table property Subddatasheet to [None]

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

For an entire database, is there anyway to set subdatasheets to [None]? I
want all of the tables to be set to [None].

I just went through the exercise of walking through each table's properties,
setting it to [None], saving it - only to have hit seemingly reset itself
back to [Auto].
 
Code sample:

http://support.microsoft.com/?kbid=261000
BUG: Slower performance on linked tables in Access 2000

The property is a table property, and is displayed for linked
tables, but if you want to change it, you have to go to where
the table is (the Back End of a split database) to make the
change.

The default value of the property is [auto], so if you link
to an A97 (jet 3.5) database, you will see [auto]. The property
can be set to [none] in an A97 database, but you have to create
the property if it is missing. The code sample does this.

A2000 prevents you from making design changes to an A97 database,
so I think you can't just open an A97 database in design mode
and make this change by hand, but I think the code will work.
(If not, you would just have to use OpenDatabase instead of
CurrentDB to get a reference to the A97 database to make changes.)

(david)
 
Thanks for the code sample. Woked like a charm.

david epsom dot com dot au said:
Code sample:

http://support.microsoft.com/?kbid=261000
BUG: Slower performance on linked tables in Access 2000

The property is a table property, and is displayed for linked
tables, but if you want to change it, you have to go to where
the table is (the Back End of a split database) to make the
change.

The default value of the property is [auto], so if you link
to an A97 (jet 3.5) database, you will see [auto]. The property
can be set to [none] in an A97 database, but you have to create
the property if it is missing. The code sample does this.

A2000 prevents you from making design changes to an A97 database,
so I think you can't just open an A97 database in design mode
and make this change by hand, but I think the code will work.
(If not, you would just have to use OpenDatabase instead of
CurrentDB to get a reference to the A97 database to make changes.)

(david)


Dkline said:
For an entire database, is there anyway to set subdatasheets to [None]? I
want all of the tables to be set to [None].

I just went through the exercise of walking through each table's properties,
setting it to [None], saving it - only to have hit seemingly reset itself
back to [Auto].
Click to expand...
Click to expand...
 
Back
Top