Multiuser & Remote Connections
By default, SpeedBase connects to its built-in, file based database and does not require a server machine or installation of a server side software (with the exception of SQL server option).
You may choose and go with any of the available connection options given below whichever works best for you.
- Single User on a PC:
This is the default installation to a computer with Windows operating system for local use only.
- Local Network:
You may connect to your database using a computer in your local network via a shared folder. SpeedBase should be installed on to
the computer with Windows operating system for each user. Your database however might be located on any computer or storage device within your local network.
Remote connection via internet is not possible in this option.
Note that, you most likely have a local network already if you have multiple computers at home or in the same office that share the same internet connection.
You may connect to your database via a VPN connection. All you need is to setup a VPN server for this option (see below).
SpeedBase should be installed on to the computer with Windows operating system of each user. You may then connect from anywhere around the world via internet.
Your connection is secured by the VPN software with password and encryption.
We recommend Hamachi
- SQL Server:
This option allows you to remotely connect to your database from anywhere via internet. You must have the required technical skills
to install and manage SQL server on a server machine to go with this option.
You may consider moving to sql server if you need remote access without the requirement of a VPN, you already have a server machine
with sql server and you want to optionally share your data with some other software or web interface.
More details and setup instructions are explained on this page.
- Remote Desktop:
You may connect to your database via a remote desktop software or device. This option allows you to connect from
anywhere around the world. You only need to install SpeedBase to the remote server machine running Windows operating system.
The clients can be any device (mobiles, tablets) with any operating system as long as they support remote desktop connection.
Your data is secured by the remote desktop software with password and encryption.
Beware that opening multiple remote desktop connections to the same host computer
requires additional licenses from Windows server product family. This makes this approach more suitable for companies who already have setup a
RDS (terminal services) based computing environment.
Do not try to share your database between multiple computers by using file sharing services like Dropbox, Google Drive, OneDrive etc.
These services are based on synchronisation and do not technically create shared folders as in Windows operating system.
Connection from multiple devices -even if at different times- via these type of services are NOT supported and will most likely cause serious damage to your database.
Key Points to Remember
- SpeedBase is a desktop database application. It is NOT an online database service, i.e. it is not possible to access your data from
a web browser by simply opening a web site.
This also means that, it is NOT possible for a random, malicious internet user to access to your data by taking advantage of a security hole
on your web site.
- As many users as your license allows may concurrently connect to your database and work as a team.
- File sharing services like Dropbox, Google Drive etc. may NOT be used to connect to your database via internet as these services do not
create a real shared folder like in Windows operating system.
- For multiuser access: All data (i.e. records, design changes, layouts, views etc.) is saved to the same single location and all users will see/share
the same data unless you create access restrictions. No data is stored on individual user computers.
- For multiuser access with local network connection: You do not need to install SpeedBase or any other software to your server. You actually do not need a server,
however you need to employ either a computer or a storage device to keep your database. That device should be left up and running in order
to accept connections from users.
How to Setup Multiuser Connection within a Local Network
SpeedBase can connect to your database thru a shared folder on your local area network.
Follow the steps given below to allow multiple users to connect to your database:
- Choose a computer, a storage device or your existing server in your local network on which your database file will reside.
Try to choose a device which is up and running during whole working hours if not all time, as your database will only be available
as long as it is up.
- Create a shared folder. (See the end of this page for more information about creating shared folders)
- Go back to the computer where your current database was created. Locate the data folder of your database.
To find out the folder location, open "connection settings" window from "system" menu. The path is displayed under "local data folder" title.
- Click on the data folder link on connection settings window to browse that folder on Windows Explorer.
- Right click the data folder, click "Copy". (Its location is "My Documents\SpeedBase\data" by default unless you changed before)
- Browse to the shared folder, right click the shared folder and click "paste". This will create a copy of the
data folder including your database and other data files.
- Start SpeedBase, open "connection settings" window, click browse button under the title "local data folder location".
Browse into the shared folder, select the copied version of your data folder, click OK.
Caution! You should select the path of your data folder, do not select the folder having the name db!
- On "connection settings" window, select your database file from the box titled "Database Name".
Click "Save Settings". Click "Exit". SpeedBase will now connect to the database from the shared folder.
- Repeat the last two steps on all other computers to allow them to connect to the same database
under the shared folder.
Tip: If you cannot see any entry in the "database name" selection box, you have probably selected the wrong folder
as "data folder". Try selecting either the parent or the subfolder of the currently selected folder.
Tip: Practically, you will be able to connect to your database as long as you are able to browse to the shared data folder via Windows Explorer.
Make sure that the connection settings window of SpeedBase on each computer shows exactly the same data folder location and database name.
You are strongly recommended to remove any older, unused, duplicate copy of your data folder from your network to ensure no computer gets connected
to an old copy of your database by mistake in the future.
Testing the Connection
It is essential to make a test if the database is shared on all computers successfully.
If the change is not visible try clicking the reload button on the current window.
- Login to SpeedBase from one of the client computers and make some change on a record in your database.
- Move between each of the client computers to check that your modification is visible on all of them. You may need to click "reload" button.
If the change is still invisible, check connection settings to make sure that all computers are connected to the
same database file on the same shared data folder.
How to Setup Multiuser Remote Connection using a Virtual Private Network (VPN)
There are a number of easy to use, easy to setup VPN products available on the internet.
Once you setup the VPN software on both of your host and client machines, the VPN software will allow the user on client computer
to browse shared folders of the host computer. You may then adjust connection settings
on SpeedBase to connect via the shared folder.
In some cases you may need to adjust firewall settings on either machines to allow the VPN product to connect successfully.
Consult the documentation of your VPN product or consider to get help from a network expert if needed.
Creating a File Share on Windows 7