Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do add tables, forms and reports to a split database

Status
Not open for further replies.

Rmcta

Technical User
Nov 1, 2002
478
US
A while back I created a database and split it into Front and Back end.
I now need to add a couple of tables, forms and reports to it.
I have created them all in a temporary database and all is working. I am ready to import all the parts into the production db but I am not sure how to proceed as the production db has been split.
Can someone please guide me?
Thank you
 
Import all the tables to the backend and the forms, queries and reports to the front end.
Then link all the new tables in the front end to the backend. Hope that helps.
 
Thank you for your quick reply.
I just imported the tables in the backend and forms, queries and reports into the front end.
What are not the steps to link the new tables?
 
Sorry....I meant to say: "What are now the steps.."
 
Right click on the list of tables (not a table name) in the FE. Choose Link Tables.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
 
Please forgive my ignorance...
Must I be in the fron-end or back-end?
What is FE?
Thank you for guiding me!
 
Sorry...FE must be Front End.
I go to tool/database utilities/link table manager but I only see the old tables listed..?
 
I got it. Thank you :)
Sorry for my confusion.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top