Connecting to MS SQL Server

[Tige Brown]

I have created an access database which includes a number of links to tables
in two separate sql server databases. The created tool works well however I
am planning to roll the application, or other similar applications, out to
other users within my organisation. When linking the tables to the access
database I have used the ODBC connections on my machine which cannot be
accessed by users without the same ODBC connections set-up on their PC.

Could anyone suggest a way to link to these tables without having to setup
ODBC connections on the individual PC's

Thanks in advance.

 

[gllincoln]

Hi Tige,

Create full connections strings and as long as the users have the required
permission to make the connection, it will work without regard for which PC
the application is running on.

The reference site I continually go back to when I am setting up some
connection strings is http://www.connectionstrings.com/ - I recommend adding
the site to your favorites because you will find yourself going back for a
quick 'refresher' from time to time.

One way to handle links that I use on large scope distributed apps with many
linked tables and multiple roles to deal with is to create a table of the
required links (and also list and combo box value lists) When my application
starts, I kill off any linked in tables, then the application hooks into
this table and peels through the list of required links and sets them up.
All recorded user data goes to the linked in tables, only static
information, forms, reports go into the client side application.

Hope this helps,
Gordon