I've always done my asp with SQL server and have SQL server on my Windows
2003 Server.
I now need to use an access database for several .asp pages.
I've created my access database using delphi and I'm storing it on the
server.
Do I have to do anything other than creating a DSN to use this database?
Do I have to install jet or access on the server?
Thanks,
Mac
Mac Davis wrote:
> I've always done my asp with SQL server and have SQL server on my
> Windows 2003 Server.
>
> I now need to use an access database for several .asp pages.
>
> I've created my access database using delphi and I'm storing it on the
> server.
>
> Do I have to do anything other than creating a DSN to use this
> database? Do I have to install jet or access on the server?
>
Don't use a DSN:
http://www.aspfaq.com/show.asp?id=2126
Access itself is not needed but you will probably need to install Jet which
I do not believe is installed by default. Just search for it on the MS
website.
Keep in mind that all users of the database require Modify permissions for
the folder containing the database file in order for multi-user activity to
be possible. That means if your website uses Anonymous access, the IUSR and
sometimes the IWAM accounts on the machine must be granted that permission.
Otherwise, you need to assign all your users to an AD group which has the
appropriate permissions for the folder.
--
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"