Welcome, Guest. Please Login.
03/28/24 at 18:08:52
News:
Home Help Search Login


Poll
Question: Do you find Old data missing after several years

yes some orders/lines are lost
no never lost a record
have had dba over 5 years
have had dba under 5 years


« Created by: JAALTD on: 07/31/08 at 13:55:58 »

Pages: 1
Send Topic Print
Old DBA Version, access tables. (Read 1936 times)
PamB
Browser
*




Posts: 21
Old DBA Version, access tables.
04/10/08 at 06:47:57
 
Hello,
 
I am a newbie- my company is using the old version of DBA, and I would like to know anyone could tell me how to access the tables directly, and what file extensions I'm looking for.
 
I need to get a list of non moving inventory, and the canned reports are too long to convert into one page for Excel, so I think accessing the tables would be much quicker.
 
Thank You!
Pam
Back to top
 
 

Pam Bailey
Star Engineering

DBA Classic Version 2004.1 x 10 users
Client/Server
Pervasive Version 8.5
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Old DBA Version, access tables.
Reply #1 - 04/10/08 at 07:22:50
 
We did this directly from Excel with MS Query. If you are familiar with the use of MS Query all you need to know is:  
 
 
A. How do I connect to the DBA data via ODBC?  
 
B. Which file do I need to look in?
 
C. Which fields do I need for my report?
 
 
Question A should be easy for your IT person to answer for you.  
 
Question B and C can be looked up in the (free download) file found here: http://www.istechsupport.com/freedl.php
 
And, as always, when you get stuck we can answer specific questions.
 
NOTE: You could also use Crystal Reports to gather the data, if that is more familiar for you.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
PamB
Browser
*




Posts: 21
Re: Old DBA Version, access tables.
Reply #2 - 04/10/08 at 07:41:36
 
Thank You So Much!!!!!!!!!!!!!!!
 
You're a life saver!!!!!!!!!!!!!!!!!
 
Pam
Back to top
 
 

Pam Bailey
Star Engineering

DBA Classic Version 2004.1 x 10 users
Client/Server
Pervasive Version 8.5
  IP Logged
Pages: 1
Send Topic Print