Re: Using Access Database across network

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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;257757

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"


.

Relevant Pages

  • Source Control or something else?
    ... I have two web pages with separate forms that both dump ... into one Access database. ... what should those settings be? ... Server that need to be in place. ...
    (microsoft.public.frontpage.client)
  • Problems setting up a web server with Win XP and IIS 5.1...???
    ... Win XP Pro with IIS 5.1. ... content, mostly the default settings). ... I assigned a static local LAN ip to my web server (not in the range of ...
    (microsoft.public.windowsxp.network_web)
  • Re: asp.net web page error
    ... Third page is called - uses session ... variable to get data from sql server to display users performance. ... Can web server disconnects idling link? ... The server has settings for this... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: intranet problem
    ... all computers have automatically assigned DNS and ip settings. ... >>our company's web server is running on a winxp pro sp2 machine. ...
    (microsoft.public.windowsxp.network_web)
  • Form Data in Access
    ... into one Access database (two separate tables). ... what should those settings be? ... Server that need to be in place. ...
    (microsoft.public.frontpage.client)