Creating a Multi-User Environment
Setting Up Multiple Users
Setting up multiple users to access our database software is as easy as deleting or renaming a file, starting the application, and linking to the new file. Therefore, if you are using an Access database file, you should be familiar with the help topics for finding your database and moving your database and you will have all the skills you need to add multiple users to your Ape database software system. If you are using a SQL Server, then read the help topics on Installing a SQL Server and Connecting to a SQL Server Database.
Move Your Database (MS Access Database Only)
Find your database and move your database to a network location where all of your users have read-write access. Most of the difficulties users experience with implementing a multi-user environment have something to do with network folder permissions. So if you experience any difficulties, you should first seek assistance from your network administrator.
Note: The only file you need to move to your shared network location is the 'apecal.mdb' database file.
Setup a Common Files Folder (Access & SQL)
Ape database software uses a Common Files Folder that contains four sub folders (i.e., Attachments, Emails, Labels, and Reports). Ensure each networked user of the Ape database software is using the Common Files Folder so its sub folders are equally accessible to all users. Do this by:
- Common Mapping: Ensure each user has the same network mapping for the Files Folder. For instance, if a mapped drive (e.g., "M:\Server2\Common Files") is used for one user, the same path will be used for all users.
- Point Ape Database Software: Open the Folders tab of the Options dialog and change the 'Location of Files' (i.e., Common Files Folder) to the common network location (step 1).
- Move Folders: If custom files already exist in the old location(s) of the Files Folder, move those files to their new Common Files Folder locations (step 1). Specifically, move all attachments and custom templates (e.g., reports, labels, & emails).
Add Additional Users
When running the software on a client for the first time, it presents the option to create a database (blank or with sample records) or to navigate to an existing database. Therefore, after starting the software on a new computer and seeing the dialog below, check the 'BROWSE to Existing Database' option and [Continue] if a database already exists in a network location.
Otherwise, if a database has already been created on a client that needs to be networked (i.e., linked to a database on the network), delete or rename (safer/suggested) the local 'apecal.mdb' file. If already running the Ape database software, find the folder for this database file by selecting Open Data Folder from the Files dropdown menu. Otherwise, refer to the finding your database help topic.
Last updated: 11 July, 2017