Share via

Cannot Open database on Make Table Query

Anonymous
2011-12-21T22:37:57+00:00

I am getting a "Cannot open database ".It may not be a database that your application recognizes, or the file may be corrupt." error when trying to Make a Table with a Query by combining to tables in Access 2010. Any suggestions would be great! Thanks.

This is a simpe query with no added SQL

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-12-22T16:10:54+00:00

    UPDATE [hisc sc -2] SET [hisc sc -2].SuperChain = [hisc sc -2]![Chain]

    WHERE ((([hisc sc -2].SuperChain) Is Null));

    This is from a different Query where I am trying to update empty "superchain" fields to what is in the Chain field. It has worked in the past, but now it doesn't.

    Also my Make tables queries worked today, but did not yesterday.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-12-22T00:38:19+00:00

    Could you post the SQL of the query here?  Are any of the tables linked?

    Was this answer helpful?

    0 comments