 | |
MAS90 Visual Integrator question
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
MAS90 Visual Integrator question -
03-23-2011
, 11:18 AM
#2
| |||
| |||
|
|
Anybody working with Visual Integrator? The process I am most interested in is exporting data from Access and importing into MAS90. Can one executed a script to update several tables? Are there certain fields that can be updated, others not? |
MAS90 that can't be updated externally. After all, it is an accounting
system. You are likely going to be limited to areas of Customers and the
like and no Deletes allowed either to maintain concurrency control. The
company I worked with didn't do any of the MAS90 stuff in house. They had
to have a MAS90 tech come to the site to provide the stubs (fields) that
were accessible through the ODBC driver. I don't know what the current
interface is, so my experience might not be helpful..
> Any caveats?
#3
| |||
| |||
|
|
"Salad" <salad (AT) oilandvinegar (DOT) com> wrote in message news:BM-dnTJEzP_GthfQnZ2dnUVZ_jKdnZ2d (AT) earthlink (DOT) com... Anybody working with Visual Integrator? The process I am most interested in is exporting data from Access and importing into MAS90. Can one executed a script to update several tables? Are there certain fields that can be updated, others not? It has been awhile, but there are a considerable number of fields in a MAS90 that can't be updated externally. After all, it is an accounting system. You are likely going to be limited to areas of Customers and the like and no Deletes allowed either to maintain concurrency control. The company I worked with didn't do any of the MAS90 stuff in house. They had to have a MAS90 tech come to the site to provide the stubs (fields) that were accessible through the ODBC driver. I don't know what the current interface is, so my experience might not be helpful.. |
I was doing some modification tests on some junk data. I changed the
zip code from a valid one to 55555. And it kept failing. I then
realized the zip code no longer matched the city and state name and
wouldn't update.
#4
| |||
| |||
|
|
mbyerley wrote: "Salad" <salad (AT) oilandvinegar (DOT) com> wrote in message news:BM-dnTJEzP_GthfQnZ2dnUVZ_jKdnZ2d (AT) earthlink (DOT) com... Anybody working with Visual Integrator? The process I am most interested in is exporting data from Access and importing into MAS90. Can one executed a script to update several tables? Are there certain fields that can be updated, others not? It has been awhile, but there are a considerable number of fields in a MAS90 that can't be updated externally. After all, it is an accounting system. You are likely going to be limited to areas of Customers and the like and no Deletes allowed either to maintain concurrency control. The company I worked with didn't do any of the MAS90 stuff in house. They had to have a MAS90 tech come to the site to provide the stubs (fields) that were accessible through the ODBC driver. I don't know what the current interface is, so my experience might not be helpful.. Thanks for your input. I was doing some modification tests on some junk data. I changed the zip code from a valid one to 55555. And it kept failing. I then realized the zip code no longer matched the city and state name and wouldn't update. |
using their field people's assistance (interference?)
>
#5
| |||
| |||
|
|
"Salad" <salad (AT) oilandvinegar (DOT) com> wrote in message My recollection is that they discourage any access to the MAS90 without using their field people's assistance (interference?) That could be true. That way you don't inadvertantly mess things up. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.