Table Analyzer Issue

[bhipwell via AccessMonster.com]

Hi,

I am using the table analyzer to break up a table that has grown too big. I
am manually breaking up the tables (versus having the wizard do it).

Now that the anaylzer has created a "matching" query so that I don't have to
update any forms and reports, I am now getting the error:

"Jet database engine cannot find the input table or query 'TBLCompanyInfo'"

If I go into a specific form and reselect the newly created query, it still
does not work.

Any ideas?

B

 

[Jeff Boyce]

see comments in-line below...

Hi,

I am using the table analyzer to break up a table that has grown too big.
I
am manually breaking up the tables (versus having the wizard do it).

I'm confused. Are you using the table analyzer/wizard or not?

When you say "grown too big", what do you mean? We may not share your
definition.

When you say "breaking up the tables", what do you mean? ...

Now that the anaylzer has created a "matching" query so that I don't have
to
update any forms and reports, I am now getting the error:

What is the SQL statement of that query? Copy it from the query's design
view and post it back.

"Jet database engine cannot find the input table or query
'TBLCompanyInfo'"

The error message says something is missing. If you open the query in
design view, does it have all it's pieces (e.g., tables and/or queries as
sources)?

If I go into a specific form and reselect the newly created query, it
still
does not work.

How are you "reselect[ing] the newly created query" in a form? Do you mean
you are trying to set the source for the form to the newly created query?
If the query isn't working, the form based on it surely won't.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[bhipwell via AccessMonster.com]

Sorry for not being more precise. However, I believe I figured out my issue.


It is a FE / BE issue...

When the table analyzer creates the new query that is designed to replicate
your original table (and thus not require you to update every form and
document), the new query is saved in the BE database.

In order for your forms and reports to work, the new query has to be moved to
the FE database as well as have new links created to the two (or more) new
table that have been created.

Thanks for you quick reply though!

B