UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> 1 Access Database - Multiple Sites?, Not applicable    
 
   
heyleese
post May 7 2019, 08:53 AM
Post#1



Posts: 133
Joined: 11-October 10



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?
Go to the top of the page
 
 
Start new topic
Replies
WildBird
post May 7 2019, 07:25 PM
Post#2


UtterAccess VIP
Posts: 3,610
Joined: 19-August 03
From: Auckland, Little Australia


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.

--------------------
Beer, natures brain defragging tool.
Go to the top of the page
 

Posts in this topic
- heyleese   1 Access Database - Multiple Sites?   May 7 2019, 08:53 AM
- - Doug Steele   Is SQL Server a possibility for your backend?   May 7 2019, 09:05 AM
|- - heyleese   Yes? I have Oracle SQL Developer software, but my...   May 7 2019, 10:13 AM
|- - GroverParkGeorge   That is the software you'd use to work with th...   May 7 2019, 10:45 AM
- - GroverParkGeorge   In addition to Doug's suggestion, a couple of ...   May 7 2019, 09:21 AM
- - DanielPineault   Refer to http://www.devhut.net/2016/09/24/access-b...   May 7 2019, 10:47 AM
|- - heyleese   I'm not sure if I have the option of using Ora...   May 7 2019, 01:50 PM
|- - DanielPineault   QUOTE I just don't know which I should pursue....   May 7 2019, 02:18 PM
|- - heyleese   IT won't be supporting this, so can you help m...   May 7 2019, 02:43 PM
|- - MadPiet   If you're trying to run a database engine like...   May 7 2019, 02:52 PM
|- - DanielPineault   QUOTE IT won't be supporting this, so can you ...   May 7 2019, 03:02 PM
|- - tina t   QUOTE It's so successful, management wants to ...   May 7 2019, 03:14 PM
|- - DanielPineault   Tina has explained things quite nicely and she is ...   May 7 2019, 03:41 PM
|- - nvogel   SQL Server (or Oracle) is a much better option tha...   May 7 2019, 03:50 PM
|- - cheekybuddha   >> SQL Server (or Oracle) is a much better o...   May 7 2019, 04:28 PM
- - AlbertKallal   The most easy to get this system running with good...   May 7 2019, 05:09 PM
- - WildBird   QUOTE It works. But it's slow. So slow that it...   May 7 2019, 07:25 PM



Custom Search


RSSSearch   Top   Lo-Fi    21st September 2019 - 06:07 AM