split database question

[George Applegate]

Hello,

If I split a data base into a front end/back end arrangement, putting
my tables in the back-end and forms/queries/etc into the front end, I
am wondering, can I create multiple FRONT-ENDS? In other words, my
back end with the tables stays the same. But can I create multiple
front ends that link to the same back end? Then I could have
different queries and forms for each front end? I have a project I am
considering rolling out to different locations and while I know there
are security issues this doesn't resolve, I am thinking I could at
least just have a single query/from for each location if I could have
multiple front ends - a front end for each location.

Is that feasible? I know it might involve more maintenance down the
road but it's going to be a pretty static application so I don't
foresee that as a problem.

Thanks for your advice/suggestions.
ga

George Applegate
(e-mail address removed)

 

[Rick Brandt]

Hello,

If I split a data base into a front end/back end arrangement, putting
my tables in the back-end and forms/queries/etc into the front end, I
am wondering, can I create multiple FRONT-ENDS? In other words, my
back end with the tables stays the same. But can I create multiple
front ends that link to the same back end? Then I could have
different queries and forms for each front end? I have a project I am
considering rolling out to different locations and while I know there
are security issues this doesn't resolve, I am thinking I could at
least just have a single query/from for each location if I could have
multiple front ends - a front end for each location.

Is that feasible? I know it might involve more maintenance down the
road but it's going to be a pretty static application so I don't
foresee that as a problem.

It's not only feasible it's the preferred method. Even when they are
identical, each user of a split app should get their own locally installed
copy of the front end.

If multiple users can have separate identical copies of the front end then
it should be obvious that multiple front ends that are not identical are
also possible.

 

[Ken Snell \(MVP\)]

Short answer: Yes, you can have widely different front end files that use
the same back end file.

 

[Tony Toews [MVP]]

I have a project I am
considering rolling out to different locations

Where are these different locations? How fast/wide is the network
connection between those different locations and the server where the
database resides?

If slower than 100 mpbs then there will be severe performance problems
and greatly increased chance of corruptions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/