
MSAccess Database Size Restriction?
If the limitation is a gig then that is the limitation. The online help
says you can link tables in other files so you can have as many files as
you disk allows. From what you state, it appears you have 1 table near
the size of a gig so linking won't do much but buy some time. You might
want to split the table up, archive some records, or consider something
like SQL Server.
Quote:
> Hi,
> The Database I use at work crashes constantly (pretty much due
> to the size of one table) due to its size. Is there a way to bypass
> the problem of 1 Gig size restriction?