Claude,

Thank you so much. I implemented your suggestions below on a Win 2000 workstation and my COM+ component worked great. Now I have just one more question.

If I want to implement my COM+ component on more than one workstation on the LAN, must I use your impersonation/identity configuration directions below on each work station, or is there a way to implement/configure the impersonation/identity of the component once, like on the server, so that any workstation can access and use the component? Also, must each workstation acessing the component have the VFP runtime installed?

Joel


>On Windows2000, go into Control Panel, Component Services:
>1.)Right click COM+ applications and select New.
>2.)Using the wizard, create an Empty Application,giving it a name/check server application, and selecting the appropriate account to run under.
>3.)After the Empty Application is created, Right click on 'Components' under the newly created application.
>4.) Select New/Component.
>5.) The wizard starts - select 'Import components that are already registered.'
>6.) Select the name of your vfp mtdll from the list and it will be added to this new COM+ app.
>7.) Right click on the new COM+ application name and select 'Start'. The COM+ icon is now revolving in the Components pane.
>It should now be running under COM+ now using the Impersonated User.
>>Claude, how do you give an mtdll "the proper impersonation/identity." I don't know what this means. How do you implement the proper impersonation/identity? I want to use the mtdll to create a function in Excel using VBA that can access data from VFP tables on a network drive.
>>
>>Joel
>>
>>>For networked access to your vfp database, you've got to run your mtdll from COM+ (create a COM+ package) giving it the proper impersonation/identity. Same with using a mtdll with SQL/MSDE/Oracle/MySQL...
>>>>I'm sure this question has been asked 1000 times but this is my first exposure.
>>>>
>>>>How do you access a mapped network drive from a VFP DLL? I seem to be able to access local data but not data on a mapped network drive. Will someone please point me to an article on this?
>>>>
>>>>Thank you.
>>>>
>>>>Joel