MS Jet database engine cannot find the input table or query

[warpcon]

Im trying to build a database starting with one of the templates that come with access. I took out the employee part in all the tables and forms. Now when I pull up a workorder and then try to view the report on it it gives me the message " Ms jet database engine cannot find the input table or query ' Employees'. Make sure it exists and that its name is spelled correctly.

I deleted the employee parts on purpose because I didnt need it. Where do i find the parts that are hiding so i can delete them too to stop getting that message? Iv looked everywhere in the tables and forms and there is no more employees section listed.

[warpcon]

If you cannot delete or update parts of the database sometimes, what good is it? Is there a better RD database solution? I need to be able to change it around every once in a while without it hiding things you cannot see.

[Scott Price]

What version of Access are you using?

Is the report bound to a table or a query?

What code is running on the Load event of the report?

Answers to these three questions will help us help you solve the problem!

Regards,
Scott

[warpcon]

It is access 2002. I dont think its bound to anything because i deleted everything i could find in the tables , queries and forms that have to do with the employees part. How do you see the code? Is this something in the background? I know a little basic programming and some c and c++. If i can manipulate code that might help me out some.

Another thing, I Have a customer table and made a auto form for it. And then I made a workorder table and made a auto form for it too. When I click the workorder command button on the customer form I need it to open the workorder form and load all the info automaticaly. I have it opening the workorder form, but it isnt loading the info. I tried the relationships but I think im doing it backwards. If I make what they call a juntion table and then relationship the 2 forms, cutomers and workorders, is this the correct way to auto load informatin?

[Scott Price]

For starters a good book on Access is a must! Make sure it's at least two inches thick (not a joke). They can be found cheaply on Amazon.com.

To view the code, first of all open the report in design view. Click on the Events tab and see if there are any entries in the fields shown, especially the OnLoad event. If so, double click on the ellipsis (...) to the right of the field to view the code associated with that event.

You can also open the VBA editor window by pressing Alt+F11 from the main database window. Doing it this way would require you to navigate to the report's code module manually by using the tree view on the left of the VBA editor window.

The answer to your other questions can be found in the book... I'm not trying to put you down, just want you to realize that providing a basic understanding of how databases, and especially Access works is beyond the scope of this forum. I want to encourage your learning process, and I applaud your desire to learn! You can browse our Howtos section, especially Normalisation and Table structures also to get a better understanding of how relationships between tables work.


Kind regards,
Scott

[warpcon]

What book would you recomend?

[Scott Price]

One of the standard reference works is the Access 200x Developers Handbook by Getz and Litwin.

Good luck!

Regards,
Scott