Exclusive Open Mode

[rwalle]

I Have an Access DB that get data from a industrial Human Machine Interface Software,using an ODBC driver, it loggs process data and send it to my access DB no problem at this point, I have created some querys and reports to see the logged data in a comprenshive way, but when I try to open the DB in other PC over the network I see the Error 3050 " unable to creae the lock file" or something like that, I suppouse is because the exlusive mode the HMI software opens it, so I was wandering about a way to see my DB data over the network since I´d like to share this proccess data with several people

[NeoPa]

I don't understand this at all. If the HCI software provides its data via ODBC then it's not opening the Access database at all, let alone exclusively. From what little information there is available, and trying to determine which of it may be reliable, I guess that you may be having network permissions problems. It's a shot in the dark at this stage as I'm working with no real information, but you could look into that at least. If that's not it then try explaining the situation in more detail (and accurately) and we'll see what we can come up with.

[MMcCarthy]

If the database is opened exclusively by HMI software then noone else can open it until the software closes it. However, the error doesn't reflect that exactly. It should just tell you that the database can only open in Read Only mode.

If you data is not stored in the Access database then you could just give each of the users their own copy with odbc connections. However, I suspect from you post that you are populating the data locally in the database.

[nico5038]

Looks like your database (or folder it resides in) is "read only".
Check the database (and folder) properties and make sure writing is possible.
Access needs to be able to create a .ldb file.

Nic;o)

[rwalle]

NeoPa and Msquare,
thanks for your fast reply, after read it I realized that the folder where DB is stored had an unchecked box related to allow remote users to change the data or full control , now I can see the DB reports and queries, over the network

tks again

Raymundo Walle

[NeoPa]

Thanks for replying Raymundo. It's nice to hear that we were able to help :)

Welcome to Bytes!