Problem With Creating a Report: I have a Select Query based off of 5 other Select Queries; which includes 2 Tables. The query works just fine. I tried to create a new report both in Design View and Report Wizard. When I try to execute the report after selecting either all or part of the components of that query, Microsoft Access Dialog Box displays: “The wizard is unable to preview your report, possibly because another user has a source table open in exclusive mode. Your report will be opened in design view.” Next, I try to view the report which the error displays: “Warning: Not a valid alias name.”, Error 3068 via the help menu. There is no help word with the first error. I am the only user of the database, the local IMO office has control on the server. To help resolve the problem, I created individual reports both in Design View and Report Wizard based on each of the other 5 queries and 2 tables. There is no problem creating and viewing them. It is only in this one query where I have these 2 Errors. If it helps, I have provided the SQL of the query involved. I have done a Compact and Repair with no success to resolve this issue.
Question 1: If the Query works, why can’t a report be designed from it?
Question 2: I have 9 tables, including a Switchboard items table in the database. If the error says “source table open in exclusive mode”, is there a tool within Access 2000 to use to check on the status of open tables, ie: which table is in exclusive mode? Thank you very much for your help. Cal.
Query Name: qrySelect UNM3 qry UNM2 FINAL
SELECT [qrySelect UNM2 qryUM1 tblAllReq].EmployeeID, [DTHC Employees].LastName, [DTHC Employees].FirstName, [DTHC Employees].RankID, [DTHC Employees].ServiceID, [DTHC Employees].TitleID, [DTHC Employees].DepartmentID, [DTHC Employees].ClinicID, [qrySelect UNM2 qryUM1 tblAllReq].ETID, [qrySelect UNM2 qryUM1 tblAllReq].Requirements
FROM [DTHC Employees] INNER JOIN [qrySelect UNM2 qryUM1 tblAllReq] ON [DTHC Employees].EmployeeID = [qrySelect UNM2 qryUM1 tblAllReq].EmployeeID
ORDER BY [DTHC Employees].LastName, [DTHC Employees].FirstName, [qrySelect UNM2 qryUM1 tblAllReq].Requirements;
Question 1: If the Query works, why can’t a report be designed from it?
Question 2: I have 9 tables, including a Switchboard items table in the database. If the error says “source table open in exclusive mode”, is there a tool within Access 2000 to use to check on the status of open tables, ie: which table is in exclusive mode? Thank you very much for your help. Cal.
Query Name: qrySelect UNM3 qry UNM2 FINAL
SELECT [qrySelect UNM2 qryUM1 tblAllReq].EmployeeID, [DTHC Employees].LastName, [DTHC Employees].FirstName, [DTHC Employees].RankID, [DTHC Employees].ServiceID, [DTHC Employees].TitleID, [DTHC Employees].DepartmentID, [DTHC Employees].ClinicID, [qrySelect UNM2 qryUM1 tblAllReq].ETID, [qrySelect UNM2 qryUM1 tblAllReq].Requirements
FROM [DTHC Employees] INNER JOIN [qrySelect UNM2 qryUM1 tblAllReq] ON [DTHC Employees].EmployeeID = [qrySelect UNM2 qryUM1 tblAllReq].EmployeeID
ORDER BY [DTHC Employees].LastName, [DTHC Employees].FirstName, [qrySelect UNM2 qryUM1 tblAllReq].Requirements;
