had to delete & recreate links - why?

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I just had something strange happen...

Last Friday all was well with my Access (2k) db. I have [primarily] code in my
'code' db and data in my 'data' db. (All tables (4) for this task are in the
data db.)

When I tried to run what I was running Friday, without incident, Access told me
that the space was too small to fit what I was trying to store. I was trying to
store a "Y" in a 1 character test field. Changing this in the data db was no
problem. So I tried deleting and recreating the link in the code db. Voila,
problem solved.

It happened again with another of the 4 tables. It was my 'detail' table, where
I store the transactions that I pull from the AS/400. (The remaining two *seem*
to have been unaffected.)

The only thing I recall doing, before leaving Friday night, was to compact the
data db. It was about 2gb in size, and I wanted to shrink it, if possible. (It
shrank down to a little over 800mb.) As I remember it, time prevented me from
compacting the code db, otherwise I would have done it also.

This isn't 'normal' is it? Did I do something else wrong that I don't know? I
just don't want to do it again, whatever it was, if indeed I *did* do something
wrong.

Any thoughts/ideas/suggestions are welcome.

Thanks in advance,

Tom
 
I am not sure of the problem but I can recommend never let the database grow
to 2 GB in size. Access / JET will probably behave abnormally when the file
size hits the limit.

I keep my databases to under 1 GB.
 
Back
Top