Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Unrecognized database format "XXX.mdb"

Posted on 2013-11-18
7
1,071 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

OpenVPN is a great open source VPN server that is capable of providing quick and easy VPN access to your network on the cheap.  By default the software is configured to allow open access to your network.  But what if you want to restrict users to on…
Let’s list some of the technologies that enable smooth teleworking. 
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

790 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