Data binding to an external database

[Guest]

Hi all

I am currently working on what will be a multiuser Access application. I will be deploying a central database and the application will be distributed (as an mde file) to all the clients. So far I have worked with unbound form and have been able to pull the data from my central database onto my forms. However, I now need to create a sub form list multiple records from one of the tables in my central database. Is there a way to, either, bind my subform to the central database at design time (and maintain this connection at runtime, taking into account that the final location of the central database at run-time can vary), or programatically bind the sub form at runtime

As a last resort, I am thinking of temporarily copying the records from the central database into the MDE file at runtime and read the records from there, but that is not a very clean solution and I was hoping that someone out there might have a solution for me

Any help would be greatly appreciated

Thanks and Regards

Francoi

 

[Nikos Yannacopoulos]

Francois,

Copying the records from the central database into the MDE file at runtime
and reading the records from thereis not a very clean solution indeed, I
couldn't agree more! I've had similar situations, and the way I dealt with
them and which has proven a reliable solution is this: instead of using a
subform on the main form, I employ a separate form opened through a command
button on the main one; the "subform" is permanently connected to the table
in the BE, and the command line opening it from the main form just applies a
filter so it only retrieves the records pertaining to the current record on
the main form. Perhaps you might consider this option.

HTH,
Nikos

Hi all,

I am currently working on what will be a multiuser Access application. I

will be deploying a central database and the application will be distributed
(as an mde file) to all the clients. So far I have worked with unbound form
and have been able to pull the data from my central database onto my forms.
However, I now need to create a sub form list multiple records from one of
the tables in my central database. Is there a way to, either, bind my
subform to the central database at design time (and maintain this connection
at runtime, taking into account that the final location of the central
database at run-time can vary), or programatically bind the sub form at
runtime?

As a last resort, I am thinking of temporarily copying the records from

the central database into the MDE file at runtime and read the records from
there, but that is not a very clean solution and I was hoping that someone
out there might have a solution for me.

 

[solex]

Francois,

I may be simplifying your problem, but why are you working in the unbound
mode, the reason to use access as a development tool lies in it data binding
abilities?

Also why not bind the sub form as you suggest and when the final location of
the database is determined use the linked table manager to update the links?
Or if you have multiple environments (dev, test, productions etc) and the
user can select one dynamically then you can invoke the linked table manager
from the client with various utilites like this one:
http://www.peterssoftware.com/tlk.htm.

Regards,
Dan

Hi all,

I am currently working on what will be a multiuser Access application. I

will be deploying a central database and the application will be distributed
(as an mde file) to all the clients. So far I have worked with unbound form
and have been able to pull the data from my central database onto my forms.
However, I now need to create a sub form list multiple records from one of
the tables in my central database. Is there a way to, either, bind my
subform to the central database at design time (and maintain this connection
at runtime, taking into account that the final location of the central
database at run-time can vary), or programatically bind the sub form at
runtime?

As a last resort, I am thinking of temporarily copying the records from

the central database into the MDE file at runtime and read the records from
there, but that is not a very clean solution and I was hoping that someone
out there might have a solution for me.