The Microsoft Jet database engine stopped the process because you and another user ar

[Acke]

Hello!

I am working on a database that uses a table from another access database. I am not sure but I think the problem started after this line was added to the code:

Set dbk = OpenDatabase("D:\My documents\Japi\OritaColor\Baze\Knjigovodstvo1.1.mdb")

The database still works fine on one machine. When I copy it to another machine, that is when I receive 3197 error.

When I copy database to another machine without the code that contains the line from above, and copy the same code in the same form after opening copied databse, the problem is solved.

Does anybody know why is this happening? How can I fix this?

Thank!

 

[Alisa]

Maybe its because you have a space in mdb (md b) in your code?
Or maybe that database doesn't exist in that location on the other machine?
Or maybe both machines are trying to open the same database at once and it is set to open exclusive?

 

[Acke]

Thank you for your reply!

Maybe its because you have a space in mdb (md b) in your code?

This is just a spelling mistake.

Or maybe that database doesn't exist in that location on the other machine?
Or maybe both machines are trying to open the same database at once and it is set to open exclusive?

The application is always working on just one machine. Machine 1 is where I am making the application and machine 2 is where the application will end up eventually. It is working fine on the machine 1. If I want to copy the .mdb from machine1 to machine 2 successfully, I need to delete the code containing mentioned line and copy the .mdb without the code. Then, after the .mdb is successfully copied to machine 2, I can open it, but it doesn’t contain the code. Next, I copy the code from earlier created text document, to its original location. Then everything works fine on the machine 2 as well. If I want to copy back from machine 2 to machine 1, I need to repeat the process.

Therefore, the code is correct; it works fine on both machines.

 

[Alisa]

I don't think just deleting and repasting a line of code would make any difference, there must be something else going on, but it is hard to tell what . . .