Connect Access UI to SQL DB
Posted on 2014-04-17
When I connect an Access UI to a SQL DB, I usually first create a DSN on each workstation through Control Panel, then connecting Access to the DSN?
Is it possible not to use a DSN, but maybe store all credentials on a local Access table, like server IP, Database, User & Password?
If this is possible, then how, and will I be able to see the SQL tables, their contents, and bind to them as I normally would in Access?