Learn more about splitting databases in Frontend and Backend

  • Thread starter Thread starter cbor
  • Start date Start date
C

cbor

Where do I read more about splitting databases in frontend and backend?
Any good links?

Thanks, C
 
Look in Access help for "split".

The essence of it:

Copy your app twice, naming one copy "MyAppGui" and the next copy as
"MyAppDat. Then rename the original as "MyAppCombined" or some such
meaningful name.. You'll probably never again need the original format.

Open MyAppDat and delete everything except the tables.

Open MyAppGui and delete all of the tables. Open your Add-ins and choose
the Linked Table Manager. Select all. OK. Select MyAppDat. It should
report that it successfully linked all of the tables.

You're done.

hth
 
cbor said:
Where do I read more about splitting databases in frontend and backend?
Any good links?
Click to expand...

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 my website for more info. See the Auto FE Updater downloads page
at my website 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
 
Back
Top