ODBC/Access issue

From: Jonas Larsen (Jonas.Larsen_at_Alcan.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 16:14:14 +1000

Hi guys

Senario: We have an appplication that uses 1 SQL user that have full access
to the database. At the same time the application requires an ODBC
connection setup for this SQL user on the client PC.

Question:
Is there a way to prevent the user from opening MS Access and connect
directly to the database using the ODBC connection?

Regards
Jonas

Relevant Pages

  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)
  • Re: Ada DB bindings and APQ
    ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
    (comp.lang.ada)
  • Re: Linking Access f/e to Access b/e via ODBC
    ... > Is it possible then to create an ODBC connection to use the ISAM driver ... If I understand your question correctly, the ISAM driver for Jet _is_ what ... you're getting when you create the DSN for an Access database file. ... the ODBC Data Source Administrator can create the DSN to the Access ...
    (microsoft.public.access.externaldata)
  • Re: Trusted Connection
    ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
    (microsoft.public.sqlserver.security)
  • Re: Data Source Lost When Merge From Access to Word
    ... DDE was the default connection method and ODBC was the alternative as far as Access/Jet sources were concerned. ... In Word 2003, OLE DB is the default, but unfortunately when you have selected your database, Word does not display the Access tables that are linked to ODBC data sources. ... create one query in your Access database for each linked table you want to use, with SELECT * FROM, and use that as the data source. ...
    (microsoft.public.word.mailmerge.fields)