>Hi UTers
>
>I have a vfp application called myapp.exe that uses data tables in a dbc called mydata. I have made a multi-threaded com server, myapp.dll, that also uses the tables in mydata.dbc. I use the automation server in WORD, EXCEL and even on Active Server Pages. I get an "access denied" error in vfp when I launch myapp.dll and then myapp.exe. The .exe and the .dll work with the data table individually but not together.
>
>Any thoughts?
>
>Neil
As Jess pointed out, you will need to open your .DBC and tables non-exclusively. You can SET EXCLUSIVE OFF (note that this is scoped to the datasession). Alternately, you can use the SHARED clause of the OPEN DATABASE and USE commands.
Note that you must open the .DBC SHARED as well, not just its member tables.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up