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

Subdatasheets for linked SQL Server Tables

P: n/a
I would appreciate any help with this. At my wit's end.

I have an access front end linking to SQL Server tables on the back
end.
One of these linked tables had a subdatasheet to another of the linked
tables, until I changed the schema on some tables and relinked them.
Now I cannot re-establish the subdatasheet link!!! Creating the
relationship in access doesn't work and the INSERT subdatasheet
command stays greyed out. No problem if I import the data into access,
but that's not an acceptable solution for me.

HELP>
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DFS
Douglas,

I believe you can do this:

1) write a query against your main table: SELECT * FROM TABLE

2) write a query against the table you want to use as the subdatasheet.

3) Open query #1 and choose Insert | Subdatasheet and use query #2


"Douglas Lane" <dl***@virginia.edu> wrote in message
news:bf**************************@posting.google.c om...
I would appreciate any help with this. At my wit's end.

I have an access front end linking to SQL Server tables on the back
end.
One of these linked tables had a subdatasheet to another of the linked
tables, until I changed the schema on some tables and relinked them.
Now I cannot re-establish the subdatasheet link!!! Creating the
relationship in access doesn't work and the INSERT subdatasheet
command stays greyed out. No problem if I import the data into access,
but that's not an acceptable solution for me.

HELP>

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.