Re: Speed of SQL Authenication vs. Trusted Connection

From: 2redline@xxxxxxxxx
Date: 27 Apr 2006 07:40:36 -0700

Just wanted to post our findings here to maybe help others. It was an
issue with the Access front-end. Created a new mdb, file, import,
select all, select all, ...... and them re-linked references etc. Now
sql authenication is as fast as trusted connection.

.

References:
- Speed of SQL Authenication vs. Trusted Connection
  - From: 2redline

Prev by Date: Re: Using Windows Authentication to access SQL Server from non-domain
Next by Date: Change Password
Previous by thread: Speed of SQL Authenication vs. Trusted Connection
Next by thread: event ID for windows (trusted) authentication and failed ones as well?
Index(es):
- Date
- Thread

Relevant Pages

Opening multiple mdbs
... use an Access front-end for the code, and an Access back-end for the ... another mdb for a large quantity of temporary data. ... "temp" mdb, but could never create the necessary table. ...
(microsoft.public.access.modulesdaovba)
Re: Multiple MDB files???
... Your advice is absolutely wrong, if you care about the data. ... BTW we have 27 back end mdb files. ... >> I have a databse with an Access front-end on everyone's individual PC ... >> more sense to create multiple back-end data files or if just one would be ...
(microsoft.public.access.tablesdbdesign)
User-defined functions
... I'm a very new learner in SQL Server 2000 now - Can I link to user-defined ... functions for an Access front-end .mdb just as with SQL Server Views? ... that functions are used with Access projects, ...
(microsoft.public.sqlserver.programming)