Basic help to move forward

[adishardis]

Hi all,

I'm still treading water. In my office we use an access database which in i tself works great! We are only 5 people using it at the moment, could become more though.

The problem however is that we have it in cloudstation and we can't use it simultaneously which we do quite often, or try to do...

Starting back from zero, what is the best way to solve this problem. Preferably a solution not to complicated, as you can gather I'm still a tool regarding these issues.

We have a synology ds-212+ NAS with mysql at the office and my best bet would be to convert the access database to sql and store the backend there. But I think I need a step by step guide to accomplish that!

So do any of you have any suggestions on what to do, how to do it or just general tips to get me in the right directions?

Peace
Adam

 

[Mr. B]

Adam,

The problem however is that we have it in cloudstation and we can't use it simultaneously which we do quite often, or try to do...

What is the purpose to having your Access data base in "cloudstation". Are all five of these users in the same physical location or are they located in different locations?

If your Access database a split database application (Front-end and Back-end files)?

 

[adishardis]

We use it constantly while on the run as well in the office!

Thanks for taking time to reply!

 

[MSAccessRookie]

I do not know much about "cloudstation", so I have to ask how is it accessed, and whether it is possible for more than one user to access it at the same time. For instance, could the Database be split with the Front End being available on the User Workstation and/or Laptop, while the Back End is available on the "cloudstation"?

 

[fastfreddie]

I'm a little late to the party here but will throw in my two cents' worth if you're still looking for a solution, or if someone else is wondering about the Synology option.

For about three years, I have been running four different databases on our Synology DiskStation 211+. We have fifteen users who can all use these databases simultaneously without any problems.

-These are split databases, with the backends running on the DiskStation.
-I've distributed Runtime versions of the frontends to all users.
-It's possible access the databases remotely via VPN (the DiskStation has this functionality built-in), but I find it much faster to use remote desktop software such as Chrome Remote Desktop or TeamViewer.