If you have an enterprise level Microsoft 365 account and are using Access 2013 or better for the front end, then having multiple users simultaneously access a shared, online back end using the Access desktop software is possible. That is what I am doing with my company's database. It works quite well for us. You only need one Microsoft 365 account and then you can distribute a front end with the connection information. One downside is that the writing speed for the online database is extremely slow, though access speed isn't too bad.
Re: FW: One Drive
Fri Jan 15, 2016 12:27 pm (PST) . Posted by:
"Bill Singer" agent1of6
John,
Currently I only do this while developing which is why it is only one computer at a time. I have not tried it with multiple users.
Thanks for the information.
Bill
Bill-
I suspect you didn't get an answer because those of us who are familiar with building Access applications over a network can't imagine that you can do that successfully over the web unless you use the 2013 web apps. It sounds like you're thinking about building a "desktop" database in the classic style with linked tables. I have no clue how you would build the links to a back end in the "cloud." And it's not surprising that only one user can open the database at a time if it's in the cloud. Access needs a full update lock on a database, so in the cloud, the first user probably locks everyone else out.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Jan 15, 2016, at 8:42 PM, 'Bill Singer' Bill.Singer@at-group.net <mailto:Bill.Singer@at-group.net> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups.com> > wrote:
I am sending this out again just in case it was missed.
I have a few Access databases in the cloud. One on Microsoft One Drive and one on google drive that I am building for someone else.
I can work on any of them from multiple computers but I do it only one computer at a time. The front end and back end are in the same database. What would be the problem with putting a multi-user database on the cloud and having multiple people log in at one time?
Is it possible to have the front endo on my computer and the back end in the cloud?
I think I have seen discussion on this but I can't remember the problems?
Thanks,
Bill
Access 2013
Minnesota.
Posted by: rhagglund@myeigo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar