Access database not saving new data

  harristweed 08:39 22 May 2007
Locked

Some time ago I wrote an Access database for a company, last week they asked me why it had stopped saving data. I said I did not know, but I suspected the user was doing something wrong. That was until yesterday when I was contacted by a second company and asked if I knew why their Microsoft Access had stopped saving data.

I have not visited either location but suspect that a recent Microsoft automatic update has caused this problem. Both these databases are on a small network.

Has any one suffered anything a similar problem?

  silverous 09:55 22 May 2007

Haven't seen this before. Which version of Access? Have you done much coding behind it or is it fairly straightforward?

The fact that two independent companies have come forward suggests it might be update related to me otherwise I would have suggested volumes but for both of them to hit a particular volume where the database had a problem or became corrupt in the same time period seems unlikely or a big coincidence.

Can't they send you a copy to take a look at and try on your machine?

Have you searched MS knowledgebase ? If a Microsoft update had this effect I think it would be in there fairly quick.

  harristweed 10:53 22 May 2007

Thanks for your reply silverous.

I agree that if it was a Microsoft issue there would be a lot of publicity. It could well be coincidence. Both databases are quite large, so I've suggested trying 'compact and repair'. Not had any feed back yet.

To the best of my memory the version of both is Access 2000 but one is a Spanish version. I have not done any VB coding just macros.

  silverous 10:56 22 May 2007

Sounds very intriguing, would appreciate if you can post back what you eventually find! Could they have reached a practical limit on the size of a table/index?

Can't they send you the DB so you can try it?

  harristweed 11:00 22 May 2007

If the 'compact and repair' doesn't work, i'll get the database and investigate further, I'll let you know the outcome.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?