ODBC connection for ACCDE

[newaccess]

Hi Experts,

I created a data enter forms and works will linkedtable that by ODBC in Access 2007 .
Yesterday, I made a ACCDE and works well.
Today, I made a ACCDE from access application and does not appears a ODBC connect box.

Why ACCDE does not linke to ODBC? are there something I make changes?

Thanks for help!

Newaccesser

 

[boblarson]

You should be linking your tables BEFORE creating the ACCDE file and then distributing it. Why do you need to do this from the ACCDE?

 

[DCrake]

Hi BOB
Just to clarify, If I have a Accdb that has linked tables, these linked tables can be changed from one mdb backend to another. It is a multi company application that stores individual company details in their own mdb's. Not my idea it is a legacy system. The setup screen allows the user to select a company and the app refreshes the links.

Are you saying that an Accde will not allow this?

Do not really want to distribute as an accdb if at at all possible.

Edit:
Just realised we are talking about ODBC here, but the question still applies i think?

 

[boblarson]

you might be able to relink using mde/accde files but it really depends on how you are doing it. There are some things you can't do because it would amount to a design change and compiled files can't do that for most objects (tables, queries, and macros being the exceptions).

 

[DCrake]

There are no design changes taking place, the only thing that changes is the connection string in the MSysObjects table as per linked table manager.

The original vendor had unsplit databases one for each client. Any changes he made had to be replicated over all his apps. Finally getting him round to using a single front end with the facility to toggle to a different back end depending on client selection.

 

[newaccess]

Thanks for every experts.
I just used previous backup file to fix issue. I still do not know which issue resulted in ACCDE does not work. Does not mattaer whether we connect ODBC during ACCDE created.

Thanks
Newaccesser