A
Ari
The limtation of 2 Giga with Access 2000 is not enough for my databases.
Does 2003 version have more capacity?
Does 2003 version have more capacity?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ari
I'm the user in a company and cannot setup a SQL serve...
Rgds
Ari
Rgds
Ari
G
Guest
Ari said:The limtation of 2 Giga with Access 2000 is not enough for my databases.
Does 2003 version have more capacity?
No.
You can download SQL Server Express edition and install that on your PC, or
you can change your database design so that it uses less space.
What are you trying to do?
(david)
A
Ari
Hi David,
It's a big cleaning operationn to table having 1,5 Million rows and several
columns. I need to get rid of some commas, quotes etc. that will block the
usage in the further processes. It seems that my VBA increases the total
Access 2000 file size over the limit and halts the process completely. Anyway
the Access and all files are located in company server and not my PC.
Regards
Ari
It's a big cleaning operationn to table having 1,5 Million rows and several
columns. I need to get rid of some commas, quotes etc. that will block the
usage in the further processes. It seems that my VBA increases the total
Access 2000 file size over the limit and halts the process completely. Anyway
the Access and all files are located in company server and not my PC.
Regards
Ari
D
Douglas J. Steele
No.
You can download SQL Server Express edition and install that on your PC,
or
you can change your database design so that it uses less space.
Does SQL Server Express have a larger capacity, David? I know MSDE was
capped at 2 Gb as well.
A
Arvin Meyer [MVP]
SQL-Server 2005 Express has a capacity of 4 GB
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
N
Norman Yuan
Constantly adding and deleting records to Jet database can bloat the *.mdb
file size. If records are deleted regularly, you need to compact the *.mdb
file in order to tell its "true" size. There is a chance that your db size
is still well below 2G if you haven't do compacting for some time.
file size. If records are deleted regularly, you need to compact the *.mdb
file in order to tell its "true" size. There is a chance that your db size
is still well below 2G if you haven't do compacting for some time.
A
Albert D.Kallal
Ari said:Hi David,
It's a big cleaning operationn to table having 1,5 Million rows and
several
columns. I need to get rid of some commas, quotes etc. that will block the
usage in the further processes. It seems that my VBA increases the total
Access 2000 file size over the limit and halts the process completely.
Anyway
the Access and all files are located in company server and not my PC.
1.5 million rows is not really that large in that you should be hitting the
limit of ms-access.
What is the size of the database after a compact and repair?
L
Lilybitt1
Are you regularly compacting your database? This can help with reducing its
size
size
G
Guest
Why dont you go for SQL Server? since Microsoft Access like file based
databases cant offer you much space ?
Rgds
Praveen
databases cant offer you much space ?
Rgds
Praveen
G
Guest
Write the changes to an empty database so that you have
a new, clean copy of the database, instead of trying to
make the changes in place.
Post your VBA code here so that we can check to see if
it can be improved.
And, like everyone else says :~) What do you get when
you compact?
(david)
a new, clean copy of the database, instead of trying to
make the changes in place.
Post your VBA code here so that we can check to see if
it can be improved.
And, like everyone else says :~) What do you get when
you compact?
(david)