[AccessD] MDB on the web

Data corruption?  I guess it depends on the hit rates.  Both our
Intranet and our Internet sites are powered by Access .mdbs (several of
them).  We get almost 500 users a day on our website, and we have a
little over 200 users in house for our Intranet.  I have NEVER had a
corrupt database on ANY of these databases.  I have only ever had
corruption on .mdbs that have a non-web interface accessed across a
network. (with one exception involving a multi-threading experiment)  

Now, one difference may also be the webserver itself.  An apache web
server (which I believe runs on Linux/Unix) may have issues with an
.mdb.  I run strictly IIS servers.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, February 14, 2008 2:55 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MDB on the web

Hi Drew:

Some other people who have been using that type of system have had some
data
corruption when the hits rates increased. It may have nothing to do with
the
use 'Server.MapPath("/MyDatabase.mdb")' or it may be just the MDB or the
connection type used. Maybe it might be worth moving to MS SQL
Express...
the initial price is right???

Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, February 14, 2008 7:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MDB on the web

Why won't a DSN-less connection work?  You just have to know where the
database actually is on the hosted server.  You can find this with (I
think) Server.Path.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, February 14, 2008 12:34 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MDB on the web

Hi All:

What connection method and code do you use to connect to an MDB DB on
your
web sites? (I have only used MS SQL in the past and that is fairly
straight
forward.) 

My client had originally hard coded the MDB location in a Global file
variable and used the DSN-less Database Connection method but that will
not
work now that he is planning on migrating to a public internet hosting
company. Is there a way to pre-setup an ODBC Database Connection that
would
work on any location?

Any insights and coding samples would be greatly appreciated.

TIA
Jim    

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the
person or entity to which it is addressed and may contain II-VI
Proprietary
and/or II-VI BusinessSensitve material. If you are not the intended
recipient, please contact the sender immediately and destroy the
material in
its entirety, whether electronic or hard copy. You are notified that any
review, retransmission, copying, disclosure, dissemination, or other use
of,
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited.


-- 
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
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.