Dear spearse- (name?)
1) Did you import or link the Excel data?
2) What is the SQL from your query?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of spearse@sfsu.edu
Sent: Monday, October 28, 2013 5:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: MS Access Message / I am confused
So I saved and closed the Access database. Then navigated to the link I saved. When I reran the query it then gave me a "Type Mismatch in Expression" message.
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Built a simple MS Access query from two imported Excel files, which are closed and not open by anyone else, and I am getting the following message:
"The wizard is unable to open your query in Datasheet view, possibly because another user has the source table open in exclusive mode. Your query will be opened in Design view."
I don't understand. There are no other users.
Thanks.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar