MYOB Premier Accounting

[SimonFinn]

Hi Guys

Does anyone know if you can run Insert SQL statements against MYOB through the ODBC Direct driver to insert data into it. I am planning on writing a front end to suit my user’s needs but I am just doing some preliminary testing in Access (I have linked the tables through ODBC), when I run an insert SQL Statement I get the error:

ODBC – Call failed
[ATI][OpenRDA ODBC]dam_verify_query_sup(#0)

I get the same error when I try to insert data manually through the table View. I would usually assume that it cant connect to the data source, but select statements work fine (and the table view opened fine).

If this driver does not support insert statements does anyone know of a driver that does? Or a way to insert data from outside MYOB?

Thanks Si

 

[DeltaTech]

Hi Simon
We do not have the privilege of having MYOB's ODBCDirect, as they claim it is not compatible with the localised version of MYOB. At present we work around it by exporting transcations to a text file and then importing it into MYOB. Works fine, but we would prefer to automate the process to avoid errors caused by importing transactions twice. Let me know if you do hear of a way to do it without ODBCDirect.

 

[egrant]

FYI

You cannot INSERT data into MYOB using just the MYOBODBC Direct driver it is a read-only device.

If you want to INSERT, DROP, ALTER etc INTO MYOB's Data you have to use the MYOB Developer Kit, which I guess gives you full reign to the MYOB System.

I only need to view MYOB's data and then I create tables in access that relate to MYOB's table id's to add extra data for fields that MYOB does not contain.

So the driver is fine for what I need to do. I had to spend hours working on all the relating tables in MYOB. They don't provide that information either unless you buy the Developer Kit. I think it costs around $800 the last time I looked.

Simon...what version of MYOB do you have?

Emma

 

[SimonFinn]

Hi Emma,

I assumed so a while ago, they dont like giving away information - their website is pritty limited.

Like you say it takes a while to work out the related tables. I found the easiest way was to link the tables in access and print out a relationships image and draw them in.

My client is using MYOB Premeir 2003, but i have suspended the plan to develop anything in MYOB for the moment, until my client comes to a decision whether it is for them.

The only route without the developer pack is to import data from delimited text files, which it pritty clumsey as it poses a heavy threat to the integrity of the data.

Cheers Si