I am hoping to get some urgent help me on this. My database has a main table with a linking table and sub tables. When I try to run a query from either the main table or sub tables by themselves I get the data pulled correctly. However when i try to combine data from the main table and the sub tables I get this message "The wizard is unable to open your query in datasheet view because another user has a source table openin exclusive view. Your query will be opened in design view". I suspect the links are not exactly right but can someone shed some light. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with query
- Thread starter germain2
- Start date
Similar threads
- Locked
- Question