The main problem with this database Is that It Is not ODBC compatible which Just means that you cannot connect to It and query it directly with other programming languages such as Visual Basic. ODBC which stands for open database connectivity, Is an Industry tankard for connecting to databases. We are planning to move the Veterans compatible. Meanwhile we are now copying Veterans tables to text and then loading them into a Sylvester database in order to be able to do the ad hoc queries that are needed.
Other databases we maintain on Sylvester are the Personnel database which keeps track of employee information which, by the way, is the source for the college directory for C.V. on our Web page and for the picture directory that is published each fall among other things; the Student Services databases which hold al of the information about our students ( personal, student schedules, grades, Web Admissions to the college); the Medical Records database which holds all of the abstract information for procedures and diagnosis pertaining to animal visits.
We also have a Sylvester database which holds all of the archived data from VS. which is the hospital system we had before Veterans. We are using MS Access databases in a variety of ways too. The Medical Records Department uses a record tracking and census database which are Access. The Business Office at the College of Veterinary Medicine, both in the Large and Small Animal Clinics’ has Access databases for keeping track of things related to spending, donations to the college, and budgeting. Access provides a user-friendly interface to work with tables, create reports and forms as well as being the repository for your data.
Many individuals are using Access for their own uses. Access is good for smaller databases and databases that only a few people will access at one time and for a database where you don’t need to worry about who can see or change what ATA. Sylvester is much better for larger databases and cases where many people will access the database at the same time. It is also much simpler to set permissions for various database objects in Sylvester. You can do some of that with Access, but only if you create a special workup for the database (having done this in the past, it is a bit of a nuisance to work with).
When you talk about database access, you may hear people talk about front-ends and back-ends. A back-end is the database where the data actually resides. The front-end is usually a program like Visual Basic, PROW, or even Access which links to the tables in the back-end database and then allows you to use the data. We have a lot of front-end Access programs which link to a back-end Access database or a Sylvester database. Sylvester itself is just a back-end system. It doesn’t provide any real programming tools to create a user friendly interface. I like Sylvester. I like it because it is robust, flexible, easy to maintain and easy to backup.
I use Access a lot as a tool (as opposed to a full blown application) to link to Sylvester databases to manipulate the data and create special reports, etc. This is a characteristic problem with all databases. The Database design is very important. A poorly designed one will cause many problems and duplications of rows when you try to link tables together to find the information you are looking for in a query. So you do need to put a lot of thought into your design. That is the information that I was able to put together after interviewing one of the computer programmer analyst. (It was a long two hours).