Search results

I am interested in learning more how you do this. How do you store a connection string in a local table? I thought that connection strings are entirely to do with linking tables to backends. Thanks Ian

I clearly have not explained properly. If you try to link tables to two different strings, all table will only connect to one of those strings (I think the last one to have been connected). Although some tables will appear to connect to the other string, in practice they will not. I might be...

Does not work. It seems that it is not possible to have two different connection strings in linked tables. Access does not use the string that is seen in the linked table's properties. The string must be stored elsewhere in Access. Yet another thing that doesn't work in Access. Ian

Sorry, I should have siad that I know very little vba so I dont quite understand. Can you give be a line or two of code please and say where it goes? Thanks Ian

I have been tearing my hair out with this so I hope that someone can help. I have an Access front end linking to MySQL server tables, via connection string (dsn-less connection). I regularly change the username and password and refresh the connection using this code:- Dim Dbs As Database...

I am struggling with OrderBy and OrderByOnLoad and would appreciate some help. It seems that everytime the user sorts on a column of a query, the sort order is added to OrderBy field property and is saved if the user "Saves Changes" on exiting the query. Next time, the sort order is added to...