aricon
Active Member
   

Systems Consulting-See website for products!
Posts: 1283
Gender:
|
You are right about Access with a few of the tables as Phil wrote his OWN DDF's and they weren't necessarily all industry standard, and Access can be quite picky. That said, it does depend on the Access version as well it seems. We have tried with 97 and there were MANY files that would not import or link. With 2000 that dropped considerably to a few, and with 2002 that eliminated a couple more. We have found that SQL pass-through queries can get us through quite a few problems, and Active-X accomplishes just about all the rest. But you need the Pervasive developers kit for the Active-X connections. I had created some CRW reports for a client (new Balance Sheet, P&L, and aging reports - All divisionalized), but after a while they found them just too slow. We have re-done that in Access and they run VERY fast (almost instantaneous update from DBA), and they are very happy with this. Now we are trying to work on a new Access-based Job Costing system and are having major troubles with WOROUT. Ahhhhh, trials and tribulations......
|