Lock File for the MSAccess Application

[Former Member]

Hi Friends,

I have done the simple scenario of inserting the values into the tables of MSAccess database using XI.

But the problem is a lock file is being created with same name as the database name with "ldb" as the extension. It is also not possible to delete this lock file. Because of this my .mdb file cannot be opened...

How to solve this issue?

regards,

Raju...

[former_member187339]

Hi,

>>But the problem is a lock file is being created with same name as the database name with "ldb" as the extension.

Its the propertyof MS Access, whenever the DB is a ldb file will be created.

Try this option. In Receiver adapter select Advanced-> check the option <b>Disconnect fom db after operation</b>.

Regards

Suraj

[Former Member]

Thanks for the Reply ....

The option "Disconnect from database after processing" is already checked. But still the error remains.

I mean in the same folder where I have my .mdb file there itself the lock file is created. And I think because of this file the .mdb file cannot be opened.

regards,

Raju.

[former_member187339]

Hi,

The ldb file is there because your db is being accessed.

Your receiver DB channel is accesing it continuously try different options like commit after transaction etc....

Regards

Suraj

[Former Member]

Hi

I have tried all the options. But the problem still exists. And also this was not the problem with other databases then why with MSAccess?

The ldb file is having the data

"(ServerName)" "admin"

regards,

Raju...