I have a SQL database running on my hosted web space. Does anyone know if it's possible to link the SQL tables from the web DB into a locally run MS Access database? If yes what syntax do you use for the server name when creating the ODBC connection?
Up until now I've been exporting the SQL data, and then importing to the Access DB. It'd be far easier if I could directly feed the MS Access database from the SQL one, thus the query. Thanks.
Up until now I've been exporting the SQL data, and then importing to the Access DB. It'd be far easier if I could directly feed the MS Access database from the SQL one, thus the query. Thanks.
