May 24 2012, 08:48 PM
I have recently migrated my access 2007 database to SQL server 2008 R2 backend and my hyperlinks in access are not working. Please help.
May 24 2012, 09:27 PM
Any Access + Sql Server experts? Really need help on this topic.
May 24 2012, 09:55 PM
What do you mean by "hyperlinks in access"? Do you mean links to linked tables in SQL Server?
Have you downloaded and installed the Microsoft® SQL Server® 2008 R2 Native Client Drivers required? The downloads can be found on The Microsoft SQL Server 2008 R2 Feature Pack download page about half way down the page under "Microsoft® SQL Server® 2008 R2 Native Client". http://www.microsoft.com/en-us/download/de...s.aspx?id=16978
May 24 2012, 10:17 PM
Did your Access tables have hyperlink fields in them? Is that what you mean? If so, how were they defined in the SQL Server database?
You may have to implement the values stored in your "hyperlink" field in the SQL Server tble as "hyperlinks" in code in the Access db when you need to use them.
May 24 2012, 11:22 PM
SQL Server has no datatype that corresponds to a hyperlink. I would assume the URL is stored as text (VARCHAR) in SQL Server, and that you could format it as a hyperlink in Access, and it would work.
Okay... just tried it and got the same thing you did. The way I made it work was to format the textbox in the Access form as a Hyperlink. (It's a VARCHAR(100) field in SQL Server, but that's data type info...). I had to include this code in my PhotoHyperlink textbox control to get it to work...
Private Sub PhotoHyperlink_Click()
May 28 2012, 08:34 PM
Thank you everyone for your replies. Really got busy and couldn't reply in the post. Like MadPiet said, there is no equivalent datatype of Hyperlink in SQL Server. I will try as you suggested MadPiet, hope it works for me. I am new to access and this thing is giving me real trouble.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here