access database training - photos privacy

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access database training - Photos privacy

access database training - Photos privacy

resolvedResolved · Low Priority · Version Standard

Jessica has attended:
Access Introduction course

Photos privacy

How can we enter photos on our database, preferably behind a button for privacy?

RE: photos privacy

To store pictures in a database, you would need to use an OLE Object field

(OLE Object data type: A field data type you use for objects created in other applications that can be linked or embedded (inserted) in an Access database.).

You can then embed images into the database and display them where required (forms / reports).

Take a look at the help section of access under "Add a picture or object". That will give you a good background understanding of what is required to add pictures to a database.

If you have any further questions, please post a reply.


 

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips


Server loaded in 0.08 secs.