Bug #24187 Problems with MS Access Database
Submitted: 10 Nov 2006 13:31 Modified: 22 Nov 2006 13:58
Reporter: Everton Andrade Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.1.5rc OS:Windows (Win XP)
Assigned to: CPU Architecture:Any

[10 Nov 2006 13:31] Everton Andrade 
Description:
When is selected a MS Access database as source of data and the process is completed the file source still locked. 

A .lbd file is created when a .mdb (considering MS Access file) is accessed sying for OS that file is alredy in use. The MySql Migration Toolkit is not deleting this file making this "unusable".

How to repeat:
Use a MS Access database file.

Suggested fix:
Before de process completed, delete the .ldb file.
[22 Nov 2006 13:58] Michael G. Zinner 
We are using the JDBC/ODBC bridge to access the MS Access database. It seems to be a bug there.

We could delete the file but this would cause conflicts if the very same .mdb is opened in MS Access at the same time.

Therefore I have to mark this bug as "won't fix" because JDBC/ODBC bridge bug fixes are out of the scope of the Migration Toolkit.