Table Size Limit

[mdillon]

I am linking the tables in my MS Access front end with the tables in my dataserver through the "Link Tables..." feature via ODBC. The data in the tables will eventually reach several GB's. Will the MS Access front end be able to handle several GB's of data as well, or will Access crash? Does anyone know what the maximum amount of data a single table in Access can handle? Any insight would be much appreciated.

Thanks,

M. Dillon

 

[Bastien]

depends on version of access (97 could handle about 65000 rows) +2K had the limits increased, but to what I am not sure

check

http://www.msdn.microsoft.com

in the office products area. there should be something there...

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[mdillon]

I am using MS Access 2000. In addition to a max table size (MSDN did not list the actual size), is there a limit to the total amount of data that access can handle. Would Access be able to handle 100 tables, for example, with each filled with data to their maximum capacity?

M. Dillon

 

[LittleSmudge]

The point you seem to be missing mdillon is that you are not asking Access to 'handle' this amount of data - your data server is handling it.


All you are doing is getting Access to 'front' the data onto the user's screen.

The question you need to be considering is
"How do I effectivly & efficiently get the data from my server to the user screen ?"

You can put terrabytes of data in a data server and front it with an access front end and it will all run smoothly if you get the data selection correct.


Something NOT to do:-
Link the largest table in the server to the front end and open a Form with that table as the Recordsource.
- because the entire contents of that table will be downloaded to the FrontEnd ( orver your network ) BEFORE the first record is displayed.

Something to CONSIDER:-
Use ADO to select limited amounts of data to be obtained from the dataServer.
Populate unbound forms with the data once retrieved
Base queries on the user inputs on these forms and gather more data from the data store that way.



'ope-that-'elps.

G LS