F.A.Q.

Home | Database Team | ACC

What's New
Database Download
Database Guides
F.A.Q.
Suggestions
Errors & Omissions
Database References
Cytogenetics Links

This page contains answers to common questions, along with some tips and tricks that we have found useful and presented here as questions.

 

bullet

Known issues regarding the ACC CVS Database
 

bullet

Where should I copy (install) the database?

bullet

I’ve copied the database – how do I start it?

bullet

Why do I get a “no permission” error when trying to start the CVS Database?

bullet

Why does Microsoft Access close down with a system error (or report a table/database corruption) when I try to use the CVS Database?

bullet

Why doesn't the database fill the whole computer screen?

bullet

Can I run the database from a CD?

bullet

I don't have a copy of Microsoft Access; can I still use the database?

bullet

Can I print out listings and cases?

bullet

Can I write my own queries to search the database?

bullet

Why does the search routine give no results?

bullet

Can I install the CVS Database on a network drive?

bullet

Why do some cases appear with no karyotype information?

bullet

What happens if details of a submitted case have been published?

bullet

There isn't enough room to display the full karyotype.  How can I see it?

bullet

When a filter is applied to the case listing, the drop down lists do not match the filtered data.

bullet

Why is the version number so long?
 

 Into which folder should I copy the database?

 You may install the CVS Database into any folder where you have read/write permissions.

Back to Top

I’ve copied the database – how do I start it?

 Simply double click (run) the access MDE file

Back to Top

 Why do I get a “no permission” error when trying to start the CVS Database?

You are joined to a Microsoft Access Workgroup file as a user who is  not recognised by the CVS database (you may have been required to enter a logon and password when starting Microsoft Access).  As a work around, simply create a shortcut to the CVS Database that uses the default workgroup file.

As the target for the shortcut, use the following command line

"[path to ] … msaccess.exe" /wrkgrp "[path to ] … \system.mdw” “"[path to ] …[cvsdatabase].mde”

On a Windows 2000 computer, running the Access XP version the shortcut would read:

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp c:\winnt\system32\system.mdw c:\cvs\acc_cvs_vXP_001.mde

If you have any problems regarding this, contact John Emslie

Back to Top

Why does Microsoft Access close down with a system error (or report a table/database corruption) when I try to use the CVS Database?

If the CVS Database has functioned satisfactorily on the computer in the past, the most likely explanation is that a corruption in the file has occurred.  File corruption can have many causes (switching off the PC without closing the database; power surges/failures; running multiple copies of the database; computer memory problems etc.).

In the case of the CVS Database, just download and install a new copy form the ACC CVS web site.

If however, you cannot get the CVS Database to run at all, check the known issues section.  The most like explanation is that you need to install the Microsoft Access Patch files.

Back to Top

Why doesn't the database fill the whole computer screen?

Unfortunately the CVS Database is only configured for a screen resolution of 800x600. 

It would be better if we could show more information on the screen and later versions will probably use 1024 x 768.

Back to Top

Can I run the database from a CD?

No.  You require both read and write permissions in the folder and for the database.  The search routines within the system will not work if you cannot write data to the CVS Database system.

Back to Top

I don't have a copy of Microsoft Access; can I still use the database?

No.  This version requires that you have a copy of Microsoft Access installed.  In England, Microsoft Access is available to all NHS Organisations through the NHS Enterprise Agreement

We hope to make the final version available with a run time version of Microsoft Access and as a web-based system.

Back to Top

Can I print out listings and cases?

 Cases may be printed.  There is no facility to print or export listings.

Back to Top

Can I write my own queries to search the database?

 No.  At present you are restricted the search and find routines included.

Back to Top

Why does the search routine give no results?

There are two possible explanations. 

The database may have become corrupt (just get another copy from the ACC CVS Web site).   Although, the CVS Datbase has been released as an MDE file which should be much harder for a user to corrupt.

Secondly, the database may have been installed to a folder where the user has read only privileges.  Although you will be able to browse cases, you will be able to use the search routine unless you can write information to the database.

Back to Top

Can I install the CVS Database on a network drive?

Yes, although there are no limits on the number of copies of the database you can have, you may find it easier to manage multiple versions if you install a single copy on a network drive.  Please follow the instructions described below.

This version of the CVS Database is NOT designed for multiple users.  It will work on a network drive, but you should ensure that only one user at a time may open and work on the database.  You can do this by creating a shortcut to the database and setting “exclusive mode” with the command line option /excl

For example, the following command line starts Microsoft Access and  opens a CVS Database in the (h:\shared\cvs folder) for exclusive access.

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" h:\shared\cvs\acc_cvs_vXP_001.mde  /excl

(Search Microsoft Access Help for “Start Microsoft Access with command-line options using a shortcut)

If you have any problems setting this up then contact John Emslie.

Back to Top

There isn't enough room to display the full karyotype.  How can I see it?

Use the print case button.  This will give you a preview of the printed case report which will display all the karyotype information.  There is a zoom facility included with the print preview, if you don't want to print the page.

Back to Top

 Why do some cases appear with no karyotype information?

Cases without karyotype information may appear when you use the browse function.  Such cases should not appear through in the search routine.

 The same cases often turn up in multiple publications (case reports; series reports and surveys).  We have tried to minimise these duplicated cases and only to include the most detailed report in the literature survey, a literature case without a karyotype would indicate that the case has been published more than once and that we are in the process of rationalising this information.

 Some laboratory case submissions appear without karyotype information.  These cases are a sub-set collected through the original survey and are not part of the CVS Mosaicism/Abnormality survey.

Back to Top

What happens if details of a submitted case have been published?

It will appear in both the literature and submitted case searches.

Back to Top

When a filter is applied to the case listing, the drop down lists do not match the filtered data.

The drop down lists that give a breakdown of the number of cases in each category (eg  "outcome", "follow up" etc.) are linked to the original selection an not to the current (filtered) selection.  Hence these drop-down lists will always display the same data (that of the original selection).  This allows the user to compare the number of cases in the current (filtered) list with the number in the original selection and facilitates making other selections.

Back to Top

Why is the version number so long (0.000.000)

We hope to use the version number to identify major changes to the system (first number); minor modifications and bug fixes (second number) and data modifications and corrections (third number).

Back to Top

Back to Top

 
 

 

 

Questions or problems regarding this web site should be directed to j.b.emslie@ncl.ac.uk
Last modified: 04-11-2005.