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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply