Split database

[Phil]

Hi,
I have an Access program that I want to package and I see that there is an
option "Database Splitter". Is there an advantage or disadvantage to
splitting the database?
Thanks,

 

[Armen Stein]

Hi,
I have an Access program that I want to package and I see that there is an
option "Database Splitter". Is there an advantage or disadvantage to
splitting the database?
Thanks,

Hi Phil,

It is an absolute *must* to split the database, for a variety of
reasons, especially if you're going to "package" your application for
others to use. Please Google or Bing "split access database" for many
articles.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Richard]

Take a look at this or google splitting access databses.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Tony Toews [MVP]]

I have an Access program that I want to package and I see that there is an
option "Database Splitter". Is there an advantage or disadvantage to
splitting the database?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. 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
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
the distribution of new FEs relatively painless.. The utility also
supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

Please Google or Bing "split access database" for many
articles.

Trouble is Google, and now Bing, are indexing many online forums which
are mirrors of the NNTP newsgroups, such as this one. All these
forums do is pollute the search results with many useless hits or hits
giving wrong advice. And these are being setup so they can sell
online ads thus increasing Google revenue.

Therefore I am urging folks to post specific URLs rather than such
generic advice to search.

Also see the Newsgroup Answers MDB - I designed the MDB to assist
frequent newsgroup answerers, such as MVPs, in quickly locating and
pasting in their favourite snippets of answers.
http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

I keep a lot of notes in OneNote and I like keeping those separate
from my standard newsgroup answers.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Armen Stein]

Therefore I am urging folks to post specific URLs rather than such
generic advice to search.

That's good advice, Tony. In this case a) the question is so common
that a quick search would generate a wealth of information, and I
think we should encourage searching before asking, and b) I checked
those searches and they returned relevant results on the first page.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com