brett wilson

Hi,
Does anyone know how to set the "Allow InProcess" option
for the Jet 4.0 provider if you don't have the Enterprise
Manager (only MSDE 2000)? I have found some references to
changing a registry key, but I don't have the "Providers"
key in the registry at
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer. Why
don't I have a list of Providers in this registry
location? Is that something that is installed with the
SQL Server client tools or something?

My problem is that when I try to query the linked server
while logged in to MSDE as a normal user, I get an error
saying the Jet Provider can't be started. I don't have
any problems if I am logged in with administrator
privileges on the MSDE machine. It appears to be a
problem with permissions when attempting to create the out
of process Jet Provider. What account would the out of
process Jet Provider be started under? My MSDE
installation is running as a system admin.