Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
has anyone used access as a front end with myob as backend
Are you copying the data across the network? If so, try doing it locally and see if there is any improvement. Is anyone using MYOB whilst you are doing the query? Try doing it with noone logged in. Which tables are you using? Perhaps there are smaller tables with the required data? Rael...- raeldush
- Post #16
- Forum: Microsoft: Access Other topics
-
has anyone used access as a front end with myob as backend
EMC, Instead of running the queries directly off the MYOB database, try copying the relevant tables into MS Access and then running queries off these tables. Performance should improve dramatically. If the improvement is suitable, you can then look at ways of automating the MYOB table import...- raeldush
- Post #14
- Forum: Microsoft: Access Other topics
-
has anyone used access as a front end with myob as backend
bumskis, I have a copy of the book with me and it DOES NOT include the odbc driver. The book was quite contentious in Australia when it was released because it contained a number of tools that people had already paid good money for, but I can assure you that it definitely did not contain a...- raeldush
- Post #12
- Forum: Microsoft: Access Other topics
-
has anyone used access as a front end with myob as backend
EMG and others, I am very interested in this thread as I a developer who works specifically with MYOB. I am also an MYOB Certified Consultant. From what I understand, the ODBC driver was released as an extension of the MYOB product. That is, it allows you to get more out of the product. Let's...- raeldush
- Post #10
- Forum: Microsoft: Access Other topics
