Hello, I'm a new user to access and I have a poor knowdledge in scripting with visual basic. After many searches I managed to
find this awesome forum where in the future I could learn a lot of stuff about creating "solid" Access Databases.
Due to the fact I'm in the need of a database of the objects I buy/sell in my shop I started creating my own database with
Access 2007. Unfortunately the templates available with Access 2007 couldn't provide me much help, so I had to build a
database from scratch. I've had a few hard weeks but finally I'm starting to understand many of the things that run an Access
Unfortunately I came up with a problem managing images in my database. As I've figured out, and read amongst various threads
here, embedding images in a database with Access isn't a good thing (Especially if the database needs to hold 1000+ photos).
I searched the forums and found that many users asked already for this but due to my knowdledge with scripting (and the fact
of being still a new user with Access2007) I can't figure out a way to implement un-embed images in my database.
My database is almost finished, I need to polish the masks a bit as well as a few other stuff but I still have to deal with
this problem with images.
I wanted to ask if anyone here was kind enough to provide me some help by converting my "embed image fields" into unembed
I'll explain here how the database manages images:
Table Acquisto keeps records of the object I sell and has an Attachment field called "Immagine". This field stores the embed
The mask called "mask_aggiungi" add new records to the Table Acquisto and has a dedicated box for the Immagine attachment
field. After adding the attachment file, it displays the picture uploaded in the database.
The following masks and reports read and edit the Immagine attachment field:
Basically the work that has to be done is to delete the Immagine attachment field and replace it with a normal text field
(that could still be named Immagine) that will include the Image URL of each record. A script (and here's where I am
absolutely out of knowdledge and need help) reads this new Immagine text field and displays in the Immagine boxes a "preview"
of the image URL I've given to each record.
Also one last thing. In order to implement this it would be good for me to create a folder which would store my image files
and that would always be the same (and never change it's path). Is it possible to only insert the Image name (and extension)
given the fact that the path (and folder) would never change?
filename.jpg (the database already knows the folders where to look after the file by default ex.
Anyone could help me do this? I'm attaching to this post the database I've created.
Thanks a lot in advance,