I have an Access 2010 database in which I need to change the attribute from text to attachment of a Field (PHOTO) which contains the location of photos, Access will not let me do it as it is a linked table. In the Excel's database from which the table was linked, how do I change the PHOTO field's attribute from the text to attachment?
You need to change it in the "other" database, you can't amend the table structure of linked tables in the receiving database it must be done in the master one.
Last edited by pjwhitfield; 12-21-2014 at 03:53 AM.
If someone has helped you then please add to their Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks