publish database as web site

[Mike Hodkin]

I have created a simple Access database containing our club member names,
phone numbers, and emails. How can I publish this my ISP so that users can
access this information on the club web site? That is, how can I publish my
database to the internet so that users can access this online?
thanks,
MJH

 

[Kevin @ 3NF]

Read-only, or do you want them to be able to update online?

 

[mike]

I also need to publish an Access Data Base on the web. I
am on a Web Server that supports Access and has provided
me a DSN. When I open up the Data Base through an HREF,
it will accept data but not save it. I need this Data
Base to be updated on line.

Thanks.........Mike

 

[Peter T]

You can save a report as a web page and upload it.

Peter

 

[Arvin Meyer]

I also need to publish an Access Data Base on the web. I
am on a Web Server that supports Access and has provided
me a DSN. When I open up the Data Base through an HREF,
it will accept data but not save it. I need this Data
Base to be updated on line.

You will need to create ASP pages, or use similar technology, to update the
data. The server must also support that technology.

Be aware that while Access can handle these requests, it is not a server
database, and cannot take heavy simultaneous hits without corrupting. I have
seen as little as 2 or 3 people who are impatient with the speed of a
report, clicking the submit button repeatedly cause corruption. I have also
seen a few thousand hits a day work fine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

Hi Mike,

Actually there are 2 that I know about. One, done 5 years ago in A97, is no
longer in service because it was updated to SQL-Server. But it ran for
almost 4 years. The other is in A2000 format and is in current use. It's on
a public website that averages 6 to 7 thousand hits per week. Every night at
2:00 AM it is FTP'd from the client's site to the web server. It has only
corrupted once and that was corrupt before it was sent. I don't want to
publish the URL, because as you know, a lot of simultaneous hits will bring
it down.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access