What is the maximum store of MS Access 2000?

  • Thread starter Thread starter Cyrus
  • Start date Start date
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.
 
Cyrus said:
If it is full, can i create an dulpicated empty db and link to this current
db?
Click to expand...

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
 
how about can I dynamically create and link to a empty db by program code
when my current db get full?
thz
 
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.
 
can .net code do that?


Douglas J. Steele said:
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]
Click to expand...
 
..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
 
Back
Top