Limitation in Access 2002

[N_NAGESH]

I am creating an access database and I want to know the following limitations;

1. Maximum number of users who can log into the database at a time

2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the database.

Can anywone help me in this regard?

 

[boblarson]

I am creating an access database and I want to know the following limitations;

1. Maximum number of users who can log into the database at a time

I believe that it officially is 255 concurrent users, but in realistic terms it only takes a couple of users connected to the same mdb file to have performance drop immensely, depending on your database. It is HIGHLY suggested to use a front-end/back-end split database and each user have their own copy of the front-end on their computer.

2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the database.

The maximum size of the mdb file is 2Gb and that includes the necessary system objects. However, you can link tables within various mdb files to get more storage capacity.

 

[N_NAGESH]

Thanks Bob..That was quick..

Please let me know how to link tables within various MDB files. Do I have to create a new MDB file with the same table names? I want some more details on this.

Again, Thanks for your quick reply

 

[The_Doc_Man]

You can go to the extreme of linking .MDB files, each with one table, so that each TABLE could reach 2 GB. The same names don't have to be in each separate DB. From MS Help on linking, ...

To link tables, on the File menu, point to Get External Data, and then click Link Tables.

In the Import (or Link) dialog box, in the Files of type box, make sure that Microsoft Access (*.mdb; *.adp; *.mda; *.mde; *.ade) is selected.

Click the arrow to the right of the Look in box, select the drive and folder where the Access file that you want to import or link is located, and then double-click the database's icon.

In the Import Objects (or Link Tables) dialog box, click each table that you want to import or link.

If you're importing, and you want to import just the selected tables' definitions (not the data they contain), click Options, and then under Import Tables, click Definition Only.

Note If you import a table that is already linked, then Access does not import the data; instead, it links the table to its data source (in effect, copies the link information

 

[N_NAGESH]

Thanks for your quick reply.

I have posted another thread with regards to generating chart in 'Reports' using calculated values in the report.
I understand you are well versed with Access. Can you help me in this regards.

Thanks again for your help. I will try this out....

 

[N_NAGESH]

Linking MDB files

Hi Bob,

I do understand that we can Link tables from another Access Database.

But my problem here is the file size of the Master databse.

For Examle;
I have split the databse of file1.MDB (Master) into FE and BE. Now, the data (tables) populates in file1.MDB_be.
After the file1.MDB_be (master) reaches the maximum limit of 2GB. In this case, I will have to create a new empty database (file2.MDB) and link all the tables from the file1.MDB_be

I want to know that, when I create file2.MDB and link all the tables in file1.MDB_be,

a. Can I run queries and retrieve data which are residing in file1.MDB_be
b. When I start the new databse i.e, File2.MDB and statrt entering data, where are the data stored / populated?
c. I am afraid that even after creating a new database file2.MDB, I should not end up with adding additional data into File1.MDB_be, which has already reached its limits.

I hope I am not confusing you with my question.

I really seek your help to solve this.

Regards,

Nagesh

 

[The_Doc_Man]

Either you are talking in hypothetical questions that will take a long time to become reality or you are fast approaching a point where Access is good only as a front end. How fast do you expect your tables to grow? If they grow to gigabyte sizes in less than a year's time, you either need to think about archiving or switching to an SQL Server back end. Also, if you seriously think that any single table might exceed 2gb, you need to immediately switch to SQL server and get that transition done sooner rather than later.

 

[The_Doc_Man]

I have posted another thread with regards to generating chart in 'Reports' using calculated values in the report.
I understand you are well versed with Access. Can you help me in this regards.

I would help except that when I search the forum as a whole, there is only one thread with your name on it. Did you append your question to a prior existing thread?