Can I create a SharePoint account to do this?

Diskutiere Can I create a SharePoint account to do this? im Office Forum im Bereich Microsoft Community Fragen; Hallo Microsoft, I have a local database written in Access 2003. There are 5 users. Each user has a copy of Access and a local "replica" of a...
M

MSCom

Neuer Benutzer
Threadstarter
Dabei seit
20.09.2016
Beiträge
1
Hallo Microsoft,

I have a local database written in Access 2003. There are 5 users. Each user has a copy of Access and a local "replica" of a "master" database located on a simple server located on our office network. Once a week (or more) each user opens their replica and synchronizes with the "master" and all their changes are uploaded and they receive any changes that have accumulated in the meantime in the "master".

We only use Access 2003 and no other Microsoft products other than Windows. I am not looking to use Word, Excel or Outlook.

This works really well and has done for many years with little or no issues. It is also pretty snappy. We very very rarely loose any data. It is super stable.

The benefit is that users can leave the office and still be able to work inside the database even if they have no internet or network connection.

The database has become pretty complex over the years and we are constantly tweaking the functionality.

The "maser" and hence also the "replicas" are now 670Mb in size. There are 21 linked tables (The Front End links to 21 tables in the replica, and the replica is then synchronized with 21 tables in the "master"). The format is .mdb

The database is fully normalized so that the Access front end is using multiple tables to display data in its forms.

As Access no longer supports replication and we are considering more "web" based ways to reach our data I am wondering how this set-up could be migrated to SharePoint. Maybe Office 365 Business Essentials can be used for this?


1. Will it still be fast enough? Will Access forms still open fast enough?
2. Can I still use the current Access front end to connect to the data?
3. Can I/Would I connect to my tables residing in DbBee in the same way as I current link to a "Replica"?
4. Is there a way to still keep a local copy of all the data in our laptops when traveling and have no internet?
5. What if this whole thing does not work and we want to move to another system, how can I download all my tables and continues as before?


In other words.. What do I need to do to get up to date?


Really appreciate your help on this.

Regards
Thomas Dahl
 
Thema:

Can I create a SharePoint account to do this?

Can I create a SharePoint account to do this? - Ähnliche Themen

Minecraft Java Edition: Konto migrieren - Spieler sollten jetzt tätig werden.: Mojang als Hersteller von Minecraft schreibt derzeit die Nutzer der Minecraft Java Edition an, die Migration von einem Mojang-Konto zu einem...
Sharepoint Issues with VBA: Hi Guys, We moved our old Harddrive Datas on an mircrosoft cloud, where datas can be retrieved via sharepoint drive Since we moved all our...
Retrieve old data before refreshing database: Hello I have connected my Power BI to SAP server to access data. Every time I refresh the database, the new values appear on the report. What...
Same self-signed code signing certificate for all users on same computer ?: On my own local PC with Office 2019, I would like all accounts to use the same certificate for Office macros (Word, Excel, Access). Otherwise...
Copying a SharePoint online document library to another site: Hi Everyone! We have two sites in SharePoint online and want to copy the content of a document library (~1TB) into the library of the other...

Sucheingaben

casino city

,

poker sequence

,

pokuer sequence

,
how to play blackjack in a casino
, how to play blackjack in a cFasino, stations casino, stations Gcasino, online video poker, online video po8ker, casino in west virginia, lock poker, vee quiva casifno, eagle mountain cNasino, 3 card pAoker online, cOasino city, how many chips do you start with in poker, bodog casino, bodog casinho, poker kings, pokker kings, rainbow casinUo, aria poker room, aria po8ker room, Tcasino tropez, lock pokekr
Oben