Solved

Unrecognized database format "XXX.mdb"

Posted on 2013-11-18
7
995 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 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:sglee
ID: 39660142
@LSMConsulting
Have you seen the database size reduced like that from the original size with corruption?
0
 
LVL 84
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 84
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Local Printing Using Remote Desktop Windows 7 sometimes has issues with printing to a local printer using a Remote Desktop Connection (RDC). The 1st step is to verify that printers are checked on the Local Resources tab of the Remote Desktop C…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

929 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now