Create 2 MDBs, create 1 table in each and then click File / Get External Data / Link Tables from the File menu. Select the MDB with the second table and Access will then behave as though both tables exist in 1 MDB. You can delete, add or edit records and run queries or code on the linked table.
Lu. -----Original Message----- From: Ivan Ramirez [mailto:[EMAIL PROTECTED] Sent: 12 November 2004 05:55 To: [EMAIL PROTECTED] Subject: RE: [Visual Basic 6 programming] an idea for 1GB limit (for LU) the ? was to link to a external MDB Ian <[EMAIL PROTECTED]> wrote:Link tables from the File menu Lu. -----Original Message----- From: Ivan Ramirez [mailto:[EMAIL PROTECTED] Sent: 12 November 2004 05:43 To: [EMAIL PROTECTED] Subject: Re: [Visual Basic 6 programming] an idea for 1GB limit (for JIM) hi pal: how can I do this ? ";-) jim" <[EMAIL PROTECTED]> wrote: If you are still close to your limit AND must stay with Access then create a DB that links to external DB's that have different sets of data in the different DB's. This keeps your connections inside your code to one. --------------------------------- Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT -------------------------------------------------------------------------- -- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT ---------------------------------------------------------------------------- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17957 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
