Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Network Issues _ 1 Access Database - Multiple Sites?

Posted by: heyleese May 7 2019, 08:53 AM

I've developed a successful database. It's a split multi-user access database with the data accessed from our local server and the front end is local

It's so successful, management wants to implement it in multiple sites globally and share the data.

It works. But it's slow. So slow that it's unusable. So it doesn't work.

What are my options? Can we have multiple backends and replicate that data back to a master backend? SharePoint?

Are there any simple solutions that I can do myself without purchasing additional software?

Posted by: Doug Steele May 7 2019, 09:05 AM

Is SQL Server a possibility for your backend?

Posted by: GroverParkGeorge May 7 2019, 09:21 AM

In addition to Doug's suggestion, a couple of comments.

It would be unwise, I think, to try either a multiple accdb/merge process (head-aches soon to follow) or SharePoint (less than adequate performance).

Posted by: heyleese May 7 2019, 10:13 AM

Yes?

I have Oracle SQL Developer software, but my usage, experience, training is minimal.

Posted by: GroverParkGeorge May 7 2019, 10:45 AM

That is the software you'd use to work with the ORACLE database. Does that mean you have the option of using Oracle?

Posted by: DanielPineault May 7 2019, 10:47 AM

Refer to http://www.devhut.net/2016/09/24/access-back-end-location-wan-online-server-onedrive-dropbox/ (the What are the Alternatives Then? section)

Posted by: heyleese May 7 2019, 01:50 PM

I'm not sure if I have the option of using Oracle. How would I know for sure?

Also, I'm downloading MySQL.

I've read the devhut section. Most options are not an option for me. I'm glad to have options, I just don't know which I should pursue.

I've tried remote desktop - too many users, the company keeps taking the desktops we designate. Citrix is not an option. I don't know TeamViewer or Terminal Services. I've never heard of or used Azure, I'm not sure my company would let me put data "in the clouds"

Thanks everyone, for your input, so far.

Posted by: DanielPineault May 7 2019, 02:18 PM

QUOTE
I just don't know which I should pursue.

It depends on your infrastructure and what IT will allow. I think at this point you need to sit down with IT and disclose your various options and see which one(s) they are will to support and then you can come back to us and we can try and help decide on which option would be optimal, but there is no point discussing all the options as you might not even be able to implement some of them.

Posted by: heyleese May 7 2019, 02:43 PM

IT won't be supporting this, so can you help me narrow it down to what I can do without IT assistance and support?

Posted by: MadPiet May 7 2019, 02:52 PM

If you're trying to run a database engine like SQL Server or Oracle, you're out of luck. You can't install it or configure it without permissions on the server. If IT sets up SQL Server and designates you as an Admin, it might work. But SQL Server and Access are pretty different. I used Access for maybe 15 years before starting on SQL Server. Similar in a lot of ways, but also very different.

Oh, and one other thing... if you set up security in SQL Server to use Windows authentication, you would control who has access to which SQL Server objects by creating AD groups and then assigning permissions to those AD groups in SQL Server, so... that would be really fun too.

Posted by: DanielPineault May 7 2019, 03:02 PM

QUOTE
IT won't be supporting this, so can you help me narrow it down to what I can do without IT assistance and support?

There is no means for you to support a WAN based solution without some minimal setup/support from IT. They will need to perform minimal installation/configuration/setup... for you to then be able to take the reins.

I like the idea of both CITRIX or SQL Server (or Azure). Both of these require IT intervention for initial setup so you can have the necessary permissions to then do your thing. They need to tell you what is already available or what they are willing to setup for you to use, no way around that.

Posted by: tina t May 7 2019, 03:14 PM

QUOTE
It's so successful, management wants to implement it in multiple sites globally and share the data.

well, it's your company's management who want a multi-site implementation. whether they have to listen to IT, or IT has to listen to them, depends on how high-up the management folks are. but i see that as their fight, not yours.

suggest you tell them that while the program you developed is great on a LAN, it can't be successfully implemented on a WAN. then suggest some options that you believe you can handle - or learn to handle - and tell them what support (setup, permissions, etc, as others have mentioned) will be needed from IT. and let them fight for it, or choose to abandon the idea, as they wish.

hth
tina

Posted by: DanielPineault May 7 2019, 03:41 PM

Tina has explained things quite nicely and she is right, that is exactly what needs to happen.

I have been down this road numerous times with many clients and their IT Depts. Many are very helpful, but there are cases in which IT don't want to know anything. As Tina stated, it is up to management to politely put their foot down and make IT do what is needed. That is most certainly not your role as a developer. Explain things to whomever wants things to progress to multiple sites, feel free to show them this thread, and then let them take it to the IT Dept for discussion.

Posted by: nvogel May 7 2019, 03:50 PM

SQL Server (or Oracle) is a much better option than MySQL. All of them are free to download and use. As others have said, you will need support from your IT Department. It's not very realistic to think you can handle multiple locations across a network without the support of the team who are responsible for the network, servers and information security.

Posted by: cheekybuddha May 7 2019, 04:28 PM

>> SQL Server (or Oracle) is a much better option than MySQL <<

A rather tired and out of date sentiment, IMHO.

Posted by: AlbertKallal May 7 2019, 05:09 PM

The most easy to get this system running with good performance from all locations would be to adopt windows terminal server.

Or, if the company has Citrix (it really the same technology.

So, given that some IT infrastructure is in place now, then I would very much consider using windows terminal services. It would also mean that you don't have to modify the application, and all users from all locations would achieve good performance. In fact a laptop at a coffee shop with wi-fi would also work well.

So, access will not work well over a WAN as you have discovered. I explain this isuse here:

http://www.kallal.ca//Wan/Wans.html

Do read the above. Its just so amazing - time and time again, I see companies setting up WAN + vpn, and then they find out the network is too slow. That's why I wrote the above article.

But, right now? Most quick approach and least amount of effort on your part would be to adopt terminal services. It going to cost more then say using SQL server or some other database for the back end, but you then don't have to do a data migration, or change your existing application. (or at least the changes are the most minimal of any other choice you make).

Regards,
Regards,
Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada


Posted by: WildBird May 7 2019, 07:25 PM

QUOTE
It works. But it's slow. So slow that it's unusable. So it doesn't work.


This goes from It works, to It doesnt work in the same line...........

My thoughts are to use the concept of what you have. Get professionals in. You will be wasting time and money on anything that you dont understand. Explain how and what your system does without talking about any code or anything, get this documented by a Business Analyst, and get a professional who can work with IT dept to build it properly. may sound harsh, but trying to do a DIY approach to a global system will end badly and cost more money.