Linking Forms

[StuJol]

i have an Access2003 database, split into a FE & BE. All tables in BE are
linked into FE. Is it possible to have a form in the BE linked to the FE.

Im looking at placing all my forms, qrys, reports in several seperate
databases with my main FE database consisting of links. is this possible?

 

[Wayne-I-M]

Put your forms on the FE - on each copy.

Link the tables not the forms

 

[Ken Sheridan]

It could be done, but its cumbersome, inefficient and serves no purpose.
What you'd have to do is create a public function in the back end file to
open the form, create a reference to the back end file in the front end so as
to expose the functions in the back end, and then call the function to open
the form.

While this is theoretically possible it brings to mind Samuel Johnson's
remark about a dog walking on its hind legs, in that the wonder is not that
its done well but that its done at all. The basic model of having a back end
file containing the tables only, and a front end file containing the forms,
reports, queries, modules etc is a tried and tested one which allows for easy
maintenance and efficient operation, so I can see no reason for departing.

You can of course have more than one front end file linked to the same back
end file; you might different ones for different user groups for instance,
giving each the functionality appropriate to the group in question.

Ken Sheridan
Stafford, England

 

[Dominic Vella]

I figure the idea is great, in that it would be easier to perform Front End
upgrades if they were linked to a central database, however that idea does
not work in MS-Access. Only tables are linked.

Besides, the idea of not having other components linked is to provide
maximum speed. Having all the forms working over many computers is much
more efficient.


Dom

 

[StuJol]

thanks for your comments

 

[Michael Washington]

response

thanks for your comments

 

[Michael Washington]

ok

I figure the idea is great, in that it would be easier to perform Front End
upgrades if they were linked to a central database, however that idea does
not work in MS-Access. Only tables are linked.

Besides, the idea of not having other components linked is to provide
maximum speed. Having all the forms working over many computers is much
more efficient.


Dom