New front end same backend but need to insert new table.

[extrhman]

I have a Front end that I have revamped. I need to come up with an installation package that will automatically install the front end and add a new table to the backend and link the table. I know how to create an installation package but have never just inserted and linked a table in the backend before. I have heard that you can create an access app that will do this but I can't seem to find any info on it.

Thanks

 

[risicare]

I don't have a ready made solution, but I think I would approach it this way.
1. Have code in the front-end start-up form create the new table in the back-end database. I'm not sure how to code relationships but there must be a way.
2. Then run the start-up code that checks the links between the front-end and back-end and get the user to establish the link to the new table.
3. Next time you distribute the front-end leave out the code to create the table.
Cheers
Jason