Access size limits

[jetson]

We are experiencing failures writing to Access tables when we go over 100 MB. We're using a third party application (SAS) to write directly to Access.

We are positive that we have available disk space (we have 10 GB available).

We created a copy of the database and removed unnecessary tables. The copied database starts out at 44 MB, then we write to it and it reaches about 95 MB, then we compact it and it goes back down to 51 MB. It seems like ther is a 100MB ceiling becuase the same write process against the full database seems to fail when it goes beyond 100 MB.

Any thoughts would be appreciated.

Kenny

 

[jeremie_ingram]

I believe that Access has a 1.99gb limitation, so you havent reached the ceiling yet. There are a few ways of getting around the issue, and that would be to break your mdb into a few smaller mdb. Say your mdb has 15 tbls, all of which are large, you could create 3 mdbs and hold 5 tbls in each. Then create a fourth mdb that only holds the forms, queries, reports, modules, and macros. This would work as the front end for the end users and the mdbs containing the actual data would be the back end.

 

[mission2java_78]

Before you start creating mdb after mdb have you moved all of your objects into a new mdb compacted and repaired?

 

[jetson]

Jeremie - thanks, we have been successful breaking it apart. I just want to understand why we would need to if we haven't hit any ceilings...

Mission2 - thanks for the reply. We have not moved old objects into a new database and then compacted and repaired. But we have created a brand new database with no objects in it, and then wrote to that successfully. Odd, the write process creates a new mdb, and than creates the table and fills it with data - at that point, you wouldn't think it would need compacting necessarily.

Thanks,

Kenny