[AccessD] Preparing Database for Web

David,

  Well at this point, having a "web interface" doesn't mean moving away from
Access.  You have the Access 2010/SharePoint 2010 setup, which I hear is
fantastic (haven't used it myself).

  There's also one company out there that offers Access DB's on a web
portal:

  www.eqldata.com

  Again, haven't used them myself and haven't heard of anyone that has, but
if they can do what they say they can do, then it's almost a no brainer; any
version of Access through a web browser with no conversion.

  Might want to check them out.

  As far as using JET for a backend, it does work well.  What Drew has
pointed out many times and people forget is that in a web setup, the only
user touching the DB is the web server itself.  Outside hits don't matter.  

   Where the rub comes in is maintenance; no on-line backups, no
recovery/roll forward if something goes wrong, and the DB has to come
off-line to do Compact and Repair.

  Unless this is a non 24x7 DB with light usage, I'd be looking at another
BE.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: Sunday, December 12, 2010 03:00 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Preparing Database for Web

Team,

I have a customer who want a simple database created which will 
ultimately be hooked up to a web interface (Order screen for fabric 
samples, and tracking screen to show status of order).

I still need to sit down with them to work out the likely number of 
records, simultaneous users etc (which I am doing tomorrow).

Currently their databases are all Access.  Assuming the size of the 
new database will be well within Access limits, is Access  suitably 
robust for web applications, or should I start off with SQL?

I will be getting someone else to do the web side of things but want 
to make sure that I make it as easy as possible (read cheap) for them.


Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com