Sure. That's how they all start out.

Just be aware that if this app takes off and you need to somehow make it
available to a potentially larger audience, the only advice you'll get at
that time is to rewrite your code and move to something more suitable for
load.

--
//David
IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
//
[quoted text, click to view]
I am using this for a local intranet, and is only to be used by a
small group of people. Access is still used on the web and works quite
happily with other projects I have done in work. The problem seems to
lie locally with my machine.

Thanks

Greg








[quoted text, click to view]

Greg,

Check your temp dir (probably C:\winnt\temp) for permissions. The temporary
directory must have a minimum of Read, Write, Change and Delete permissions
for IUSR_<machinename>.

Article 253604 covers this in more detail.
253604 PRB: Microsoft Access Database Connectivity Fails in Active Server
Pages
http://support.microsoft.com/?id=253604

This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks!
~Andrew Davis
Microsoft PSS Security

--------------------
| Content-Class: urn:content-classes:message
| From: "Access" <anonymous@discussions.microsoft.com>
| Sender: "Access" <anonymous@discussions.microsoft.com>
| References: <46f9fca8.0312141145.3f62fb19@posting.google.com>
| Subject: Authentication Error - HELP
| Date: Sun, 14 Dec 2003 13:36:28 -0800
| Lines: 44
| Message-ID: <015301c3c28a$552fb090$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| thread-index: AcPCilUt9JGcit8kTwaBlMOnTr9HhA==
| Newsgroups: microsoft.public.inetserver.iis.security
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.inetserver.iis.security:7876
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.inetserver.iis.security
|
| This may or may not be the problem: verify that the
| account your ASP page is running under has write access to
| the physical folder "adotest/backup".
|
| HTH
| >-----Original Message-----
| >Hi,
| >
| >I'm trying to set up my home pc with 2000 pro IIS 5
| installed. After
| >writing a simple asp page to open a database and pull
| back the records
| >of a table to test, I am getting an error :-
| >
| >c:\inetpub\wwwroot\adotest\backup\myhols.mdb
| >Provider error '80040e4d'
| >
| >Authentication failed.
| >
| >I have checked all the usual errors:-
| >set up iusr guest account for full rights
| >set up anomonous authentication
| >even followed tech nets advise to give iusr 'act as part
| as os' within
| >user rights assignment
| >
| >Microsoft script debugger says it gets the Authentication
| error on the
| >following line:-
| >
| >conn.Open localpath
| >
| >within
| >
| >localpth = Server.MapPath("/adotest/backup/myhols.mdb")
| >set conn=Server.CreateObject("ADODB.Connection")
| >conn.Provider="Microsoft.Jet.OLEDB.4.0"
| >conn.Open localpath
| >
| >Thanks for any help anybody can give me.
| >
| >Greg C
| >.
| >
|