Error: Cannot Open database ". When I select make table option.

[EDDY20XX]

Hi,

I linked table rawdata from a database called competitor from a ODBC Database. I run a query with to make a table with a criteria where it retrieves roughly 10 columns with 719,000 rows. And it gives me this error.

(Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.

I asked the creator of the database and they said the database grows automatically and it was created with the same Access version as i am using to run the query.

Also when I do a RUN without creating a table and just selecting and displaying the data it does not give me any issues.
:banghead::banghead::banghead:
Any help will be appreciated.

 

[boblarson]

How are you linking and from what are you linking? Are you linking from an Access database to another Access database? If so, ODBC should not be in the mix. You would link directly.

 

[EDDY20XX]

No Not directly from a Access database. It is on my companies server and not on my computer but i figured out the problem, and it is because when i run the query i go over 2 GB limit Access have on my computer, is there a way to increase the 2 GB limit?

 

[boblarson]

is there a way to increase the 2 GB limit?

The only real good way is to move to SQL Server 2008 Express which has a data limit of 10 GB.

 

[EDDY20XX]

Thank you i currently have SQL Server Management Studio that i downloaded for free but need to learn how to write out simple queries and get used to it more. Thank you for your help. You will see more of me on here