I am trying to use SQL pass thru queries in Ms Access 2000 to query our Call Center tables (application is Clarify) which are on a 7.0 SQL Server located on the network.
Here is my SELECT statement:
Select id_number, creation_time INTO table_raw from table_case
When I run this query I get an error message saying:
CREATE table permission denied, database 'Clarify', owner 'dbo.'
I have tried variation on the table raw path trying to get the table to be written onto my hard drive not on the SQL Server but have not been successful and haven't seen any examples detailing an answer to this particular problem.
thanks
Here is my SELECT statement:
Select id_number, creation_time INTO table_raw from table_case
When I run this query I get an error message saying:
CREATE table permission denied, database 'Clarify', owner 'dbo.'
I have tried variation on the table raw path trying to get the table to be written onto my hard drive not on the SQL Server but have not been successful and haven't seen any examples detailing an answer to this particular problem.
thanks