Filter
Top Products
Multi Database
240
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
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
Tip
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.