Documents and/or pictures in my DB

[Dvorak Pietrek]

Hi

I'm using Access 2007, but my database is in the 2002-2003 format (.mdb), and I want to work with it in this version. The reason is that I created my own menus, and this isn't possible since the 2007 version. I would like some examples in a database so I can customize my database. They are examples of how to insert documents or photos into my database. I'm looking for simple examples because I'm a beginner.

Thanks

 

[June7]

Are you sure you can't use your 2003 custom menus in an accdb? Review https://support.microsoft.com/en-us...f-access-eeea8c31-c2fb-4f36-81a7-7886e168a2c8

It's not clear to me what you are asking for. If you need images of what your db does, then do some screenshots or use Snipping Tool. Or get a screen recorder app.

 

[Dvorak Pietrek]

Utteracccess used to put DB examples, something likee that

 

[Gasman]

Are you sure?, as I have an mdb and still can amend/look at it in 2019?

Crossposted at https://www.accessforums.net/showthread.php?t=91097

 

[Ken Sheridan]

The attached zip archive includes both .accdb and .mdb versions, which illustrate how to browse to a file and return its path as text. The .accdb version stores the path in a column in a table, from which the file can be opened in its associated application. It would not be difficult to amend the .mdb version to do the same. Storing the path to a file rather than embedding the file itself avoids the excessive bloat which the latter can produce when a significant number of files have been added to the database.

 

[Dvorak Pietrek]

The attached zip archive includes both .accdb and .mdb versions, which illustrate how to browse to a file and return its path as text. The .accdb version stores the path in a column in a table, from which the file can be opened in its associated application. It would not be difficult to amend the .mdb version to do the same. Storing the path to a file rather than embedding the file itself avoids the excessive bloat which the latter can produce when a significant number of files have been added to the database.

thanks a lot. That's what i wanted it

 

[GPGeorge]

thanks a lot. That's what i wanted it

Please note that the proposed solution, which is the appropriate choice, is NOT to store the documents and images internally. The appropriate approach is to store them externally, in a shared folder, and only store the path to the image or document in a field in a table in the database.

 

[Dvorak Pietrek]

Please note that the proposed solution, which is the appropriate choice, is NOT to store the documents and images internally. The appropriate approach is to store them externally, in a shared folder, and only store the path to the image or document in a field in a table in the database.

yes, i save to a network. Thanks

 

[Gasman]

yes, i save to a network. Thanks

Back again I see?

 

[gemma-the-husky]

Hi

I'm using Access 2007, but my database is in the 2002-2003 format (.mdb), and I want to work with it in this version. The reason is that I created my own menus, and this isn't possible since the 2007 version. I would like some examples in a database so I can customize my database. They are examples of how to insert documents or photos into my database. I'm looking for simple examples because I'm a beginner.

Thanks

You can create you own menus. Do you mean the switchboard. Just import an A2003 switchboard and switchboard items table. It still works fine. That's what I use. A modified version, but A2003 code.

You don't want to insert objects into a database. Just link to the file and windows/ access will open it as a hyperlink with whatever default program it uses for that file type.

Application.followhyperlink. I forget the precise syntax, but this is closer.