473,406 Members | 2,336 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

subdatasheet = [none]

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
1 2285
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: astro | last post by:
I'm trying to get a subdataSheet embedded on a form which will be displayed in datasheet view. I setup the 'record source' for the form to a query on a table. I go into the query properties and...
2
by: James | last post by:
Hi I have set up a subform in datasheet mode containing a second subform also in datasheet mode in order to be able to open it as a subdatasheet. In my application I make the first subform...
2
by: karen scheu via AccessMonster.com | last post by:
I am having trouble lately opening my local tables. It is taking a a few seconds to open the table that has no records in it. I read that there is a bug with the AutoCorrect feature and so I set...
1
by: Jim M | last post by:
After learning that the 'subdatasheet name' property set to "" can adversely effect database speed, I wanted to send a small code snippent to my end users to reset the SubdatasheetName Property so...
0
by: ray | last post by:
Hi all, I have seen and tried some code posted here to reset the Subdatasheet property of Tables to NONE. It works fine in DAO, but I am using an ADP. So that means that the code won't work,...
8
by: ray | last post by:
I am at the moment manually setting Subdatasheet to in all the tables in this adp. If anybody can put me out of my misery by suggesting some automated way to do it, I would be most grateful. I...
0
by: burningthemidniteoil | last post by:
I have access 2002. I have a query that diplays a subdatasheet ( +/- subtrees are shown on the record), but when i make a datasheet form out of that query , it does not display the plus (+) and...
1
by: Simon | last post by:
Dear reader, By default the "Subdatasheet name" of a table is set to . If I change the setting to and save the changes the table property Subdatasheet name is still set to .
2
by: Bob Darlington | last post by:
I have a routine which creates a new table using "SELECT INTO ....." Is there anyway to set the default Subdatasheet name property to 'None' for new tables? Or do I need to run a separate routine...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.