[AccessD] Access app for 24/7 usage?

Hello Joe,

Addionally, I would suggest that you build the BE in MSDE / SQL Server.

If you do this, you can forget about compact and repair, you can include
regular maintenance which will run regularly (daily) and you can schedule
backups to another drive / directory that will also be automatic.

While we all love Access, MSDE / SQL Server is built from the ground up to
be used 24/7 or as a friend of mine said at a customer meeting recently
27/4.  Hmm, only works monday to thursday?

Having spent the last two to three years working on VB, I would suggest that
Access is a perfect FE, it but for 24/7, I would prefer not to use Jet as
the BE.  Unfortunately,  if you follow this logic, it suggests that you
should use A2K in ADP mode to use an Access FE only.

Good luck and let us know what you do.

Does anyone on the list wish to give a one paragraph summary of the benefits
of running an exe as a service ?

Mark




----- Original Message ----- 
From: "John Colby" <jcolby at colbyconsulting.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, July 08, 2003 12:42 AM
Subject: RE: [AccessD] Access app for 24/7 usage?


> I tend to agree with Arthur on this.
>
> John W. Colby
> www.colbyconsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
> Sent: Monday, July 07, 2003 10:22 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Access app for 24/7 usage?
>
>
> IMO, for rock-solid reliability you should choose VB and install the EXE
as
> a Windows service. Presumably the data you're grabbing is emitted on a
> serial port or somesuch and is basically a text file that you parse. If
so,
> that's not difficult code to write. As for creating a service, you can
find
> material on that at the Visual Studio Magazine site.
>
> Arthur
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
> Sent: July 7, 2003 10:01 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Access app for 24/7 usage?
>
>
> Hi All,
>
> I am going to be creating an application that parses the output from our
> telephone system and log it into an Access database. This application will
> be running on a server so that it can be up 24/7. What I was wonder is if
an
> Access FE app will be OK running 24/7? Would I be better off creating the
FE
> in VB instead? I think that it would be easier to get the data into the
> database if I use Access as the FE but I am more concerned with
reliability.
>
> Many thanks,
>
> Joe R.
>
>
>
>
> This electronic transmission is strictly confidential to TNCO, Inc. and
> intended solely for the addressee. It may contain information which is
> covered by legal, professional, or other privileges. If you are not the
> intended addressee, or someone authorized by the intended addressee to
> receive transmissions on behalf of the addressee, you must not retain,
> disclose in any form, copy, or take any action in reliance on this
> transmission. If you have received this transmission in error, please
notify
> the sender as soon as possible and destroy this message. While TNCO, Inc.
> uses virus protection, the recipient should check this email and any
> attachments for the presence of viruses. TNCO, Inc. accepts no liability
for
> any damage caused by any virus transmitted by this email.
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>