>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.
You may check Exclusive properties in DE.Cursors (maybe you accidentally reset some to .T.). Also, remember that private datasession reverts many settings back including SET EXCLUSIVE.
PS: when you move data to network, it does not mean yet that you have client-server environment.
Edward Pikman
Independent Consultant