I'd like to create some quires and reports that may help me with some aspects. So, I need to get these questions answered, please:
What is the path of open dental data base? What is it extension?
How can I import the tables of open dental data base to access 2003 or access 2007?
Thanks in advance!
OD DataBase
Re: OD DataBase
The OpenDental Database is installed wherever the user specifies when they install the trial version of OpenDental and select the New Server option. The database is a collection of files and so doesn't have a single extension. I have no experience with Access so I can't help you with that one.
"To understand what recursion is, you must first understand recursion."
David Graffeo
Open Dental Software
http://www.opendental.com
David Graffeo
Open Dental Software
http://www.opendental.com
-
- Posts: 353
- Joined: Mon Feb 25, 2008 3:09 am
Re: OD DataBase
Not a good idea. Access is not robust enough to handle all the tables in OD.
drtmz
drtmz
Re: OD DataBase
David and Tom are correct. You cannot use Access for Opendental. Access is NOT a database management system because its not relational, nor is it supported by OD. However, you can export data from mysql to something like excel if you wanted, but it would just be a snapshot of what was in OD at the time. Your best bets are to either use a mysql query to export the data you need to build a report in another program, or design a mysql query to generate the report you want. http://www.opendental.com/manual/progra ... urces.html has links at the top to our database documentation which will give you an idea of what our tables look like. http://opendentalsoft.com:1942/ODQueryL ... yList.aspx is a list of over 1000 different query examples we've generated over the years, which may be able to suit your purposes or be adapted to do what you want. And finally, you can download the source code of OD and dig through it to see how we generate our internal reports.
The path to the OD database is completely up to the mysql service running on the server, but can be found in the mysql my.ini on the server hosting the database. You can look more into how mysql stores databases online in the mysql documentation, but it depends if the user is using MYISAM or INNODB tables.
The path to the OD database is completely up to the mysql service running on the server, but can be found in the mysql my.ini on the server hosting the database. You can look more into how mysql stores databases online in the mysql documentation, but it depends if the user is using MYISAM or INNODB tables.