Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-07-2014, 10:12 AM   #1
reign99
Newly Registered User
 
Join Date: Jan 2014
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
reign99 is on a distinguished road
Linked Tables - SQL server login popup

Hey, I'm still using Access 2003 (if it ain't broke, don't fix it!) and am looking to push toward the latest version.

The problem I'm having is that every time the application is started, and a linked table is accessed (to SQL server using ODBC), it pops up the "SQL Server Login" box.

It uses a trusted connection, so you just have to hit OK, but the problem is you have to do it each time the app is started for the first interaction with EVERY linked table. That's a lot of annoying clicking.

How can I stop this? In 2003, and 2007 I believe as well if I remember correctly, this wasn't an issue.

Anyone have a work around for this?

reign99 is offline   Reply With Quote
Old 01-07-2014, 10:17 AM   #2
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,625
Thanks: 114
Thanked 296 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Linked Tables - SQL server login popup

Give this solution a try...

Linked Table Saved Password ADOX code
http://www.access-programmers.co.uk/...68#post1155700
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
The Following User Says Thank You to mdlueck For This Useful Post:
reign99 (01-07-2014)
Old 01-07-2014, 10:31 AM   #3
reign99
Newly Registered User
 
Join Date: Jan 2014
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
reign99 is on a distinguished road
Re: Linked Tables - SQL server login popup

Thanks for the quick reply, I will check this out.

From reading through the function, it looks like it is essentially just recreating the link string to the tables. So essentially, if I delete all the linked tables and recreate them I should eliminate this issue?

If so that would be great, I will try that in a copy of the front end and see how it turns out. Thanks again!

reign99 is offline   Reply With Quote
Old 01-07-2014, 10:36 AM   #4
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,625
Thanks: 114
Thanked 296 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Linked Tables - SQL server login popup

No, do not delete. Just call that code in your application start-up to update the connection strings of the DAO Linked Table objects.

I repete, DO NOT delete the DAO Linked Table objects... merely edit the connection string contained within them.
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
Old 01-07-2014, 11:03 AM   #5
reign99
Newly Registered User
 
Join Date: Jan 2014
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
reign99 is on a distinguished road
Re: Linked Tables - SQL server login popup

Quote:
Originally Posted by mdlueck View Post
No, do not delete. Just call that code in your application start-up to update the connection strings of the DAO Linked Table objects.

I repete, DO NOT delete the DAO Linked Table objects... merely edit the connection string contained within them.

Got it, thanks!

reign99 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access linked SQL tables. How can I auto-login with VBA? hardrock SQL Server 1 10-01-2009 06:50 AM
Toggle linked tables between Live and training during login DCrake Sample Databases 0 04-22-2009 12:57 AM
MDB linked to SQL Server tables w/MDW security EPD Hater General 2 01-13-2008 08:47 AM
Auto Login Linked Tables doco General 2 11-21-2007 06:52 AM
Linked tables to a database on a web server Phonik General 1 09-10-2007 07:19 AM




All times are GMT -8. The time now is 06:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World