January 12, 2016 at 8:12 am
I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.
So I need to figure out how the access db connects to SQL in order to be able to move the db & change the connection. I've clicked around the access db in question for hours but can't find where an odbc or connect string is stored. Any pointers gratefully accepted!!
January 12, 2016 at 11:10 am
snomadj (1/12/2016)
I don't know access but I have an access db that somehow interfaces with an old SQL database I need to move.So I need to figure out how the access db connects to SQL in order to be able to move the db & change the connection. I've clicked around the access db in question for hours but can't find where an odbc or connect string is stored. Any pointers gratefully accepted!!
Which version of Access and SQL Server? Normally this would be an ODBC connection
January 12, 2016 at 3:10 pm
Try "External Data -> Linked Table Manager".
January 12, 2016 at 10:39 pm
Check out the following link may be this will help you to out: http://www.brighthub.com/computing/windows-platform/articles/25996.aspx
January 13, 2016 at 4:53 am
Thanks all, appreciate your replies!
I was quite lost. I could see incoming calls to SQL from host A supposedly via the access db. However, having spent hours on it, I found an additional mde file that had linked tables connecting via a dsn.
I'm hoping I only need to amend the dsn. I will find out!
Thank you all.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy