I just want to know how many records can access stored in records. What is the limit no. Thanks in advance.

There is none. Access doesn't limit according to record numbers, table size etc. because there can be many different factors. The limit is solely on the size of the mdb file. For Access 97 it was 1G, for 2000 and later its 2G. But this limit can be gotten around by using linked tables.

Did you solve the other problem?

Which is the best to do? I will create different MDB file for every category then I link to each other or should I make all my programs in one MDB files.

Depends on your needs. At the least your database should be split into a back end (with all the tables) and a front end (with everything else). If you find that back end is getting too big, you can move some of your tables into another MDB file and link that to your front end.

You should not have separate tables for each category. You should have one table with a field to identify the category.

The category I mean is for instance, I will create one MDB for the Employee Profile and second one is for Materials and so on. I have more program to do not only one cycle. So, if I will create this in one MDB file I'll be confuse because my form will increase the no. my quirries, and my report. For me, if there is possible to avoid more complicated forms,quirries and report I guess much better for me.

You will be surprised at how long it takes to fill up two Gig. I would keep all your tables in one back end MBD until you see whether your data mdb is getting too big.

If you have to move tables into other backs ends, this will not affect your front end at all. The tables will still have the same names, even if they are linked to a different file.

Thanks. :)