Hello,

Can anyone tell me how many records A2002 can accomodate. Say if it can handle 4 million records. does it mean per table?. Or for all tables it can anly accomodate 4 million records. And if it is alrady 4 million, does it mean that for the 4 million can be printed in one report which will result in many pages.

Thanks for any enlightments.

Frank

A2002 is limited by file size, not by number of records. - File size is then dependent on now big each record is. - File limit is 2 gigabytes.

You can split large files into separate mdbs, and link from one to another, so as long as any sinlge table is under 2 gig (a bit less for overheads) your access app is not limited by 'size' at all.

You may find it starts to run more slowly with lots of records, and more than a few simultaneous users.

Hope this helps

Thanks Dmhzx for your explanantion. How about A2007. if ouir church membership total is 50,000,000 members and their photo could be the one makes the filee size so big. This is also will be included in the file size you mean?

Frank

Hi it's still 2 gig.

look here

http://blogs.office.com/b/microsoft-access...007-limits.aspx.

To the best of my knowledge, when dealing with pictures, the actual pics are stored outside the database, and access simply stores a link to them.

How are you going to get the data on 50 million people into the database? - Looks to me like a lot of users? - Access starts to run into difficulties when you go over about 12 concurrent users.

Not sure if my sums are correct, but at 50 million records and a 2 gig file size limit, I make that about 40 bytes per record. - Which makes access a non starter.

You could try SQL server with an Access from end.

Yes dmh.... I put pictures in otherfolders, it is not part of the program?.
Thank you for your explanation. I just want to know how I convert my backend Access table to sql.

Frank