473,320 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MSAccess MDB corruption

Migrated VB6 (MS Access 2003) based application from Windows Server 2008 Enterprise to Windows Server 2008 R2. The application is accessed via network share from Citrix XenApp.
Since the move, we have had an almost daily corruption issue in one of the mdb files. Does WIN2K8 R2 behave differently than WIN2K8 Enterprise in terms of handling open sessions? The Citrix servers reboot nightly – some end-users are bad about logging out correctly and leaving sessions idle.
Is there a file monitoring tool, script or some other method to monitor the file for corruption and send an e-mail notification?
Apr 24 '15 #1
5 2475
zmbd
5,501 Expert Mod 4TB
I'll have to look into this a tad deeper; however, we used to have this issue with older access database backends accessed over the networks when the network server would reboot because it would simply force the file to close irregardless of the write-state or record locks resulting in corruptions.

There are some threads here about using the timer event in forms to close idle sessions. You can use the search bar at the top of this page to find them :)
Apr 24 '15 #2
jforbes
1,107 Expert 1GB
Using a timer to close the database connection may work, but in my experience with Terminal Server, when the Session isn't actively being used by the user, the applications that are opened on the users desktop effectively pause their execution. So in the case of a user disconnecting their session, the application will stop and wait indefinitely, without exiting, and a timer will never be fired.

I think there is an option to force a Logoff after a certain amount of idle time. Forcing a Logoff may allow the application to Exit gracefully and close the database connections. Or alternatively, force a Logoff before rebooting the Server.

Or to switch gears completely... This is not necessarily a recommendation and it may be way off target with what you are doing or with your company's capabilities but your backend database could be converted to SQL Server or SQL Server Express. It should take care of your file locking/writing issues and then you can just let your users be as careless as they like.
Apr 24 '15 #3
zmbd
5,501 Expert Mod 4TB
I think your problem lies with the Citrix XenApp.

Citrix XenApp is an on-demand virtual application delivery solution ...

Understanding application virtualization
Citrix application virtualization technology isolates applications from the underlying operating system and from other applications to increase compatibility and manageability. As a modern application delivery solution, XenApp virtualizes applications via integrated application streaming and isolation technology. This application virtualization technology enables applications to be streamed from a centralized location into an isolation environment on the target device where they will execute. With XenApp, applications are not installed in the traditional sense. The application files, configuration, and settings are copied to the target device and the application execution at run time is controlled by the application virtualization layer. When executed, the application run time believes that it is interfacing directly with the operating system when, in fact, it is interfacing with a virtualization environment that proxies all requests to the operating system.
(...)
Your program is in an active state within the XenApp and when the server reboots it wipes out your connections and anything else that is pending.

I would attempt the Form Timer first.

I my experience, forced logoffs from the server are never a good thing and have found that there is 50/50 chance of breaking something at the client's end.

The Terminal Server issue that J talks about can also happen; however, there are workarounds for that... the easiest, as J suggests, may be going to the MySQL, MariaDB, SQL-Server, SQL Server Express, etc... however, that may not be for the faint of heart.
Apr 24 '15 #4
The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

1. Do not open Access database must closed
2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
3. Close the .mdb file related to .ldb file before you delete the .ldb file.
4. Then Run the Compact and Repair tool

In case this methods appeared ineffective look at professional software for corrupted .mdb and .ldb files in MS Access.
Apr 26 '15 #5
First of all make a copy of your database file when Access is not running.

When an Access database file (mdb or accdb) is corrupt or damaged, then you can try several methods to repair and recover data from it:

1. First of all, try compact & repair. Follow below steps:

For Access 2010, click Compact and Repair Database on the Database Tools ribbon.

For Access 2007, click the Office button (top left), then Manage.

For Access 95 - 2003, choose Database Utilities from the Tools menu.

2. Second, if method 1 does not work then try to create a new Database and import all the objects from old database into new blank database.
May 29 '15 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: michael montagne | last post by:
I have one particular database that seems corrupt. I've run "Compact and Repair" to no avail. It is Access 2000 on Windows 2000. Other mdb files do not have this problem. all data seems fine as...
115
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i...
19
by: adirat | last post by:
I have read a lot on this subject on newsgroups and other access related websites on data corruption, but since we are still not able to isolate the problem – I am posting this detailed explanation...
4
by: DFS | last post by:
" has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair...
3
by: Dave Griffiths | last post by:
Running AC97 under Win2k I have a large database, the front end is about 32MB and contains literally hundreds of queries, form, modules etc Every so often while working on it, say, editing a...
4
by: Eric E | last post by:
Hi all, I have a fairly complex form in Access 2000. In particular, it has two subforms on separate tabs of a tab control. For the last two weeks, I've encountered the dreaded : "You can't...
2
by: Robert Waters | last post by:
Hello, I have a whole lot of VBA DAO code in one of my databases; every so often, Access crashes (and prompts me to backup the db, etc...) mysteriously when I call a function (it is not the same...
5
by: mr_mach7 | last post by:
I have an Access database that needs to be compacted and repaired almost on a daily basis. It is the front end that needs to be fixed, so other users cannot get into it when the problem happens....
4
by: Slez via AccessMonster.com | last post by:
I have a recurring corruption issue that appears to be stemming from a Memo field in a table. I have done extensive searching about this topic and have pretty much implemented all possible...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.