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

Splitting DB vs. linking

P: n/a
Is there any difference between splitting the .mdb vs. linking a table
in another .mdb file ? For example, if I use the database splitter
tool I end up with Widgets.mdb and Widgets_be.mdb. All the tables are
located in Widgets_be.mdb. However, let us say that I create a file
called Widgets2.mdb, move all the tables from Widgets.mdb into it, and
then link the tables from Widgets.mdb to Widgets2.mdb. Is there any
difference in how Access treats the files? Thanks for your help.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Same result.

Personally, I prefer to split manually as you describe, because I can leave
some tables in the front end (e.g. user temp and config), and because
getting Access to rebuild things is useful at that stage of the process to
help avoid corruption after constantly changing things.

Or perhaps it's because I have been splitting since before there ever was a
splitter wizard. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<Ca************@HeartOfDarkness.com> wrote in message
news:42658128.675421@news-server...
Is there any difference between splitting the .mdb vs. linking a table
in another .mdb file ? For example, if I use the database splitter
tool I end up with Widgets.mdb and Widgets_be.mdb. All the tables are
located in Widgets_be.mdb. However, let us say that I create a file
called Widgets2.mdb, move all the tables from Widgets.mdb into it, and
then link the tables from Widgets.mdb to Widgets2.mdb. Is there any
difference in how Access treats the files? Thanks for your help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.