MS Access and Internet - Web permissions for Access 2000 database

Author

Web permissions for Access 2000 database

Carstonio

2005-07-14, 8:25 pm

I want to use an Access database for a calendar of events on a Web site. How
do I set up the connections so that I can edit the database while visitors to
the site are viewing the calendar? I created a Data Access Page as a Web tool
for editing the database, but it puts a lock on the database and produces a
'Could not use ''; file already in use' error on the calendar page.

I've used phpMyAdmin to edit databases with MySQL, and haven't had this type
of permissions problem.

Here is the code on the page that displays the calendar on the site.

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.mappath("calendar.mdb")
set conn= Server.CreateObject("ADODB.Connection")
conn.Open strCon
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM calendar WHERE date >= #" & Date & "# ORDER BY date"
rs.Open strSQL, conn
do until rs.EOF
--print fields--
rs.MoveNext
loop
rs.close

And here is the ConnectionString generated by Access in creating the Data
Access Page:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=C:\calendar.mdb;Mode=Share Deny None;Jet OLEDB:System
database="";Jet OLEDB:Database
Password=""</a:ConnectionString>

Also, I know that before the calendar goes live, I should set up a password
on the database. Should that be done entirely in Access? Can the Data Access
page be used for logging into the database?

Any help would be great.

Sylvain Lafontaine

2005-07-14, 8:25 pm

The ODBC or OLEDB drivers for Jet / Access doesn't work over the Internet;
only over a LAN or for the local machine. Your solution is to install/use
RDS or replace Access with MSDE or SQL-Server.

see
http://msdn.microsoft.com/library/d...l/deploydap.asp
for info about using RDS (but honestly, you should forget about it).

There is a newsgroup about DAP: m.p.a.dataaccess.pages .

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

"Carstonio" < Carstonio@discussion
s.microsoft.com> wrote in message
news:9D68D0B3-B07D-4DE4-8003- EAFAC1D9AB43@microso
ft.com...
>I want to use an Access database for a calendar of events on a Web site.
>How
> do I set up the connections so that I can edit the database while visitors
> to
> the site are viewing the calendar? I created a Data Access Page as a Web
> tool
> for editing the database, but it puts a lock on the database and produces
> a
> 'Could not use ''; file already in use' error on the calendar page.
>
> I've used phpMyAdmin to edit databases with MySQL, and haven't had this
> type
> of permissions problem.
>
> Here is the code on the page that displays the calendar on the site.
>
> strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> server.mappath("calendar.mdb")
> set conn= Server.CreateObject("ADODB.Connection")
> conn.Open strCon
> set rs = Server.CreateObject("ADODB.Recordset")
> strSQL = "SELECT * FROM calendar WHERE date >= #" & Date & "# ORDER BY
> date"
> rs.Open strSQL, conn
> do until rs.EOF
> --print fields--
> rs.MoveNext
> loop
> rs.close
>
> And here is the ConnectionString generated by Access in creating the Data
> Access Page:
> <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
> Source=C:\calendar.mdb;Mode=Share Deny None;Jet OLEDB:System
> database="";Jet OLEDB:Database
> Password=""</a:ConnectionString>
>
> Also, I know that before the calendar goes live, I should set up a
> password
> on the database. Should that be done entirely in Access? Can the Data
> Access
> page be used for logging into the database?
>
> Any help would be great.

Sponsored Links