By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Converting access to application

P: n/a
I have a project going on to store data for inventory information. Creating
a database with access makes me realise all things like the data tables and
user interface(forms) and queries are all incorporated to one file. I wish
to split the user interface from the database table itself so that the user
interface can be stored locally on a local computer and the data(tables) is
stored in the server. Is there any way we can do this? Having VB to do all
this is out of the question as my company do not have license to it. Thanks
in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
SecretCharacter wrote:
I have a project going on to store data for inventory information. Creating
a database with access makes me realise all things like the data tables and
user interface(forms) and queries are all incorporated to one file. I wish
to split the user interface from the database table itself so that the user
interface can be stored locally on a local computer and the data(tables) is
stored in the server. Is there any way we can do this? Having VB to do all
this is out of the question as my company do not have license to it. Thanks
in advance.


Access has a utility called the "Database Splitter." In Access versions
2000 and greater, it is found under the Tools menu bar, Database
Utilities. Versions less than 2000 it is under Tools > Options > Add-ins.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

P: n/a
"SecretCharacter" wrote
... I wish to split the user interface from
the database table itself so that the user
interface can be stored locally on a local
computer and the data(tables) is
stored in the server. ...


That is a good idea -- it is recommended by all "authorities" on using
Access in a multiuser environment. For more on that subject, there's an
introductory presentation on Access in a Multiuser Environment that I did
for my user group that you can download from http://appdevissues.tripod.com.
It will identify topics that I thought worthwhile to discuss, and a bit
more. The best collection of detailed information and links on the subject
of Access in the multiuser environment is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #3

P: n/a
"SecretCharacter" <th******@singnet.com.sg> wrote:
I have a project going on to store data for inventory information. Creating
a database with access makes me realise all things like the data tables and
user interface(forms) and queries are all incorporated to one file. I wish
to split the user interface from the database table itself so that the user
interface can be stored locally on a local computer and the data(tables) is
stored in the server. Is there any way we can do this? Having VB to do all
this is out of the question as my company do not have license to it. Thanks
in advance.


You want to split the MDB into a front end containing the queries, forms, reports,
macros and modules with just the tables and relationships. The FE is copied to each
network users computer. The FE MDB is linked to the tables in the back end MDB
which resides on a server. You make updates to the FE MDB and distribute them to
the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page at
http://www.granite.ab.ca/access/splitapp/ for more info. See the Auto FE Updater
downloads page http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.