Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

microsoft access question

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

microsoft access question

Old 07-29-04, 02:37 PM
  #1  
Member
Thread Starter
 
Join Date: Oct 2002
Location: New York
Posts: 225
Likes: 0
Received 0 Likes on 0 Posts
microsoft access question

im trying to match one list against another in access but it keeps telling me this:

the wizard is unable to open your query in datasheet mode, possibly because another user has a source table open in exclusive mode. your query will be opened in design view.

i just rebooted & got started on this quickly to minimize other things getting in the way & it still won't work. ive done this type of query before, import 2 tables, edit relationships & make query. dunno why its not working now. anyone have any clues?
Old 07-30-04, 01:56 AM
  #2  
DVD Talk Ultimate Edition
 
Join Date: Jan 2001
Location: Seattle
Posts: 4,454
Likes: 0
Received 0 Likes on 0 Posts
Were both tables created on the same PC?
Old 07-30-04, 09:16 AM
  #3  
Member
Thread Starter
 
Join Date: Oct 2002
Location: New York
Posts: 225
Likes: 0
Received 0 Likes on 0 Posts
one table was, the second was a spreadsheet created by someone else. the first table i had used in queries before, so im assuming it must be something wrong with the second table. but i was also able to run a query using the second table against a third table, it just won't run against the first table. i dont know what the problem is. i even tried to do everything from scratch, except recreating the data. i am suspecting the data more & more. any other suggestions?

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.