Re: .udl file?

Pretty slick. I just implemented this on a small test mdb using the first
Addendum since most of our mdb's aren't on the same domain and that sql
logins is more convenient. But just a quick question is that is there a way
to avoid the "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." warning popup? I notice after clicking the
OK button and then seeing the "SQL Server Login" prompt, the "Use Trusted
Connection" checkbox is checked on which would explain why the initial
warning/error popup displays so would there be a way to have this unchecked
so it would be less startling for the end user in just go straight to the
"SQL Server Login" popup prompt?

Thanks Douglas.


"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:e1hJNeJKIHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
Why not go DSN-less? I show one way at
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:%23aSeJrIKIHA.4688@xxxxxxxxxxxxxxxxxxxxxxx
Hello. Is there a way or possible to create a link table in MS Access
using a .udl file as the data source? Just wondering a way to have like
an easily accessible connection file on our internal network for MS
Access to use in avoiding to have to set up an odbc connection on all of
the users machines. I tried playing with creating a file dsn but seems
there are issues with this and doesn't work too well.

Thanks in advance.





.