D
Dom Torrez
Hello everyone,
It's been requested by my users that they be given the functionality to use
our access application to upload files into the DB.
Currently I'm using MS Access as a front end interface to a back end
postgres DB. What I'd like to do is on a particular form add a text box and
a button labeled
'Find File'. when the users click this button they are taken to a browser
of their local drive, where they can navigate the file system and select a
specific file to upload. they click OK and the path and file name are
inserted into the text box.
for example: C:\MyDocuments\files\myfile.txt
I would like to be able to upload any kind of file (.doc, .pdf, .csv, .xls,
..txt, etc...)
then the user would have to click another button labeled 'Upload' which
would grab the file from the location specified and store it in the DB as a
blob.
As you probably realized this is the same functionality that web pages have
been using for years now. Is this even possible in Access?
Thanks
Dom Torrez
It's been requested by my users that they be given the functionality to use
our access application to upload files into the DB.
Currently I'm using MS Access as a front end interface to a back end
postgres DB. What I'd like to do is on a particular form add a text box and
a button labeled
'Find File'. when the users click this button they are taken to a browser
of their local drive, where they can navigate the file system and select a
specific file to upload. they click OK and the path and file name are
inserted into the text box.
for example: C:\MyDocuments\files\myfile.txt
I would like to be able to upload any kind of file (.doc, .pdf, .csv, .xls,
..txt, etc...)
then the user would have to click another button labeled 'Upload' which
would grab the file from the location specified and store it in the DB as a
blob.
As you probably realized this is the same functionality that web pages have
been using for years now. Is this even possible in Access?
Thanks
Dom Torrez