Using Access Database across network

Hi,
Having problems with security settings! I have an ASP application using
an ACCESS database with ADO. I want to run it on a local server and
access it from my two clients.

I gather Microsoft do not like you to use Access Applications such as
Set objAccess = Server.CreateObject("Access.Application")

across a network on a server. I have an inhouse application which I do
want to run locally on our server and allow the 2 client computers to
run the same application.

I have reset Directory Settings (in IIS for the directory)to be
IUSR_Computername and unchecked the "Allow IIS to control password".
(from some google group research!)

It still won't work! Coming up with "Error accessing the OLE registry"
errors.
What settings should I use?

Re: Using Access Database across network

WolfWoman wrote:
> Hi,
> Having problems with security settings! I have an ASP application
> using an ACCESS database with ADO. I want to run it on a local server
> and access it from my two clients.

Wait a minute. Is the Access database on the same machine as the IIS web
server? Or on a different machine?

>
> I gather Microsoft do not like you to use Access Applications such as
> Set objAccess = Server.CreateObject("Access.Application")
> across a network on a server.

Sort of.
http://support.microsoft.com/default.aspx?scid=kb;en-us;2577 57

It's not the "across a network" part that is the problem. It's the
server-side code part that's the issue.


> I have an inhouse application which I do
> want to run locally on our server and allow the 2 client computers to
> run the same application.
>
> I have reset Directory Settings (in IIS for the directory)to be
> IUSR_Computername and unchecked the "Allow IIS to control password".
> (from some google group research!)
>
> It still won't work! Coming up with "Error accessing the OLE registry"
> errors.
> What settings should I use?

If your database resides remote machine (in relation to your web server),
read this:
http://www.aspfaq.com/show.asp?id=2168

If your database is on the same machine as your web server, read this:
http://www.aspfaq.com/show.asp?id=2126

If this does not help, provide some more details and show us some code.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"