<div>
<div class="content wysiwyg-content">
So I have a database where a component is storing the path for documents on a network. &nbsp;I don't want to use the attachment feature because it makes the database incompatible with 2003 and makes the database size much larger. <br />
Instead, I'd like to have a command button where the user will use explorer to define the path and then save this path in a field 'FilePath' The FilePath will then be able to be opened at a later time.<br />
Could anyone show me an example of how to use this feature in Access?<br />
<br />
Thank you,<br />
Bevo
</div>
</div>


So I have a database where a component is storing the path for documents on a network.  I don't want to use the attachment feature because it makes the database incompatible with 2003 and makes the database size much larger. 
Instead, I'd like to have a command button where the user will use explorer to define the path and then save this path in a field 'FilePath' The FilePath will then be able to be opened at a later time.
Could anyone show me an example of how to use this feature in Access?

Thank you,
Bevo

Use a 'browse for file' dialogue box to save a filepath for later use to open in shell

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.