By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Exclusive Open Mode

P: 47
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
Jan 11 '10 #1

✓ answered by 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)

Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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.
Jan 11 '10 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Jan 11 '10 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 11 '10 #4

P: 47
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
Jan 11 '10 #5

NeoPa
Expert Mod 15k+
P: 31,494
Thanks for replying Raymundo. It's nice to hear that we were able to help :)

Welcome to Bytes!
Jan 12 '10 #6

Post your reply

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