Create new database
Selecting System | Local database |
Create new local database will take you to a dialogue for this purpose. REM. the
term Local database refers to the database in your local network.
The dialogue has the following
options:
Select database type - Select Microsoft SQL-server if you have either
Microsoft SQL Server 2000, Server 2005 eller Server 2008 installed in your
system and intend to use it for your DentalEye database. Microsoft Access
database is suitable for networks up to about 5 concurrent users while SQL is
recommended for use in larger networks. It is possible to convert an Access
format database to a SQL database later if needed. As the SQL database is more
complicated to install we recommend that it is only installed by experienced
staff.
Depending on your database type choice you will be presented options for
this type: For SQL you must provide a Server name (the name of the computer
where SQL is installed) and a Database name of your choice. For Access you must
provide Path and file name for your database file.
Image store path - this is the folder where your images will be stored. It
does not need to be the same as where your database resides.
Copy demo database from CD - if you check this option some patients,
templates, images and toothgroups will be added to your new
database.
Add default templates - if you check this option some basic templates and
toothgroups will be added to your new database.
When clicking OK the database will be
created and selected as your default choice. If you intend to use this database
from all workstations in your network you must select the database on each one
of them.
Make sure that you have a backup system
covering the folders that you selected before you start using the system.
If you run SQL you must make sure that
the database files are backed up properly. Consult your network supplier if
you're not sure how to do this.
Local database info
Selecting System | Local database | Local
database info; will open a window with information about the currently selected
database.
You will see where the database is
located and what version it is. (This version number is not the same as the
version no of the program itself.)
You can also see how much free space you
have in your Image stores.
Some statistics from the database is also
presented including number of patient, images and templates.
Setting database
Selecting System | Setting database will
open a dialogue where you choose your active database and edit the image store
settings.
Most likely you will only use this
function when installing the system. When creating your database on one
workstation you will have to use Setting database to select the newly created
database on the other workstations.
The dialogue has the following
options:
Select database type - Here you have to choose the same type of database
used when creating it.
User name/Password - Here you provide the login information for your SQL
server. For Access databases this is currently not relevant.
Depending on your database type choice you will be presented options for
this type: For SQL you must provide a Server name (the name of the computer
where SQL is installed) and then choose Database name from the list. For Access
you must provide the Path and file name of your database file.
Image store(s) for database - This is where you can administrate your image
stores. An image store is a folder where images are stored. You can have more
than one image store but only one selected as active. The active imagestore is
where new images will be saved. The others are only used for retrieving old
images. Please note: Currently you need read and write permissions both in the
active and the non active image stores. It is possible to Add new image stores,
Delete imagestores with no images in them and Change path (...) to an image
store.
The database selection is saved as
default for the currently logged in user only. If you log in with a different
username you will have to use Setting database for that user too. This is useful
in the case where 2 users wanting different databases but work on the same
PC.