[AccessD] Back End On Linux

[James Button]

Yes – 'file hosting' is no problem – providing the link is good – without dropouts

 

But the post was " back end run on a" – and to me, that implies the actual DBMS.

 

If it's just the file being held on the filestorage – then – As long as the link to the file is good, there is adequate on-line timeperiods, and maybe an appropriate backup and get restored copy back 'to-current-last-input' status maybe – warm – or at least 'just wants power-up' standby facilities – 

heck – for me that means:

A second PC, and the software installed on it – 

just needing the files brought back from

the latest backup image set – last (monthly) partitionimage, 

Yesterday's daily data sets, 

and the ongoing cloud based incrementals,

followed by email – and whatever I was typing or copying or restructuring when the system failed.

 

A commercial database server – well I'd expect backup images at 24 hour intervals – and you have to 'manage' the 'back-to-current' updating of that.

Maybe email update log to a couple of stores (Gmail, Microsoftmail) every 30 minutes, or when they reach 8MB  ( bytes to comms traffic adding 15% - and avoid 10MB attachment limits) 

 

JimB   

 

From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Thursday, July 14, 2016 7:48 PM
To: James Button <jamesbutton at blueyonder.co.uk>; 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Back End On Linux

 

Hi Rocky and Jim

 

If the Linux system is just a file host/share, all you need a SMB share on the Linux box, usually via Samba which these days is pretty much standard. That’s how all the NAS boxes Work.

 

/gustav

 

Fra: James Button <mailto:jamesbutton at blueyonder.co.uk> 
Sendt: 14. juli 2016 20:27
Til: 'Access Developers discussion and problem solving' <mailto:accessd at databaseadvisors.com> 
Emne: Re: [AccessD] Back End On Linux

 

2 Simple questions may solve that - 

What application facility would you be running on the back-end system to manage

the data going in to and being extracted from the .mdb or .accbd file

Can that run on the Linux platform to service the links in from the front end

systems.

 

I suppose there are a 3 & 4, and even 5 - 

What will that cost compared with doing the action on a windows OS - even if

that is a version of the OS that will run under a Linux environment

How much effort will that take to setup, licence, run, and to maintain

What's your pay rate for the hours needed

 

JimB

 

 

-----Original Message-----

From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky

Smolin

Sent: Thursday, July 14, 2016 6:52 PM

To: 'Access Developers discussion and problem solving'

<accessd at databaseadvisors.com <mailto:accessd at databaseadvisors.com> >

Subject: [AccessD] Back End On Linux

 

Dear List:

 

Can an mdb or accdb back end run on a Linux platform with the front end on a

Windows box?

 

 

TIA

 

 

Rocky