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

Unable To set A2k .SubDataSheetName in A2003?

P: n/a
I keep on changing it from '[Auto]' o '[None]', but it reverts to ['Auto']
when I save the table design.

Seems like if I'm in Access 2003 with DbFormat=Access 2000, I cannot change
that property.

True?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, 21 Jan 2005 13:17:18 -0500, "cresswell" <x@y.z> wrote:
I keep on changing it from '[Auto]' o '[None]', but it reverts to ['Auto']
when I save the table design.

Seems like if I'm in Access 2003 with DbFormat=Access 2000, I cannot change
that property.

True?
Hi

Usually later versions of Access treat earlier versions as read-only
David

Nov 13 '05 #2

P: n/a
On Jan 21 2005, 01:17 pm, "cresswell" <x@y.z> wrote in
news:35*************@individual.net:
I keep on changing it from '[Auto]' o '[None]', but it reverts to
['Auto'] when I save the table design.

Seems like if I'm in Access 2003 with DbFormat=Access 2000, I cannot
change that property.


Most likely, you need to create and append the SubdataSheetName property
(or whatever it's called) to the Properties collection of the tabledef
from code first, then your changes in the table design view will stick.

For more information (and I mean a lot more...), see this thread:
http://groups-beta.google.com/group/comp.databases.ms-
access/browse_thread/thread/63ef07102350fb72/e8c6376970aff7ca

--
remove a 9 to reply by email
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.