Access Data disappaer

Hi All

We use access as our database, all of the data out of table just disappeared... around (125,000 records).

To make it worse our backup solution had stop working a few weeks back...

Anyidea how the table empty it self? or how to find out what did it?


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

It may not matter,  but what version of access are you using?  Are you able to undo?  Was the data linked to an excel spreadsheet outside the database? Did you possibly create a copy of the table carrying over only the format?  If you are using a form to input data check to see if the form is still linked to the correct table or query.  These are just a few thoughts.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Basically, only two ways:

1) Corruption
2) Someone deleted the data.

How to find out? Not really ... guess we would have to 'be there'

What happened to the backup?

Matb396Author Commented:
Access 2010 and no spreadsheets or anything....

We "were" using a online backup services but there server broke or something and they failed to tell us that until i ring them early on today....

I don't think someone deleted it....

I keep trying to import the old stuff we have from a few weeks ago.... and it keeps going on about the database might be corrupt and it wouldn't let me paste any record in... I've click on the  "compact and repair" which seem to of fixed it.  

Is there anyway of pre-eventing any future corruption.... By using SQL Server? or something?


SolarWinds® VoIP and Network Quality Manager(VNQM)

WAN and VoIP monitoring tools that can help with troubleshooting via an intuitive web interface. Review quality of service data, including jitter, latency, packet loss, and MOS. Troubleshoot call performance and correlate call issues with WAN performance for Cisco and Avaya calls

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"I've click on the  "compact and repair" which seem to of fixed it.  "
That was my next suggestion ... and you got lucky this time.

"Is there anyway of pre-eventing any future corruption"
Daily Compact & Repair is the *best* preventative maintenance you can do on an Access db ... I guarantee you that.

Of course, SQL Server is an more 'robust' database in that context ... if you have the option.

Matb396Author Commented:
Is there any different between access and SQl Server?? We have 5 different program feeding in to i know connection string is different, but anything else?  

One of our database table is growing at rate of 2500 records aday..
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Is there any different between access and SQl Server?? "
Well ... yes, HUGE.  
An Access db has a 2GB size limit just to start with ...  so, in 365 days you will be at approx 1 million records ... and depending on the record size, you could well approach the 2GB limit ... or a LOT sooner.

SQL Server is of course more stable and secure than an Access db, but also more expensive.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Matb396Author Commented:
That at a growing of about + 40 every day.... so in about 119 days will be hitting a million....

And i was meaning how you program? i think i read some where that the date is just stored as a string?


O and FYI if i done the maths right there should be about 52 million in wihth 365 days... and about 833,000 a day
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.