As the access database can hadle up to 2gb of data so I was just wondering how many maximum records a table can store. Can anyone please tell me ?

Thanks

There is theoreticaly no limit...

The only limit is related to the recordsize...
If the record is 2 MegaByte, you can hold only 1000 records
If the Record is 2 KiloByte, you can hold 1.000.000 records
If the Record is 1 KiloByte, you can hold 2.000.000 records
If the Record is 1 Byte, you can hold 2.000.000.000 records

How can I come to know the record size in my table?

Make a new database, do nothing and close it, not the size.
Open the database, make the empty table you need, close it, note the size (1).
Stick in 1000 records into your table, close database, note the size (2)

Difference between 1 and 2 / 1000 == size of your records.

Generaly though these will be not very much and you shsould be good to go into the millions of records ...

If the access table can store millions of records then whats the purpose of Oracle database. Actually In my present job , I am using MS Access and vba . I want to have a training in Oracle But I have to convince my boss why it is benificial to migrate from Access to Oracle. he wants to knowwhy I need Oracle training as its not needed in my present job.

Thanks

Access can hold millions of records, but... it is (currently) limited to 2gb.
So while one table can hold 2 gig of data, if you have another table for another 2 gig, you run into problems

Also Oracle is great for bigger system but also has the advantage of running on its own server, thus have 4/8/whatever processors working for it with *loads* of memory. Where access will always run on your local machine competing with ie. outlook for resources.

Theoriticaly you can make yoru Desktop as big and bad as you want, even better than any server, but in practice that isnt going to happen. If your working with loads of data, Oracle is just the big brother you want but as I always say, you can rule the world with access if you want. When designed properly and within its own limits (i.e. Not to many concurent users, somewhat limited security,etc) it is a very nice tool.

However if you need more security, better responses, better dissaster recovery, auditing, in general if you need it 'bigger better faster etc' you are going to want Oracle/SQL Server.