How to link access database from vb

[kmjpr]

hi
I'm using VB with access .now capacity pf access database is 1 GB.. after that no more entries are possible but there is way to create one more database and link it to previous one.. so that u get double the storage space.
but any idea how to do that ...
thanks

 

[Schroeder]

First, if you can get your hands on Access 2000 or above, you'll move to a 2GB limit. Which makes me wonder, if a person doesn't have Access installed at all and they use DAO 3.6 to create and use an .mdb file, do they get to take advantage of the 2GB limit? What version will that .mdb file be?

Anyway, I don't know of a way to combine two Access dbs to make them behave as one. You could move each of your tables into their own database, then link each of those tables into another database. You'd have access to all of your tables via the one db but the size limit would apply on a table by table basis.

If you've got one table that's getting too large, I don't know what to tell you except to upgrade to a DBMS that can handle your data. You could start a new table and run your queries against both but that's asking for trouble.

 

[johnwm]

Might be worth looking at MSDE (sort of cut-down SQL Server)
Try this site for info:

http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp

Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'