Connecting Tech Pros Worldwide Forums | Help | Site Map

subdatasheet = [none]

Fred Zuckerman
Guest
 
Posts: n/a
#1: Nov 14 '06
I read in this group, that setting the subdatasheet property to [none] for
linked tables is recommended. In my database I have 4 linked tables. They
are all ODBC links to views on a SQL server. I change the table property
from [auto] to [none] and save. But when I re-open they are reset to [auto].
Can someone help? I also read that this occurs in Access97, but my database
is Access2000 on W98.
TIA,
Fred Zuckerman



Jeff L
Guest
 
Posts: n/a
#2: Nov 14 '06

re: subdatasheet = [none]


You cannot change settings/properties in a linked table.


Fred Zuckerman wrote:
Quote:
I read in this group, that setting the subdatasheet property to [none] for
linked tables is recommended. In my database I have 4 linked tables. They
are all ODBC links to views on a SQL server. I change the table property
from [auto] to [none] and save. But when I re-open they are reset to [auto].
Can someone help? I also read that this occurs in Access97, but my database
is Access2000 on W98.
TIA,
Fred Zuckerman
Closed Thread