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

Database Splitter

P: n/a
Hi,

Although I am new to Access, I do try to experiment a bit. although this
time I may have gotten over my head. Hopefully someone can help me out. No
doubt a simple question for many of you.

I have found it necessary to use the Database Splitter Wizard to split my
database. I was quite surprised how well it works. After several months I
need to add another table (tblReturnedFunds) to my ClientsData.mdb and so
far had no luck in figuring out how to do it.

The two tables I have are Clients.mdb (forms, queries, reports etc..) and
ClientsData.mdb. No doubt a beginners question, but I would really would
appreciate some advice in this regard.

Thank you all in advance.

Mike
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ok Mike,

You need to add the table to ClientsData then in the Clients DB click the
Tables Container and right-click in the blank are where the other table
objects are located and choose Get External Data, then link (NOT IMPORT) to
the ClientsData and click on the new table to link it.

Just to let you know there is an additional benefit to splitting. You can
add a local table (that is not linked) to the Clients db. This will allow
you to store or set up temp tables the user can use without affecting other
users. For instance, say you have a temp mailing table. You can have the
user select the records they want and they will be added to the table and
used for mailing labels....other users can select other records for their
list and the lists stay separate because everyone has their own local list.
I use this technique for creating tempory data for reports and such.

HTH
Paul

"MikeZ" <mz****@telus.net> wrote in message
news:eMgkd.78926$E93.52909@clgrps12...
Hi,

Although I am new to Access, I do try to experiment a bit. although this
time I may have gotten over my head. Hopefully someone can help me out. No
doubt a simple question for many of you.

I have found it necessary to use the Database Splitter Wizard to split my
database. I was quite surprised how well it works. After several months I
need to add another table (tblReturnedFunds) to my ClientsData.mdb and so
far had no luck in figuring out how to do it.

The two tables I have are Clients.mdb (forms, queries, reports etc..) and
ClientsData.mdb. No doubt a beginners question, but I would really would
appreciate some advice in this regard.

Thank you all in advance.

Mike

Nov 13 '05 #2

P: n/a
"Paul" <pz****@rogers.com> wrote:
Just to let you know there is an additional benefit to splitting. You can
add a local table (that is not linked) to the Clients db. This will allow
you to store or set up temp tables the user can use without affecting other
users. For instance, say you have a temp mailing table. You can have the
user select the records they want and they will be added to the table and
used for mailing labels....other users can select other records for their
list and the lists stay separate because everyone has their own local list.
I use this technique for creating tempory data for reports and such.


Although this can lead to bloating of the FE. See the TempTables.MDB page at my
website which illustrates how to use a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

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 #3

P: n/a
Just run the compact utility at the end of each day and you wont have
bloating problems. In addition, you can add a shortcut to the desktop to do
the compacting.

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:5q********************************@4ax.com...
"Paul" <pz****@rogers.com> wrote:
Just to let you know there is an additional benefit to splitting. You can
add a local table (that is not linked) to the Clients db. This will allow
you to store or set up temp tables the user can use without affecting
other
users. For instance, say you have a temp mailing table. You can have the
user select the records they want and they will be added to the table and
used for mailing labels....other users can select other records for their
list and the lists stay separate because everyone has their own local
list.
I use this technique for creating tempory data for reports and such.


Although this can lead to bloating of the FE. See the TempTables.MDB
page at my
website which illustrates how to use a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

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

P: n/a
I greatly appreciate your help and your advice. It is folks like you
that help me keep my sanity.
Regards
Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.