Using Access with HTML...

[cavery]

Hello, I 'm in the process of creating a webpage, but I want to use data from Access tables. Does anyone have any knowledge of how the two intergrate?

Also is it possible to use HTML without a Network? My IS department wont give the necessary space to put this on the network, so I cant create a intranet based webpage. Ideally, I wanted to create a webpage that users can still access,(similar to a network) but have that webpage stored on a drive, if thats possible.....thanks for the help.

Clark

 

[psemianonymous]

Access databases can't be accessed via straight HTML - you have to have a server-side scripting language to be able to "use" a database. If your company does not have ASP support (or whatever it's called) on their web server, you can stop here--it's not possible otherwise.

If they do have support, you will be able to (mostly) test your ASP on your own computer. Install the Personal Web Server on your computer, run it, and connect to yourself to test.



PS--you can use Access MDB's from other server-side scripting languages such as PHP and Perl, I believe, but I don't think that's what you're asking.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[cavery]

Thanks for the response....

2 things
1) I want the ability to have a webpage, that can be used similiar to a webpage that was stored on the server. But since I dont have a server, would I be able to store the webpage on a normal drive? IE, E:/drive, F:/drive etc.

2) I want the user to be able to add data to an Access database, at that point, it would send data to my webpage, similar to an export command. But it sounds like this cant be done....

Thanks

 

[psemianonymous]

1. No, once you got into production mode, you would have to store your web page on the server -- this doesn't mean your database has to be on the server necessarily. But it does mean your ASP files/html/everything else would have to be on the server.

2. Don't rule this out. The web server is, as far as an Access database is concerned, just another computer connecting. You'll have to talk to your IT people to find out what folders the web server can "see" that you can also "see" - maybe they'll create a new folder just for this purpose (yes, it's possible). You would then be able to open your database as it was being accessed via the Web, with no hitches (depending on what you're doing of course).


Talk to your IT/IS/computer people. They'll either say yes or no, but I say it's possible.


Again, check google and ASP web sites for help on how to set up Personal Web Server for development on your PC.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm