

If it could handle two users at once that would be awesome, but its not necessary. Not more than one user would be using the database at once. I just need it to be available for some users in a different place, but a different time. According to what I've found, it seems quite difficult to use Access through the web. I have searched and read a bit about using access through the web. We wouldn't have multiple users at once, but we do have different locations where we have people that might need information from the database. Is it possible to make the database and store it in dropbox? To keep it synced. However I am trying to figure out one last thing. I thought on using Access since it seems to fit all of our needs. but it just can't handle the amount of data we store on it.

We tried using google docs as it can handle real time sync. We use dropbox to do that and we have come across a lot of issues (different versions being created, people renaming the file, people accidentally erasing a file. Excel was working fine, but it has become impossible to keep excel synced. so yeah, we really need a database to keep track of our projects. We are a steel detailing company and we have to handle tens of thousands of different parts per project. One of the first results that show up when looking for a database for a small company is Access. That's when I decided it was about time to start looking for other options. We started having a lot of problems due to the limitations of our current configuration. We currently use Microsoft Excel and Dropbox to keep everything. there's a huge debate out there in the web related to Access and SQL and I would like to avoid any discussion in this post if possible. I have decided to make it in Access after a lot of reading.

Microsoft access database cloud Pc#
Guide to Connecting to your Home or Office PC from Anywhere (groovypost.I am trying to do a simple database for a small, but very busy, company. I don't know if any product actually solves this problem but in all the cases where my client has given me remote connections, if they were not server based, someone always needed to go kick the PC if it was off which of course made it awkward for me to work weekends and evenings but not impossible. The option that connects to a specific PC will require someone to be on-site should the PC need to be rebooted. I've used both server based RD and RD that connects to a specific PC that is not shared. This is probably the most cost effective assuming you already have the hardware and the Consumer version will be sufficient for your needs.
Microsoft access database cloud software#
When software is "free", YOU are the product.īest remote desktop software of 2021: Paid and free choices for businesses | TechRadar I would NOT recommend using a free option. One at the office connected to the LAN and a second wherever the user wants to work. This would be a short term or long term solution but it REQUIRES two sets of hardware. There are several products that allow you to connect from your home computer to your office computer and have access to other things on the LAN such as printers. If you have workstations that can remain in the office, you have other options. They work better when the BE is SQL Server.

VPN's tend to be too slow when your BE is Jet/ACE.
