you are asking for disaster.
If you are approaching the limit AND have a well defined DB without wasted
space, then move to MySQL.
OR SQL if this is for a business.
Normalize your DB, and change binary fields (pictures) to links.
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.
Also remember Access files never get smaller no matter how many records you
delete unless you do the "repair and compact". So you might want to spool off
that task when your app shuts down. MS has a stand-alone EXE that you can
chain to that will do this.
----- Original Message -----
From: Ivan Ramirez
To: Group VisualBasic6
Sent: Thursday, November 11, 2004 10:36 AM
Subject: [Visual Basic 6 programming] an idea for 1GB limit
hi pals
Set cn(0) = New ADODB.Connection
Set cn(1) = New ADODB.Connection
Set cn(2) = New ADODB.Connection
Set cn(3) = New ADODB.Connection
cn(0).provider= "Microsoft.Jet.OLEDB.4.0"
cn(1).provider= "Microsoft.Jet.OLEDB.4.0" cn(2).provider=
"Microsoft.Jet.OLEDB.4.0" cn(3).provider= "Microsoft.Jet.OLEDB.4.0"
cn(0).ConnectionString = "data source=d:\proyecto\rm0.mdb;Persist
Security Info=False"
cn(1).ConnectionString = "data source=d:\proyecto\rm1.mdb;Persist
Security Info=False"
cn(2).ConnectionString = "data source=d:\proyecto\rm2.mdb;Persist
Security Info=False"
cn(3).ConnectionString = "data source=d:\proyecto\rm3.mdb;Persist
Security Info=False"
ciudadano(0).ActiveConnection = cn(0)
ciudadano(1).ActiveConnection = cn(1)
ciudadano(2).ActiveConnection = cn(2)
ciudadano(3).ActiveConnection = cn(3)
is possible to do this, and have several conections to skip the 1Gb limit of
a .MDB
Ivan
---------------------------------
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=17940
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/
