|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 6th, 2003, 06:14 AM
|
|||
|
|||
|
Interface b/w Access and Caseware (Foxpro)
I have been asked if it's possible to build an interface between a client database in Caseware (an accounting application that uses Foxpro) and Access. Specifically, when a change is made to the Caseware db, it would update the Access db, which is used to manage workflows, send out form letters, etc.
Is this possible? What would it require? Any assistance greatly appreciated! tofocsend
|
|
#2
August 6th, 2003, 09:11 AM
|
||||
|
||||
|
If you have an ODBC driver for FoxPRO you can write an application (or simply an Access macro) that keeps aligned the two dbs.
|
|
#4
August 7th, 2003, 11:44 PM
|
|||
|
|||
|
Use ODBC
If it uses FoxPro, then there will be .dbfs around. If they are and you can noodle out how the data relations work you can use Access to open and read them for reporting puroses. Although if it's Visual FoxPro, I have no idea. Never learned how to use it.
Good luck!
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Interface b/w Access and Caseware (Foxpro) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
