Cannot open database " when running a Make Table query

T

tobin@mio

When running a Make Table query in Access 2007, I receive the following error:
Cannot open database ". It may not be a database that your
application recognizes, or the file may be corrupt.

As you see, there's no database name. I've tried repairing the database
that I am using, but to no avail. If I run the same query as a Select, it
displays the information perfectly.

Anyone have any ideas what is causing this and how to rectify it?
-- Tobin
 
J

Jeff Boyce

Tobin

Often, it isn't actually necessary to "make" a new table. Have you tried
creating the table structure you want to use, then using an Append query to
load it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top