Honeywell K14392V1 Renaming a Multi Db, Multi Db MinAdmin, File name of a local db is userid.mdb

Multi Database

Tip

Step 2 for making a copy of a db is not obvious.

Your usual account may not work in the database that you plan to copy. If you use the database’s “Administrator” account, the password may differ from the “Administrator” account in the Multi db that you usually use.

3.Leave or type that account’s password.

4.Select the database engine that will read the Multi db that you plan to create.

5.Replace the name of the database with a new name. You can also change the path, folder and server name, as needed.

Tip

For Windows 98 users using MS-SQL Server or MSDE, a database server name must be typed.

The database server(s) cannot be automatically identified and listed at log on.

6.Click OK. The Create Database window appears. See fig. 14–5, above.

7.Select either:

•Create from existing MS-Access database. Type or browse for the location and name of a *.mdb file.

- or -

•Create from existing SQL database. Select a server and type a database name of a *.mdb file.

8.Click OK. The new database is created based on the data in the model db; the Admin window appears. The information that you see is a copy of the model database.

Renaming a Multi Db

Tip

You can rename a Multi db using standard Windows techniques. For example, use Windows Explorer to locate a *.mdb file and rename the file as you would any other.

Multi db naming restriction

The file name of a local db is “<userid>.mdb”.

This is why the [name of a Multi db] should not be the same as one of its users.

When adding users to the database, do not use the “[database name]” as a user name. A user account with the same name as the database causes an error when a copy of the database is made locally.

Multi Db: MinAdmin

Template

For Administrators of client MinAdmin software, there is a Generate Template command in the File menu. The command is used to provide central databases for MinAdmin software. The template imposes restrictions on: rights of MinAdmin’s Administrator account, administration of system password and access to the Multi db used to create the template.

240