Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Tables disappear from my MS Access database

22 Jan 2016   #1
padhoo

windows 7 ultimate 32 bit
 
 
Tables disappear from my MS Access database

Hi friends, I have some Compiled VB6 projects installed on my Windows 7 laptop. (Mostly copies of Software supplied to the clients) They would be working fine, then all of a sudden, may be after weeks, or months, I get an error when launching the software 'Unrecognized database format' On checking the database manually, I see one or more tables are disappeared. Any ideas? thanks in advance.


My System SpecsSystem Spec
.
22 Jan 2016   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

What version of Access are you using. In Access 2013, you can repair & compact the database by clicking on File at the top LH corner & when that opens you will see under Info, Compact & Repair, click on that.

Compacting the database will definitely reduce the size it uses on your hard drive & usually speeds up the opening time as well.

You could also try repairing Office. To do that open Control Panel, select Programs & Features, scroll down to Microsoft Office, Right Click on it & select Change, that will open a couple of Repair opens to try.
My System SpecsSystem Spec
23 Jan 2016   #3
padhoo

windows 7 ultimate 32 bit
 
 
It is Access 2007

Thank you for the Response. I don't have much use of Office, so I am using an older version, Access 2007
on my Windows 7 Ultimate 32bit Lappy, just for backups of software I had Compiled in my old XP machine and supplied to the clients. The weird thing is there are quite a few such software installed and running fine.
The problem happened for one software in November last. This is the second instance two days back.
there are others still working OK. My reasoning is, if the problem was with access all the software would have crashed. Why this is happening at random? Is it any Windows 7 quirks? (I checked with the client who is using the software on Windows 7 32bit. He don't have any problem.

More than fixing the issue on my machine, I am interested to know the probable cause, so that if this happens to any of my clients, I would have a solution handy. Any advice appreciated.
My System SpecsSystem Spec
.

23 Jan 2016   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Read through this MS website on why you need to Repair & Compact a database from time to time. It's possible for parts of the database to become corrupted over time & regular maintenance helps prevent this.

It also tells you how to Compact & Repair Access 2007, so follow the recommendations & see how you go.

I think when you read through the information you will see the reasons why yours may have developed some problems & you can use that advice for your customers.

https://support.office.com/en-us/art...6-28846510c539
My System SpecsSystem Spec
23 Jan 2016   #5
padhoo

windows 7 ultimate 32 bit
 
 

Thank you for the advice and link. I had never bothered about the compact options(But never encountered problems either).
My System SpecsSystem Spec
23 Jan 2016   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

You are welcome. As you have ticked it as Solved it seems that it is now working properly again.
My System SpecsSystem Spec
24 Jan 2016   #7
padhoo

windows 7 ultimate 32 bit
 
 
My DB Not Working, anyway the solution useful.

What you had provided me is a precautionary measure. The particular DB I had complained about had already lost the tables. Obviously, the precautionary solutions cannot retrieve the lost part. Anyway, it was a DB with demo data only.

I am planning to advise the client(Custom software, Single Client), who runs the actual data, to apply the precautionary measure. I am planning to do a auto-compact on his database.

Thank you again for the useful advice.
My System SpecsSystem Spec
Reply

 Tables disappear from my MS Access database




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Access Database Question
I've been tasked to set up an Access Database that will accept input from Excel spreadsheets (from a template file that is created and distributed to several employees. The files will contain about 25 fields, some inventory and some dollar amounts, as well as a few contact information type fields....
Microsoft Office
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
Sharing an Access Database
Hi Folks: I have a desktop running Win 7 Pro and acting as a file server in an office. There are 4 other Windows 7 computers in the office all with a mapped network drive from the server. We have an MS Access Database which "lives" on the server's hard drive and, therefore, is accessible to all...
Network & Sharing
Database - MS Access Backend vs MS SQL
hi all, i would like to ask for database performance : currently i split my ms access database to front end (form interface) and backend. the backend file i put on shared folder on dedicated pc, which i assume as server. the database then access by 10 staff, which having the frontend file on...
Software
Create a Database with all my Music - MS Access
Hey peeps, Got a bit of a project i want to do, I want to make a database in access that can do either of the following Talk to Media Player and copy all album and song information Or talk to Itunes and copy all album and song information
Microsoft Office
Problem saving an old access database
Mum has asked me to print off an old access database. I tried access 2007 but it refused to open it citing security concerns and other reasons. So I then tried Access 2002 in XP Mode but save as is greyed out and export to says it cant find the path.
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:54.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App