meirfridman
Technical User
Hello everyone,
I built a project in Ms Access with tables, queries, forms, reports and code snippets.
(the program is intended for use online with multiple users logging on and using the same program).
I now need make it available for use by multiple users simultaneously from remote computers.
I tried using the "split database” wizard in Access. The idea was to store the file with the tables/data on a shared folder of Dropbox and each user will have an interface file that uses the data from the common file.
The problem is, a file shared through Dropbox actually lies on each individual computer and is it only updated on dropbox after any changes are made. Each user could, theoretically, change the file without an Internet connection and it will automatically update when the connection is restored. This creates the potential for conflicts and/or the overwriting of data entered by other users.
I looked at the possibility of storing data on an external server that cannot be accessed and/or changed without internet connection. I prefer to leave the program I made as is and not rebuild all the interface and code. I only need the (sensitive) data to come from an external source file.
I tried to Use the Upsizing Wizard and I got into...
(DSN, SQL Server, etc - in that I’m a real novice)
My first question is whether am I really in the right direction?
1. Is this the best way to solve my problem?
2. If so, can anyone explain to me how it works?
3. What is SQL Server; a hosting server or a queries-software, taking data from the server and submitting them to the client?
4. Does Access only work with SQL Server or with Mysql too (the tools built in Access only mention SQL Server)?
5. Do I also need a hosting server and must it necessarily be SQL Server?
6. If I do need a separate hosting server is any free hosting server I find on network sufficient or should I rather look for something specific?
I found here this guide ( but I realized that he explains only for SQL Server and for those who have it already. So I got stuck at the “G spot”...
As understood above, I do not have a website, I have no hosting server, I do not have the SQL Server software or Mysql, I have some email accounts and an Dropbox account. What do I need and how do I get it?
Thanking you in advance
meir
I built a project in Ms Access with tables, queries, forms, reports and code snippets.
(the program is intended for use online with multiple users logging on and using the same program).
I now need make it available for use by multiple users simultaneously from remote computers.
I tried using the "split database” wizard in Access. The idea was to store the file with the tables/data on a shared folder of Dropbox and each user will have an interface file that uses the data from the common file.
The problem is, a file shared through Dropbox actually lies on each individual computer and is it only updated on dropbox after any changes are made. Each user could, theoretically, change the file without an Internet connection and it will automatically update when the connection is restored. This creates the potential for conflicts and/or the overwriting of data entered by other users.
I looked at the possibility of storing data on an external server that cannot be accessed and/or changed without internet connection. I prefer to leave the program I made as is and not rebuild all the interface and code. I only need the (sensitive) data to come from an external source file.
I tried to Use the Upsizing Wizard and I got into...
(DSN, SQL Server, etc - in that I’m a real novice)My first question is whether am I really in the right direction?
1. Is this the best way to solve my problem?
2. If so, can anyone explain to me how it works?
3. What is SQL Server; a hosting server or a queries-software, taking data from the server and submitting them to the client?
4. Does Access only work with SQL Server or with Mysql too (the tools built in Access only mention SQL Server)?
5. Do I also need a hosting server and must it necessarily be SQL Server?
6. If I do need a separate hosting server is any free hosting server I find on network sufficient or should I rather look for something specific?
I found here this guide ( but I realized that he explains only for SQL Server and for those who have it already. So I got stuck at the “G spot”...
As understood above, I do not have a website, I have no hosting server, I do not have the SQL Server software or Mysql, I have some email accounts and an Dropbox account. What do I need and how do I get it?
Thanking you in advance
meir
