 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / November 2004Database Splitter
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 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 > Hi, > [quoted text clipped - 14 lines] > > Mike >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 [quoted text clipped - 4 lines] >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 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. >>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 [quoted text clipped - 19 lines] > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm I greatly appreciate your help and your advice. It is folks like you that help me keep my sanity. Regards Mike |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.