Calus 2014, our free software for inventory, uses a data connection to various types of files, the default is to use an Access database with Jet 4.0 engine, but it can also work with other database, for example: SQL Server, MySQL, Oracle or another, the only important thing is that OleDB driver has registered. For those who do not chew these concepts is already difficult to understand the operation now, so you need to focus only on the use of the Access database.
As you know uses an Access database that is located in a file with the extension “mdb” or other, but the format should be the same. Since the introduction of Microsoft Vista™ every time you try to edit a file that does not reside in user space you have to raise the use of space to administrator (there is a way to eliminate this nuisance, but most users leave the system as well as bought), so we could no longer leave the database file in the program folder. The software then you first start copying the database file in the folder empty space user and in particular in the address “C:\Users\Username\AppData\Roaming\RGPSoft\Calus“. In Windows XP, there would be the need to act in this way, but it is the same process, only this time the user space is located at “C:\Documents and Settings\Username\Data\RGPSoft\Calus“.
The program also allows you to backup your data, but, as you can well understand, only if it is a database to a file and not on a server.
To share the database between multiple locations must then copy the file of the model database (to be done with a simple backup) in a shared network folder and make a new connection using the Jet provider 4. For a server there are no problems because it is already shared in the network database (archive). The difference between the two is that with Access file, you can share the database only on a LAN, while the server is also possible to work via WAN.