<div>
Hi cwood-wm-com:<br />
<br />
Yes, I have the following sql<br />
<br />
select ..... from tblPtVisit in &quot;I:\test\testdb.accdb&quot;<br />
<br />
and I:\test\testdb.accdb is another MS Access Database.<br />
<br />
Thanks,<br />
<br />
Luchuan
</div>


Hi cwood-wm-com:

Yes, I have the following sql

select ..... from tblPtVisit in "I:\test\testdb.accdb"

and I:\test\testdb.accdb is another MS Access Database.

Thanks,

Luchuan

<div>
Hi cwood-wm-com:<br />
<br />
Good idea, is there a way to have the query call this function?<br />
(It seems the Query tool does not recognize the VBA function, is this true)<br />
<br />
Thanks,<br />
<br />
Luchuan
</div>


Hi cwood-wm-com:

Good idea, is there a way to have the query call this function?
(It seems the Query tool does not recognize the VBA function, is this true)

Thanks,

Luchuan

<div>
Thanks a lot cwood-wm-com.<br />
I finally got time to try your idea, super!<br />
<br />
<br />
Luchuan
</div>


Thanks a lot cwood-wm-com.
I finally got time to try your idea, super!


Luchuan

<div>
You are welcome. I am glad it worked for you. Good luck on your project.
</div>


You are welcome. I am glad it worked for you. Good luck on your project.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have several remote queries based on another Access database on another folder.<br />
Is there a way to pass the path &nbsp;to a remote Query instead of hard code the path?<br />
<br />
Thanks,<br />
Luchuan
</div>
</div>


Hi,

I have several remote queries based on another Access database on another folder.
Is there a way to pass the path  to a remote Query instead of hard code the path?

Thanks,
Luchuan

MS Access 2007 Remote Query - Can we pass in the folder path?

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.