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: 7 Nov 2016
Compatibility: Calibration Control MS Access
versions 8.7 to current (previous versions use a different dialog)