Search results

OK... in which case how do I work it so that my "Photo" field provides a path and then my form collects that image and displays it? If I do that can I then extract my photos from excel to jpgs and ensure that they are still linked to the appropriate primary key? EDIT: Worked out how to get my...

It's late... I mean Excel workbook

Hi! Have tried to find info on this but to no avail. I have currently set up a main db which links to a separate db containing photos of pupils at my school. The photos db is very simple with one table containing the fields [UPN] and [Photo]. The former is primary key, the second an OLE field...

Thanks the second db was a really good workaround. I added the photos table as a linked table in Access (non replicated) the only problem now is that I cannot use any of the queries which access the photo database when away from school - access simply locks them out because it cannot find the...

Hi, have searched extensively but can't seem to find an answer. For a few years I have been running a school marking system which I created in Access 2003. The system worked well as I could keep a master DB on the server in school and let staff go away with a replicated copy. I put in suitable...