Hi, I have a userform I was populating with data via an ADODB call (sql string) to an Access database which is updated overnight each day. This works fine under some conditions, but what I really need is an ODBC call to a server so I can get dynamic, up to date data coming from the server to the userform. Can anyone assist with the code for this one?
I know I'll have to use Hostname, accountpath, username and password to get this happening but I've only ever done ADODB stuff before so I'm completely in the dark.
Any assistance greatly appreciated.