Question Dynamically relink on FE to existing and new tables on BE

[BrunoBB]

Hi folks,

New to Access and need your help...

I've split my mdb into FE and BE. My application is such that new tables will be created almost daily. What I'd like to do on the FE is dynamically relink to existing and any new tables added on the BE, but I'm not sure how to go about it in VBA.... Do I just need to push out a new FE everytime a new table is added to the BE? Is there a solution whereby I don't have to push out a new version of the FE (which would contain the linked tables (both old and new)?

Your help would be much appreciated.

Forgot to mention: Access 2003

Thanks!

 

[boblarson]

My application is such that new tables will be created almost daily.

That doesn't sound like a normalized design. WHY is it such that new tables will be created almost daily? Sounds like you might need to do some design changes because in a well-designed database you would RARELY need new tables or even new fields.

 

[BrunoBB]

Good point Bob. You're correct that it's not a well designed (normalized) data model.

Some background...
My users are entering data into a handful of standardized Excel templates. Each template corresponds to a different entity (can't get too specific). Users can also add columns to each of these templates to customize the information provided (or rather they are adding additional data not included in the template). This type of activity will be different for each "entity".

So, since I can't know in advance what the table structure is going to look like (except for the fields on the templates), I decided to import the Excel spreadsheets and store them as tables... I know - ick. But, I couldn't think of another way of accomplishing my goal.

I'm open to suggestions...

Thanks for taking the time to respond.