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.
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
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?
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (4)|