By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

subdatasheet = [none]

P: n/a
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
Nov 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You cannot change settings/properties in a linked table.
Fred Zuckerman wrote:
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
Nov 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.