MS Access 2010 multiple online users

Dear Jim, thanks for your input. Honestly SharePoint works fine for my needs. The only problem I have is that the current service provider from time to time disappears and my data are trapped. Of course I do back up from time to time but I can't have a daily backup to overrule this disservice. I have searched for alternative sharepoint hosting providers but these are expensive for the minimal use we have (it's really minimal, three users, maybe once every couple of days). This is the reason behind my will to find alternative solutions and found out that cloud it's a remote storage rather than a real live platform that consents multiple users working simultaneously.

I will now evaluate eqldata.com as suggested by you and it's costs. Meanwhile I will also wait for some further inputs and consideration by other users. Hope this will happen in the next 48 hours and based on this I will positively close this question.

Thank you and kind regards.

Here's a link for detailed service descriptions by the way:

http://technet.microsoft.com/en-us/library/jj819284.aspx

Jim.

It's something we're evaluating but the issue is that we'd need to update everyone's office versions which is another cost, while now we are running MS Office of various versions.

I totally agree with  Jim's comments.

It is possible to have multiple users working simultaneously in the cloud. Did you know this site is a cloud application with multiple users working simultaneously?

Unfortunately the JET and ACE (.mdb and .accdb format) database engines are not true client server database. They do not have the ability to have  remote connections through the internet. By switching your back end to an SQL Server then you can do what you want. As previously pointed out, there will probably be some things that wioll need to be redesigned for client/server.

There are hosting services that will host an SQL Server database (MS SQ;, mySQL, Oracle, etc)  for you or you can do it yourself.  You can use Access, VB6, .Net, etc to create a front end that connects to the remote SQL Server. to allow multiple users to work simultaneously

I have VB6, VB.net and Access applications that connect to a remote SQL Server (mSSQl and mySQL) . This allows multiple users working simultaneously from many locations.


If your app is a really simple app then you may consider converting it to be browser based with a tool like Iron Speed ( http://www.ironspeed.com ) and host it with  a service like Discount ASP ( http://www.discountasp.net/).

Dear TheHiTechCoach, thanks for your explanation. The fact is that we need a local interface, not web, as it prints formatted docs such as physical cheques, which web apps can't.

JDettman has understood my needs and his solutions are probably my best options I need to work on.

Dear TheHiTechCoach, thanks for your explanation. The fact is that we need a local interface, not web, as it prints formatted docs such as physical cheques, which web apps can't.

That is not actually true. Web apps can absolutely print checks.

Quickbooks online does it and my own commercial Access and  web based accounting system does it.

FYI: I have been designing, developing,  and selling  VB/Access/SQL Server based accounting systems for 15+ years . My system also includes a browser based front end that can print the checks to blank check stock  including the MIRC encoded routing/accounting information.  I have 100's of remote users.

Note: Microsoft SQL Server Reporting Services can be used by web apps and it is more power than Access reports.

If you have not looked into it, I would highly recommend checking out Quickbooks online. It does everything you will need and will be a lot more reliable.  You could be up in a few days not a few months or longer trying to learning to it yourself.

Otherwise, I would recommend hosting it yourself on your own Terminal server.  I have over 500 remote users running Access applications this way. My office works almost 100% of the time in a RDS/RDP session. All the local users in the office work like remote users off the Terminal Server.

TheHiTechCoach, thanks for your info. Your input will become subject of discussion.

You're welcome. Good luck with your project.