>I have a database that is shared on a client/server network. It runs fine on a stand alone basis, but when I try to access the executable on another machine with it running on the first machine, it says access is denied, database is open. I have set exclusive off before I open up the database, but I still get this error before the application gets to the first screen. Are there any other commands I need to make this executable run properly in a client server environment? Note, except for tables that have single records in order to run queries, no data is changed.

1. "What Ed said." Sounds like you're misusing the term client-server. You just mean a shared database on a network.

2. I suggest you check whether your problem is SET RESOURCE ON and a single FOXUSER.DBF/FPT in the directory with your executable. If you do have RESOURCE ON, and a FOXUSER.DBF/FPT file is in the executable's directory, you'll have to make the FOXUSER files read-only for multiple people to run the program.

I'd suggest that SET RESOURCE ON may not be useful to your network app, anyway. Mostly useful during development anymore. (Used to be, back in FPD days, printer drivers were stored there, among other things. And some people use FoxUser files to store user preference type things in. But if you're not using it because you have a reason to, i.e. RESOURCE is ON because it's the default, you probably want to turn it off.)

HTH