Troubleshooting
Importing Hyperlinks into Access
| Q1: | I imported a list filled with hyperlinks into an Access table, but none of my hyperlinks work properly. What happened? |
| A1: | When you create a table by importing data, Access automatically recognizes a column that contains URLs or UNC-style file addresses and uses the Hyperlink data type for that column. However, this conversion takes place only if all the values start with a recognized prefix, such as http: or \\. If even one value doesn't follow this format, Access refuses to convert the column into a Hyperlink field. Switch to Design view and change the data type for the field to Hyperlink; after you save this change, all your hyperlinks will work properly. |
Juggling Multiple Relationships
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
