|
Database/Multi-user
Software F.A.Q.
|
| |
|
Q. I upgraded an old version of your software to a newer version. Why can I no longer see any of my old data? |
|
A1. If you upgraded from Employee
Project Clock v6 or lower, Project Clock v8 or lower, Timesheets v3 or
lower, Meeting Manager v7 or lower or Pro Schedule v6 or lower you must
upgrade your data to the new format. Step by step instructions to
upgrade your data are seen during installation right after the license
agreement. After installation you can read these instructions by
clicking the "Installation Instructions" shortcut on the program's
start menu. A2.
Possibly you installed the data into a different folder using the Data
only install. You'll need to find out where the old data folder was an
set the data folder option setting to this path.
|
|
Q.
Why am I getting strange errors like this one below?
ElevateDB
Error #600 File manager error (Cannot delete the file
C:\DOCUME~1\fullerm\LOCALS~1\Temp\CM1S29083572PC45.EDBTbl (OS Error:
The process cannot access the file because it is being used by another
process. )).
|
|
A. This is
probably due to your anti-virus software interfering with our
software's database files. Try configuring it to not scan the data
folder of our software.
|
|
Q.
How can we share data amongst several
people with the Standard edition?
|
|
A.
To share
data with multiple users over a network you should install the data on
a network shared folder then install the software on each computer. To
do this run the setup program and select the Data only
installation
option. The Select Destination Location screen
will appear. This will be where the program data will be
placed. Complete the setup for the data. Then
run the setup file from
each of the client machines, choosing the Client only installation for
each one. When asked for the data folder enter the folder where you
installed the data earlier.
|
|
Q.
I installed the Standard edition on only one machine. How can I setup
another machine to use the same data?
|
|
A.
You need to either share the current data folder so the other machines
can access it or move the data folder to a shared location and then
setup each machine to use that data.
|
|
Q.
I want
to share data amongst several people. Can I
use the Standard edition or do I need to purchase the
Client/Server edition?
|
|
A.
The Standard editions of our software (as well as Class
Scheduler, Employee Project Clock, Employee Scheduler, In Out Scheduler
and Project Clock Pro)
all use a local database. A local database can share
data with multiple users over a network. However, shared local
databases are more likely to require database re-indexing especially in
networks with unstable machines or inexperienced users. A general rule
of thumb is not to use the local database edition with more than 10
simultaneous users. With 10 or more simultaneous users the
Client/Server edition will perform better.
|
|
Q.
When I
Start Program X why does the following error message
comes up:
DBISAM Engine Error #9217 Error reading From Data File C:\Program
Files\Cyber App\data\ATable.dat
|
|
A.
This is a database corruption error and it sounds worse than it is.
Several
CyberMatrix programs use a local database to store their data.
Corruption can happen in any local database when a system is shut down
abnormally. You should never shut down or restart a Windows machine
without doing a proper Windows shutdown first (i.e., choosing Shut Down
from the Start menu.) Newer versions of our software will re-index
(repair) tables automatically if all users close the software and a
single person restarts it. To re-index the table manually, first close
down all instances of the software except one. Then select the
problem table in the Detail tab of the Data Manager screen and then
choose File | Re-index
table
(or File | Repair table). There is a Flash demo that shows how to do a backup and repair. Click here to view it.
DBSys
If you are unable to open the application to do a repair you
can get
the DBSys utility.
DBSys
is a utility from Elevate
Software,
the makers
of the database engine used in our database software. Use this program
to repair the affected table.
Last
Resort
If after trying all these solutions you still have problems, you can
zip up the data files and e-mail them to CyberMatrix. We'll repair them
and send them back.
|
|
Q.
When I try to start your software a Data Missing box appears and says
that I need to attempt re-installation or enter new data folder
location. What does this mean and what do I need to do?
|
|
A. The software
cannot find the data. Possibly the drive it was on is no longer
available. You should verify that the machine where the data is stored
is functioning properly and that no changes have been made relating to
the data folder, e.g. drive mapping changes.
|
|
Q.
When I try to re-index a table I get the error "DBISAM Engine Error
#10242 Cannot unlock table or record in the table 'TableX'". How do I
fix this?
|
|
A.
You need to get everyone off the system (shutdown their machines if
necessary) and
try re-indexing again.
|
|
Q.
What
is the purpose of the Users table?
|
|
A.
The Users table merely keeps a running log of which users are believed
to be logged into the system.
|
|
Q.
What is the maximum size of a single database table?
|
|
A.
The maximum size of a table (.EDBTbl, .DAT), index file (.EDBIdx,
.IDX), or BLOB file
(.EDBBlb, .BLB) is 4 gigabytes.
|
|
Q.
Performance seems very slow. How can we make it faster?
|
|
A. Turn off
anti-virus software, or configure it to NOT scan *.EDB* files on newer
software and .DAT, .IDX, .BLB files
on older software (or simply your entire database folder).
|
|
Q.
We are using a UNC path name for the data path setting on XP
machines with SP1. Performance seems very slow. How can we make it
faster?
|
|
A. Upgrade to
SP2. XP SP1 had an issue with slowdowns with UNC path names.
|
|
Q.
How
can I import data from another program into your software?
|
|
A.
Export the data from the other program into CSV format. Then in the
Data Manager screen of our software select
View | Data Manager from the main menu. Select the table then choose
File | Import CSV File.
|
|
Q.
How
can I export table data into Excel?
|
|
A.
Export the table into CSV format in the Data Manager screen: select
View | Data Manager from the main menu. Select the table then choose
File | Export to CSV. Load the saved file into Excel.
|
|
Q.
How
can I use your file-server (local, standard) software with two
different data folders on the same machine?
|
|
A.
You could install the software in two different folders on the same
machine each having separate data. The trick is that the data files
must reside in a folder called Data inside the program's folder.
|
|
Q.
Which
database engine is used in your software?
|
|
A.
We use Elevate DB and the DBISAM database engine for all our
non-Enterprise Windows
business
applications. Meeting Manager, Pro Schedule, Project Clock, Employee
Project Clock and Timesheets now use the Elevate DB engine.
|
|
Q.
Can your database tables be accessed from Crystal Reports or
other common database software?
|
|
A.
For newer non-enterprise editions of our software (Class Scheduler v3+,
CyberMatrix Office, Employee
Project Clock v2.20+, Employee Scheduler, In Out Scheduler, Meeting
Manager v4+, Phone Lister v4+, Point Of
Sale, Project Clock v5.10+, Pro Schedule v3+, Timesheets) we have an
ODBC driver available. See:
ODBC
Driver
A.
For older versions of our software
there is an ODBC driver available that others have used to access
database tables from Crystal Reports. You can get it here:
http://www.cybermatrix.com/download/odbc.zip
We do not offer any support for this older driver.
|
|
Q.
Where
can I learn how to use SQL?
|
|
A.
Try these links: SQLCourse2.com, SQL
Tutorial 1
|
|
Q.
I have
a single license for Program X. I logged in as
someone else, then I had a crash. Now when I try to start Program X
again it says "The number of users have exceeded your license. Contact
CyberMatrix to purchase additional licenses." What do I do to use the
software again?
|
|
A.
Login as the other person, shut down Program X and then login as
yourself.
|
|
Q.
I want to move Program X to a new machine but keep all my data. What is
the best way to do this?
|
|
A.
You could over your program and data folder over to the new machine but
then there would be no shortcuts in your start menu. The best way is to
install the software on the new machine. Then on the old machine do a
backup from Program X's Data Manager, copy that backup file to the new
machine, and then restore the backup file on the new machine using
Program X's Data Manager.
|
|
Q.
I exported a table to CSV. Why is it when I try to import that same CSV
file it says there is an "Invalid data value in import data."?
|
|
A.
When running the CSV import wizard, your time format must be exactly
the
same as what is in the CSV file. Most people leave in the .zzz part in
the import format string when their CSV data does not have
microseconds. The import is not always sophisticated enough to determine what
date/time formats you are using. You have to tell it.
|
|
Q.
We are using version 1 of your software. Is it possible to install the
V2 trial of the software on the same machine so that both versions can
be run side by side.
|
|
A.
Yes. For the Client/Server edition the V2 server would have to run on a
different server machine but V1 and V2 of the client can be installed
into different folders. However you would have to log in as another
user for V2. For the Web edition you would just install V2 in another
folder. For the Standard edition (or Project Clock Pro) you would have
to do a Data Only and
Client only install of V2. The data would have to be installed in a
folder called Data just off the program folder i.e.: C:\Program\Data.
The software would have to be installed in the C:\Program\ folder.
Then you should run V1 and make sure it is still using the old data
folder. Alternatively you could just run V2 under a different user
account i.e. log in as another user for V2.
|
