Jet database cannot find table or query...

C

Chris Wagner

Access 2000

Yes I've changed the name of the table..... to make it have more
sense ("Testing Company Table" to just 'Company')

I just figured that I could go into the report design and change one
setting to where it looked for the newly named table... but without luck

Any suggestions.... besides changing the name back

Thanks
Chris Wagner
 
D

Dirk Goldgar

Chris Wagner said:
Access 2000

Yes I've changed the name of the table..... to make it have more
sense ("Testing Company Table" to just 'Company')

I just figured that I could go into the report design and change one
setting to where it looked for the newly named table... but without
luck

Any suggestions.... besides changing the name back
Click to expand...

A little more detail would be helpful. You're getting this message when
you try to run a report? Check the report's RecordSource property. If
it's a SQL statement, edit the statement to change the table name
wherever it appears. If it's a stored query, open the query in SQL View
and edit the SQL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with jet database 3
Jet database engine cannot find the input table or query 3
The Microsoft Jet database engine cannot find the input table or q 1
Jet database cannot find msysdb....... 2
Try to open table get this error - Microsoft Jet database (Error 3 2
cannot find MSysAccessObjects 2
SQL Upsizing Problem with Left Join Queries 19
MS Jet Database Engine could not find the column 'colText' 2

Top