High row input

[696796]

hi,

I am creating an Access 97 database where a certain table will be populated with around 720 rows per day. This will amount to aproximatly 187200 in one year.

Are there limits on how many rows a table can contain? What are the performance issues on having a table such as this and what strategies can i look into to avoid this.

Thanks for your time,

Alex Marchant

 

[KenReay]

Hi

No limit on number of rows in a table.

Max size of mdb in Access97 is 1Gb (I think from memeory, check Specifications in help to be sure)

Compact the db regularly

190,000 rows is no big deal

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[BNPMike]

I suggest you upgrade from this way-out-of-date version of Access.

Efficiency is a complex and subtle subject. The best place for information is the Microsoft site. Start rummaging around eg from here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/connectdap.asp