How many GB that can ACCESS hold the records/files? including the attachment, forms, reports, etc. Would it be possible the program will crash due to the maximum records/files that access hold??? Thank you

Please check the following:
http://www.databasedev.co.uk/access_specifications.html

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

So there isn't a maximum number of records, per se. only for the MDB file size there is a maximum? and the ACCESS can hold/stored records 2 GB)?

What happens when you reach that number of records? Do you just lose the ability to enter new data? Or will it crash on you? What does one typically do when you are approaching the end of Access' ability to store data? Thanks again

Correct, there is not a limit to the number or records in a table. The limit is by total database file size of 2 gig.

You should also Split your Access database into application and data (Click Here)

It is not pretty. You start having lots of issues.

Any database requires monitoring, backups and regular maintenance. Access is not exception.

I prefer to upsize to an Server. As pointed out in the link above, you can use multiple back ends.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

thanks for the quick reply Sir, i really appreciate it... actually, i just make this program from ACCESS re: Incoming and Outgoing of documents and i've got a presentation with the managers, and maybe they might ask this questions.... thanks again Hi techCoach