Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-09-2018, 12:00 PM   #1
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Access without network server

I help a company currently using Access to manage day-to-day activities of their site. They have historically maintained a network server and the database (back end) lives here. They are considering "going to the cloud" so as not to have to maintain this network server. Not completely sure what they have in mind, but what do we need to do to continue using the Access database? Thank you so much!

eacollie is offline   Reply With Quote
Old 10-09-2018, 03:31 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,438
Thanks: 40
Thanked 3,368 Times in 3,263 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Access without network server

access is not intended to work in the cloud however there are options.

1. migrate the back end to sql azure - potential issue is security - you tell sql azure which IP addresses are allowed to access the database, so not suitable for access while on the move. Benefit is you can continue to use the access front end, but linked to azure rather than the LAN based backend.

2. use citrix or terminal server - both front end and (access) backend are hosted on the server - each user has their own profile so still retains their own copy of the front end. Generally quite fast as the only movements across the internet are screen refreshes one way and keyboard and mouse events the other. Also can be run from none windows devices. Potential issue - needing to reference local files/printers/email/etc

This is a fairly common question and you need to be very clear about what 'in the cloud' means to you. Is access required from home/while travelling?, continue to work without an internet connection? access via smart phones? What is the performance of your broadband connection? etc.

None of the above is comprehensive, you will need to do your own research to determine the full range of upsides and downsides and which route to go, but you have some key words you can use to search. And be aware none of it is particularly cheap although I presume you will have savings by not maintaining the existing network server.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 10-18-2018, 04:57 PM   #3
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Re: Access without network server

Thank you CJ.

As I understand the plan, it is to purchase MS Office 365 Business. This solves their problem of maintaining a network server and works well, I understand, for Outlook but Access is a problem.

Currently there are two users of the database but more (probably not more than 10) need to be able to use it. It is strictly used on-site. It needs to be multi user. They do need to print reports, etc locally.

With this outline, which do you think is the best way to go?

I appreciate your help very much! Thank you in advance.

eacollie is offline   Reply With Quote
Old 10-18-2018, 07:10 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,433
Thanks: 13
Thanked 1,419 Times in 1,353 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Access without network server

I've had good success with Citrix. However, my clients all host Citrix on their own server. You can find a provider to do this for you but it might be expensive if you have too many users. The price I was quoted (about two years ago) was $35-$50 per user per month and this included the price of O365 which they required. The version of O365 might affect the cost and so will the number of licenses. If your BE would be SQL Server rather than Jet/ACE, the cost would be higher due to the cost of the SQL Server license and database support. Even if they allow the use of SQL Express (which is free), you still need support to manage the database.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 10-18-2018, 07:10 PM   #5
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,468
Thanks: 62
Thanked 1,174 Times in 1,074 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Access without network server

Keeping it on site offers you a cheap if not perfect alternative. Dedicate one machine on the site network as the "permanent" back-end host. It DOES NOT have to be a server. Heck, if it stays on-site and has a hard wired network, just set it up for Windows file sharing, set aside a folder for the BE file, and get working.

Note: If the site uses a Wi-Fi network, this is NOT suitable because Access doesn't work well over Wi-Fi.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 10-19-2018, 12:36 AM   #6
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,438
Thanks: 40
Thanked 3,368 Times in 3,263 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Access without network server

If all your users are office based (and will remain so) and the objective is to do away with your local server and use the cloud then I would look at using sql azure as your backend as a possibility. In principle you can continue to use your access front ends basically unchanged other than linking the tables, but in my experience will need to make some changes for the fact you are working across a WAN rather than a LAN - see this link for the sort of things you will need to consider https://www.access-programmers.co.uk...d.php?t=291269

Otherwise stick with citrix/terminal server. Budget is always a consideration - they may or may not be more cost effective than azure. However the migration should be simpler.

I also agree with Doc, you could dedicate a 'normal' computer as a server, or invest in a NAS device (Network Attached Storage) which is easier to maintain than a full blown server
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 10-19-2018, 06:43 AM   #7
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,462
Thanks: 51
Thanked 949 Times in 918 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Access without network server

None of this is trivially easy though.

A single user can use an Access solution on his own PC.

A system with multiple users requires a different solution. Each user needs access to (ie the ability to use) a database with the relevant forms, queries, and modules to manipulate the data (the front end). All the front ends need to connect to the same set of data, which is termed the back end.


You don't have to "split" a database into two, but for multi-user systems every developer will recommend splitting a database.


So you need two things,

a) a central hosting for the back end, which can be on server located somewhere in the business, or on a remote server, maybe in the "cloud".

Now access doesn't work tremendously fast with remote data, so you would need to test both the connection and performance. The worse your broadband speed, the worse the experience.

b) a local hosting for the local databases. Now if you solved the first problem by having a business server, then the PC's need to be on the same LAN as well. They may work from remote locations, but there will almost certainly be performance issues. If you chose a "cloud" solution, such as azure, as mentioned, then you may be able to work from anywhere, but there may be performance issues.

There may be hosting services where you can connect to your front end database over the internet, but you would need to investigate.

c) Finally note also that although in theory all users can use the same version of the front end, the practice is different, and recommendations here will always be for each user to have a separate copy of the front end. We would not recommend having a single copy of the front end database on a server, used by multiple employees within the company.


A lot of this is going to be "try it and see". You need to be able to build a working database, and then determine the best way (or at least an acceptable way) to use within a working environment.

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 10-20-2018, 05:32 AM   #8
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Re: Access without network server

Thank you to all! This gives me a lot to look at.

eacollie is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Client/Server app issue on a network. jasabel General 5 08-23-2012 03:17 AM
Question Find if a Network Server is on AliyuKatsina General 8 06-22-2012 04:43 AM
Network Print Server Question rkrause Hardware Questions and Answers 2 06-05-2009 04:07 AM
Office network to web server Fernando General 0 06-25-2007 07:41 AM
Hosting DB on a network server lilFlip General 4 11-01-2006 03:01 PM




All times are GMT -8. The time now is 10:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World