Jim Dettman
jimdettman at verizon.net
Mon Dec 31 07:37:47 CST 2012
<<I can not disagree either Hans or Stuart; they are spot on.>> I do. As Drew pointed out in the past, if you can live with JET constraints (database size, no on-line backup, etc), JET actually works quite well as a data store for a web server. Why? Because only the database server software touches the DB. Users connect through the server software, not directly to JET. As a result, if the JET DB is on the web server, it is a very stable situation. Even more stable then the normal multi-user scenario that JET is used with. The proof of that is Microsoft Exchange. Up until a release or two ago, it was all run with JET (slightly different version, but it was still JET). Biggest drawback is maintenance; DB can't be on-line while you backup, do a compact and repair, etc. Sounds like for this project though it might be workable. However with that said, there is a simpler way to get an Access DB on the web: www.eqldata.com if you don't mind paying the subscription. Works exactly like it says it does. Take any existing DB and you can put it on the web. There are some considerations that need to be made. In essence, it works the same as if you were running it under terminal services. The other option is Office 2013 and through Office 365 you can get everything you need to run it (again subscription). However Access web databases are not much good for anything other then basic CRUD operations. VBA is not allowed and what you can do with them is very limited. However for what's been outlined, I don't foresee any problems. And of course the last option is to run a terminal services server and have users remote into that, which can be done through a web browser. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Saturday, December 29, 2012 11:12 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access Database on Web Hi Tina: I can not disagree either Hans or Stuart; they are spot on. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields Sent: Saturday, December 29, 2012 3:23 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access Database on Web Hi Guys, I've got two fairly straight-forward database projects coming up, that need to be available on the Web. One is of scanned images of soil erosion permit applications. People must apply for a soil erosion permit in Michigan if they are planning to do any tree cutting or earth modification within 100 feet of the state waters. Lake associations realize the importance of monitoring such applications. In order to make the records easily available, the county soil erosion officer wants to scan the permit applications and put the images online for the public to search. The second one is of data pertinent to streams that we monitor - macroinvertebrate inventory data, pH, temperature, clarity, etc., plus the GPS coordinates of the sites. I have never put a database online, and I could use some tutoring on how best to go about it. The databases themselves don't look complicated, but putting stuff on the Web for search is new to me. Thanks for all the good advice you will be giving me! T -- Tina Norris Fields tinanfields at torchlake.com 231-322-2787 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com