I've been tasked with developing a Visual Studio application to replace an Access database. Currently, the user uses the Access db on her desktop but occasionally copies it to her laptop to take offsite. When she comes back, she copies the db
from the laptop to her desktop. She'll need to do the same with the app.
Developing a web app is not an option. There's no internet where she goes offsite. This would be a great situation for a web app, IMHO.
Boss wants the data to be stored in SQL Server onsite. My thinking is that I would develop a winforms app and provide her a way to copy the SQL data to an Access db on the laptop, along with the app. When she uses her laptop, she'll be using
the Access db as data storage. When she returns, I'll have to provide her a way to transfer the data from Access back to SQL Server.
With older versions of Access, there was replication. I think this is a good case for it. Now there is Sharepoint, which I understand should be used instead of replication (???)
Is Sharepoint the method I want to use? Are there other alternatives?
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.