Database Connection Issues

[TOPPY123]

Hey,

I am relatively new to programming and I have some questions about my current project. I have only ever made local databases ie. Over a lan with multiple users and I do not know how to connect multiple users over the internet. I have made a large database for a freight company and we now need to access the database simultaneously over 5 separate internet connections. I have a static ip for the database to be accessed from and I have done a little bit of reading on connection strings and SQL Server but I really don’t know. Can anyone please help me on the best way to make it work?

Thank you

 

[OlcayM]

Hi,

Some time ago, I used a software named "WEBDrive" for a similar problem. This software lets you MAP and IP as a drive like "F:\" . Then you work with your database like you are in a LAN. But, as far as I remember this had some restrictions.

Otherwise, I believe that, it will take quite a time to learn how to do it (not impossible) for you, as a person who is new in VBA

HTH
OlcayM

 

[TOPPY123]

Connection Issues

Hey,

Thank you for the reply. I am unsure if I should continue working in Access or if it is a better solution to go straight to SQL Server. I don’t know if there is someway to write a connection string into my project to connect is to a remote IP address that has the tables on it, or if access is unable to do that over an IP.

Thank you,