>From: [EMAIL PROTECTED] >Date: Thu, 9 Nov 2000 09:35:38 +0530 >1 ) Correct me if I am wrong, but this implies that the maximum > number of records in a PDB can be 65536 with each > having 64KB of data i.e. 65536 * 65536 bytes of maximum > storage per database ?
There was a previous thread on this issue several months ago. It resolved that 16KB is a same maximum for the number of PDB records, because of the way some of the sort API's work. You can have more records, but you need to carefully validate when you go through the 16KB and 32KB barriers that your code will still work. Also the maximum PDB record size is a little under 65536. I think a same maximum is 65000, though this may be a little conservative. Therefore the safe maximum PDB file size is about 1GB. Roger Stringer Marietta Systems, Inc. -- For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/
