Re: [MS_AccessPros] query in different db

 

Luigi-

What is in DatabasePath?  If it's just what is inside the single quotes, I suspect you need to do:

strSQL11 = "Select QueryName From QueryName IN '" & DatabsePath & "'"

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Jun 22, 2014, at 8:10 AM, bondurri.luigi <no_reply@yahoogroups.com> wrote:

Hi,

I' m calling here a query in a different db. It is working, but if i write a string instead the path, the code not working.

Did u have the same problem ?

Thanks

srtSQL11 = "INSERT INTO [CRM_02_new] SELECT [2_nuovi].* FROM [2_nuovi] IN 'F:\_SharingCloudSection\Dropbox\ProdottiGianni_Ricerca\PGRicerca_Agenzie\_Standard\Statistiche\Dati##Agenzie.mdb'"

Select QueryName From QueryName IN Databasepath

Ciao

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___