Limitation of MS Access database.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerard Troost - 26 Oct 2004 09:30 GMT

Hi All,

I have a ASP (on W2K3 webedition) website build on a MS Access
database. The database contains about 10 tabels. One of the tabels
contains 150.000 records an other table contains 10.000 record the
rest contains about 100 records. Totals database size 13mb.

1st: I have a few questions. What are the limitations of a MS Access
database?
2nd: Sometimes my JET engine stops.
3rd: Sometimes the application pool hangs.

Anybody know these errors?

Thanks very much.

Gerard Troost
www.trektellen.nl

Reply to this Message

Val Mazur - 27 Oct 2004 02:41 GMT

Hi Gerard,

1. If I remember correctly, Access database cannot exceed 2G size. Since it
always keeps garbage inside for the temporary use, it is nothing and you
would need to compact database periodically.

2. and 3. Do you get any error?

Signature

Val Mazur
Microsoft MVP

> Hi All,
>
[quoted text clipped - 14 lines]
> Gerard Troost
> www.trektellen.nl

Reply to this Message

Gerard Troost - 27 Oct 2004 06:42 GMT

1: Yes, i have heard / read the same. (and indeed i repack every week or
so.)
2 / 3 give's the error:
<CUT>
Unexpected error. A trappable error (C0000005) occurred in an external
object. The script cannot continue running..
</CUT>

Thanks!

Gerard

Reply to this Message

Michael D. Long - 28 Oct 2004 04:56 GMT

The error is the result of referencing a Null pointer. If you're coding in
VC++ then perform a code review. If not, either use your knowledge of your
code and the use of external libraries to isolate the offending module or
install a debugger and get a dump of the process when the error occurs. A
final option is to open an incident with MS Support and let them give you a
hand.

Signature

Michael D. Long

> 1: Yes, i have heard / read the same. (and indeed i repack every week or
> so.)
[quoted text clipped - 10 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Reply to this Message

Val Mazur - 30 Oct 2004 02:34 GMT

Hi Gerard,

It could be Access violation error, could be something else. You need to
debug and see which specific code causes this error. In this case would
could try to narrow possible cause of this.

Signature

Val Mazur
Microsoft MVP

Reply to this Message

VB Forum / Database Access / October 2004

Limitation of MS Access database.