I hope I can get some help. I along with another developer, maintain a Microsoft Access solution that is giving us lots of trouble lately in the area of database corruption. We talk about using a SQL Server backend combined with an Access frontend all the time but never actually do it for numerous reasons. I’d like to get informed of what is needed and get going in this direction sooner rather than later. I have two very high level questions.
- How will we get the data from the Ships to our corporate Shore side office?
- If cloud based computing is potentially part of the strategy, pros and cons?
The following is a summary of the Access solution we have in place for a cruise line.
A cruise line has cruise ships. A cruise ship conducts voyages. On a voyage transactions occur. During the voyage, transactions, settlements and other information are entered into an Access database backend file through an Access frontend file. At the shore side office we have essentially the same Access solution that the ships use. We have a process in place in which at the end of a voyage the ship emails us an Access file with all the information collected for the voyage. Once we receive this file at our shore side office, we can run the Journal Entry. Journal entries are done by shore-side staff accountants.
I’m imagining each ship with a free version of SQL Server as the number of users on each ship will be less than ten. Then somehow at our Shore-side office with the number of users of the system being anywhere from ten to thirty with fifteen to twenty concurrent users during peak times.
Will you good people please offer some high level direction on how we at shore side can get access to the data that is on the ships at voyage end using SQL Server, and provide suggestion game plans to make this a reality instead of wishful talk?