?
Solved

Unrecognized database format "XXX.mdb"

Posted on 2013-11-18
7
Medium Priority
?
1,343 Views
Last Modified: 2013-11-21
Hi,
 
  I have developed a MS Access database, went corrupted and could not even repair using ACCESS own "Compact and Repair" or JetUtil.

  That said, I ended up restoring it from the backup device and all is good.
  But the reason I am posting this question is:

 (1) When users are using the database on a local network, it is fine.
      But this has happened before when users connected to the database via VPN tunnel.
 (2) The database file size was 6.7MB, but this morning the size was 412K and there was .ldb file as well.  

  My question is how the database file size can change so drastically, let alone getting corrupted?

Thanks.
0
Comment
Question by:sglee
  • 3
  • 3
7 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 39657520
Is this a multi-user db? Is there a local front end?
0
 

Author Comment

by:sglee
ID: 39657534
It is a multi-user system, but 99% of the time, there is only one person entering data - one record/row a day on average.
I created front end and back end once and performed the test, but there were about the same once we get into "data entry screen" and start looking up the record or move the record to prev or next. So for my own convenience it just combined them into one MDB file.
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 39657991
But this has happened before when users connected to the database via VPN tunnel.
Access does not work well with VPNs, and there's not much you can do to make things better.
The database file size was 6.7MB, but this morning the size was 412K and there was .ldb file as well.  
I'd be very concerned with a database that went from 6.7 mb down to 412k, and would immediately stop using the VPN. The .ldb file is a lockfile, and it's created every time someone opens the database, so that isn't a concern.

If you have offsite users the best way to manage them is through some sort of remote desktop setup. Often this entails setting up an RDS Server, which requires you to purchase server software.
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:sglee
ID: 39660142
@LSMConsulting
Have you seen the database size reduced like that from the original size with corruption?
0
 
LVL 85
ID: 39660452
Yes, and in most cases it's catastrophic (better keep good backups).

The issue, however, is the VPN. You're playing with fire trying to run an Access database across a VPN. It's far too unstable, and disconnects/connects too often for it to be reliable.
0
 

Author Comment

by:sglee
ID: 39661313
Do you think if I split the database and keep  Front End.mdb (forms, reports .. etc)  on each workstation and Back End.mdb (tables, queries) on the File Server, it will solve the problem?
0
 
LVL 85
ID: 39665516
Do you think if I split the database and keep  Front End.mdb (forms, reports .. etc)  on each workstation and Back End.mdb (tables, queries) on the File Server, it will solve the problem?
If you keep the VPN in the mix then no, it won't solve the problem. It may very well reduce the frequency of corruption, but if you have users connecting over VPN then corruption is virtually assured. As I mentioned earlier, the only reliable way to support offsite users with an Access application is to use some sort of remote desktop setup.

That said, you should ALWAYS split a database, and each user should have their own separate copy of the FE, and all of those FEs should connect to the same BE.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question