i want to ask how or what can i use to stor a document files on the db ,i
know how to store files in access db or oracle can you
help me please
Get free email and a permanent address at http://www.netaddress.com/?N=3D
You don't actually store the file in the database, but simply store a
pointer to it. This pointer would normally contain the full path and
filename (with extention).
I have found the easiest way to then access the file(s) is by creating a
command button on the form (or menu bar) that collects the path (DocPth),
determines the correct program to use, and path (AppPth) to open it with,
and then joins the pair into a single string using ::
PATH = """" + AppPth + """" + " " + """" + DocPth + """"
then call the application to open the document with::
Shell PATH, vbNormalFocus
Hope this helps.