A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

What does this query error message mean: Cannot open database ".



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 06:03 PM posted to microsoft.public.access.queries
Peter
external usenet poster
 
Posts: 962
Default What does this query error message mean: Cannot open database ".

I get a weird error message when I try to run a make table query, but yet the
same query will work as a select query. I know the file isn't currupt, as
I've used different versions of the database. The full error message reads:

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

Ads
  #2  
Old May 14th, 2010, 07:35 PM posted to microsoft.public.access.queries
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default What does this query error message mean: Cannot open database ".

Please post the SQL statement for the query. Maybe we can figure out
something from it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"peter" wrote:

I get a weird error message when I try to run a make table query, but yet the
same query will work as a select query. I know the file isn't currupt, as
I've used different versions of the database. The full error message reads:

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

  #3  
Old May 14th, 2010, 08:24 PM posted to microsoft.public.access.queries
Bob Barrows
external usenet poster
 
Posts: 475
Default What does this query error message mean: Cannot open database ".

peter wrote:
I get a weird error message when I try to run a make table query, but
yet the same query will work as a select query. I know the file isn't
currupt, as I've used different versions of the database. The full
error message reads:

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


Permissions issue? All users of a database file require Modify
permissions for the folder containing the database file if multi-user
activity is required.

Is the database read-only?

I've only ever seen this error message when access remote databases or
from external applications. Is this query attempting to make a table in
another database file?

http://www.google.com/search?hl=en&safe=active&q=error+%22cannot+open+da tabase+''%22+%22It+may+not+be+a+database+that+your +application+recognizes%22Access&aq=f&aqi=&aql=&oq =&gs_rfai=
--
HTH,
Bob Barrows


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.