What is the maximum store of MS Access 2000?

[Cyrus]

If it is full, can i create an dulpicated empty db and link to this current
db?

 

[Douglas J. Steele]

The maximum size of an Access 2000 MDB is 2 gigabytes. There's no limit
(that I'm aware of) to the number of databases you can link together. A
single table, though, cannot span databases.

 

[Arvin Meyer]

If it is full, can i create an dulpicated empty db and link to this current
db?

The maximum number is 1 if it is big enough and about 250 million if they
are small enough. It is not the number of records that counts, rather how
they are accessed and how often they are accessed. The practical limits are
usually lower for high-use databases. The maximum size is 2 GB for > Access
2000 and 1 GB for Access 97 and below.

Yes, You can link up to 255 databases with 1 table each. The biggest I've
seen had 80 single table databases linked with a total of over 30 GBs.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[cyrus]

how about can I dynamically create and link to a empty db by program code
when my current db get full?
thz

 

[Douglas J. Steele]

The decision to link to additional databases isn't really something that you
do lightly. I can't see a reason why you'd have to do this programmatically:
if you're going to be storing that much data that you don't know in advance
when you need an additional database, perhaps you should be considering SQL
Server.

To answer your question, though, you set the Connect property of the
TableDef object. There's code at
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" that you
should be able to modify.

 

[Cyrus]

can .net code do that?

The decision to link to additional databases isn't really something that you
do lightly. I can't see a reason why you'd have to do this programmatically:
if you're going to be storing that much data that you don't know in advance
when you need an additional database, perhaps you should be considering SQL
Server.

To answer your question, though, you set the Connect property of the
TableDef object. There's code at
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" that you
should be able to modify.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



news:[email protected]

 

[Larry Linson]

..NET uses ADO.NET to access data; unless you have worked in a .NET language,
you wouldn't have used it. As yet, Access doesn't support .NET languages
(although in Office 2003, Excel and Word do), so most of us aren't
knowledgeable on the issues. One of the .NET newsgroups would be a much
better source for an answer to your question.

Larry Linson
Microsoft Access MVP