Is this a bug in Access?

[Guest]

Hi

I just wanted to know if anyone else has come across the following in Access
when refreshing tables.

I've created a code to refresh the links on the tables in my database using
a file dsn.

When creating a dsn for SQL Server, if I use the Windows Authentication the
code refreshes the links fine.

But if I use an SQL Server username and password instead, a login box
appears asking for your login details, which is fine as it will obviously ask
for this once.
But then when you try and view the contents of your table, the login box
keeps refreshing and doesn't go away, then when you view the table behind
this login box it returns all of your data as #NAME.

Has anyone experienced this before?

The reason I ask is because I wanted to get this to work for refreshing
table links for Oracle, but for me to connect to the server I need to login
using a username and password and when I tried it I got the above problem.

 

[Van T. Dinh]

You can save the UserName + password in the DSN settings.

Personally, I use almost exclusively Windows authentication so that the
users only have to log on (to the Windows network) and they automatically
get access to the SQL Server if permitted.