Yes.
I missed the starting of this topic, but if this is a DB that a business relies
on to function, then getting near the limit proves you must upgrade to a DB
that does not have this limit.
If this performs a function that is not critical, then you can play with
linking DB's.
Are your tables normalized? i.e.. have wasted or repeated data?
----- Original Message -----
From: Ian
To: [EMAIL PROTECTED]
Sent: Friday, November 12, 2004 9:58 AM
Subject: RE: [Visual Basic 6 programming] an idea for 1GB limit (for LU)
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
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=17960
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/
