Digital Workshop

Hi Folks
Been working on my first database connection and have got most things working but cant get it to update the records. Also is it possible to pull a photo from access to opus. I have attached a small project.
Mant thx
Paul

Sorry was not allowed to post database db1(ms access) or photo(bmp).

When attaching items to posts it is best to ZIP them first - this decreases the size and is one of the file types allowed to be posted.

It is not possible to read binary data (e.g. pictures) from a database. However it is much simpler to include a field in the database which contains the filename (rather than the file itself) and then reference the files by making a full path using variables - for example, something like:

Thx for the info Duncan. Attached is the zipped version. Hope someone can help.