Question Locked

How to share a database file between Win 7 computers

0 helpful
13 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am attempting to run an accounting program from a remote client computer. The program is installed on a Win 7 computer. The client is also Win 7. Both computers are attached to a LAN.

The program folders are shared and not marked read only.

I can open the program successfully from the client computer. However, when trying to run the program, an error message appears reporting that a database file cannot be accessed because it is read only.

The program can be run successfully by the same user on the host computer. The user has administrator rights on both computers.

Any thoughts on why the client computer thinks the database files are read only?

Any advice is greatly appreciated!

Thanks.

13 replies

by oh smeg

Some mark their Data Files as Read Only and can not be networked unless you pay for the Net workable version.

Col

by troyteck

That's a good thought. However, the developer that wrote the program was the one suggesting I share it between co-workers. He watched as I made the folder sharable and could not explain why the db files would not open on the client computer.

Thanks for replying.

by oh smeg

You could start another Data File on the second Installation of this program and see if you can share that.

Don't just copy the file across but start a new file. It doesn't need lots of data just the 1 entry will do.

Col

by troyteck

I will give it a try. Just to be clear, the entire program is installed and runs only on the first computer. The second computer is just opening the program via a shortcut that is pointed to the .exe on the first computer.

Thanks!

by oh smeg

Was the Original Program open when you tried to log in from the remote computer?

That could cause the Read Only Message.

Also if the first computer already has the file open you're not going to have any joy accessing the Data File from the second unit.

Col

by troyteck

Thanks for your post. Good points. I seem to get the error whether the first computer is running the application or not. It seems like a rights issue to me.

by charles bundy

Coming from the application or the operating system? Only reason I ask is if it is coming from the app, the problem may not strictly be a read-only lock. How does that app access these db files? Could it be a DSN rather than a file system issue?

by troyteck

The message is a Windows message. Sorry, I'm not sure what a DSN is. Thanks for your time.

by darryl~

On the "Sharing" tab for the folder & looking at the permissions there....there is a check in the box next to "Full Control".....correct?

by troyteck

I did check the main folder that I was sharing and checked the full control box. Seemed to make a big difference. Will be using the program now from "computer #2" and see how it goes. Thanks much for posting!

by darryl~

People sometimes miss setting the sharing permissions in addition to the regular permissions.....I suspect that will have solved your problem ;)

by raakeshtomar

Dear share database on new network drive that is y:
and use this on all computer

This discussion is closed to new replies.