Database Splitter

[MikeZ]

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 (tblReturnedFun ds) 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

[Paul]

Re: Database Splitter

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" <mzizek@telus.n et> wrote in message
news:eMgkd.7892 6$E93.52909@clg rps12...[color=blue]
> 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 (tblReturnedFun ds) 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
>[/color]

[Tony Toews]

Re: Database Splitter

"Paul" <pzspam@rogers. com> wrote:
[color=blue]
>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.[/color]

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

[Paul]

Re: Database Splitter

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" <ttoews@teluspl anet.net> wrote in message
news:5qp4p0lq1u 8kkatr6kj1914ud fekvop2ld@4ax.c om...[color=blue]
> "Paul" <pzspam@rogers. com> wrote:
>[color=green]
>>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.[/color]
>
> 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[/color]

[Mike Ziz]

Re: Database Splitter

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!