I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel. Searching through the forums here has yielded some possibilities but nothing has worked. Despite making changes to the connection string I still encounter the authentication pop-up. I've set up a 'dummy' ODBC connection and tried a few different syntax sequences but haven't seen success. I'm also looking into how to trigger a login routine in VB but am not having much success on that endeavor.
I'm using Excel as my import for several reasons. One is that the MAS server doesn't seem to let me link tables between modules, which I want to do (the end goal being coordination of inventory purchases based on work orders entered into the system), and in Excel I can show the people using the data where it comes from easily. Another is that the end users are more familiar with Excel than with Access, so giving them a tool to use that doesn't require learning a new system is preferable. A third would be my skill in Access; I'm not a database guy but rather someone who has learned bits and pieces over time from exposure. So don't be surprised if you make a suggestion and I come back with 'how would I go about doing that?'
Thanks in advance for any help you can provide.
