Bypass security when linking to SQL Server tables

Tony

Guest

Posts: n/a

3rd Sep 2003

I'm using ODBC and SQL Authentication in Access 97 to link
to SQL Server tables, but it doesn't asked me for ID and
password..even on a brand new Access DB. If I try to do
the same thing on another computer, it prompts me for
login information. Can someone please show me how to fix
this so that it will always ask for login credentials?

Thanks,
Tony

« Re: Access 2000 in Runtime | Supervisor »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Security Problem When Linking Tables	K8Gardner	Microsoft Access Security	1	12th Jan 2009 10:11 PM
Linking Tables from SQL Server	=?Utf-8?B?QnJpYW4=?=	Microsoft Access Database Table Design	1	5th Oct 2007 11:38 PM
Linking SQL Server tables	=?Utf-8?B?Zm9sa2U=?=	Microsoft Access External Data	5	26th Jul 2007 09:00 PM
Prevent Linking to Access Tables with (or without) the Security of a Workgroup	robboll	Microsoft Access Security	2	15th Jun 2007 01:33 PM
Linking Access tables to SQL Server tables with keys in Binary	=?Utf-8?B?QnVzdGVyIEM=?=	Microsoft Access External Data	1	26th May 2005 03:21 AM