Connecting to SQL from Access

From: "dew" <dew@xxxxxxxxx>
Date: Thu, 26 Jan 2006 11:17:02 -0700

I have users who currently query a SQL database using Access and an odbc
connection. The database is being moved to a less secure server, and we are
looking for the best way for users to connect to this database so they can
do their own queries. They like Access because they can select the tables
and don't have to remember t-sql code, and I wouldn't want to give them sql
query anaylizer anyway. What would be the best way to do this? Eventually
we will be creating programs for them to access their data, but that could
be a long time in coming, and there are always queries we cannot anticipate
and therefore cannot provide an application for.

Thanks. Any ideas are appreciated.

.

Follow-Ups:
- Re: Connecting to SQL from Access
  - From: shanghai360
- Re: Connecting to SQL from Access
  - From: scott.seely@xxxxxxxxxx

Prev by Date: Re: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
Next by Date: Re: Denial of Service: BINARY_CHECKSUM of TEXT column hangs CPU: SQL 2K SP4
Previous by thread: restricting access to databases in SQL Server Management Studio
Next by thread: Re: Connecting to SQL from Access
Index(es):
- Date
- Thread

Relevant Pages

Re: access 2003
... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
(microsoft.public.access.conversion)
Re: access 2003
... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
(microsoft.public.access.conversion)
Re: merge multiple databases
... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
(microsoft.public.vb.database.dao)
Re: merge multiple databases
... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
(microsoft.public.vb.general.discussion)
Re: merge multiple databases
... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
(microsoft.public.access.queries)