Search results for query: *

Just thought I'd follow up and confirm that installing SQL Server Native Client (we used 10) resolved the issue completely. Thanks for all the input and the star. We'll begin testing with Win7 shortly so thanks Bob for that information as well.

Well I found the issue - the user's computer can't use DRIVER=SQL Native Client, but works fine with DRIVER=SQL Server Should I just run with SQL Server as the driver? Kimberly

adding the port number didn't work, but thanks for the idea. I'm wondering if it's another program or another program's settings? It just seems odd to me that both her computers wouldn't work when no one else seems to have an issue. I took one of her computers back to my office and I'm...

Same network. I did have her log onto my computer and another computer and both worked fine. Her security is set up and working fine through SQL - I'm returning the proper table names to link - they just don't link. And everything works ok through the DSN... Thanks! Kimberly

Thanks I'll try these suggestions and get back to you. So far it is only this one user who is having an issue with the module which makes it even the more frustrating in some ways... Kimberly

Forgot to mention, that using the regular Import > ODBC through a DSN works fine on this user's computer. *head desk*

Hi all, I'd appreciate any ideas you have as we're running out and this problem is driving us nutty. I've written a module that uses a DSN-less connection to connect MSAccess to SQL Server. It then automatically links all the tables/views an end user has the security to see. It's pretty...

I think I see now, I have to open the module and enter the password and then I can export it to the other database. Does anyone have suggestions for a simpler way to do what I want?

Hello! Total newbie to this forum so please bare with me as I attempt to make my first post. A little background on my project... I work on a University campus which uses Access. I've written a module that I'd like to distribute to most users on campus - and while I don't want them to be able...