Bls: [SOLVED]: [MS_AccessPros] Re: vba to make Pass through Queries (with no DSN)

 

Well, what I didn't see is that you are opening the query to show the records without a form otherwise I meant:

Private Sub Command1_Click()
Dim strSql As String
Dim qdfPassThrough As DAO.QueryDef, MyDB As Database
Dim strConnect As String

Set MyDB = CurrentDb()

Set qdfPassThrough = MyDB.CreateQueryDef("")

strConnect = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=CobaLink;User=root;Password=123456;"

strSql = "SELECT categories.CategoryID, categories.CategoryName, categories.Description FROM categories;"

qdfPassThrough.Connect = "ODBC;" & strConnect
qdfPassThrough.SQL = strSql
qdfPassThrough.ReturnsRecords = True

Application.RefreshDatabaseWindow

DoCmd.SetWarnings False
DoCmd.OpenForm "frmQuery_DSN_Less", acViewNormal, acReadOnly
set frmQuery_DSN_Less.Recordset = qdfPassThrough.OpenRecordSet(dbOpenSnapshot)
qdfPassThrough.Close
DoCmd.SetWarnings True

End Sub

Caveat: I am dry coding this and it assumes you create a form "frmQuery_DSN_Less" containing the fields CategoryID, CategoryName, Description.

--- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@...> wrote:
>
> Thanks Andrew,...
>
> I've tried your tip, in my case i wrote an additional line in the end of code, (before end sub)...completly like bellow :
>
>
> Private Sub Command1_Click()
> Dim strSql As String
> Dim qdfPassThrough As DAO.QueryDef, MyDB As Database
> Dim strConnect As String
> Dim Query_DSN_Less As QueryDefs
>
> If Not IsNull(CurrentDb.QueryDefs("Query_DSN_Less").SQL) Then
> CurrentDb.QueryDefs.Delete "Query_DSN_Less"
> End If
>
> Set MyDB = CurrentDb()
>
> Set qdfPassThrough = MyDB.CreateQueryDef("Query_DSN_Less")
>
> strConnect = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=CobaLink;User=root;Password=123456;"
>
> strSql = "SELECT categories.CategoryID, categories.CategoryName, categories.Description " & vbCrLf & _
>          "FROM categories;"
>
> qdfPassThrough.Connect = "ODBC;" & strConnect
> qdfPassThrough.SQL = strSql
> qdfPassThrough.ReturnsRecords = True
> qdfPassThrough.Close
>
> Application.RefreshDatabaseWindow
>
> DoCmd.SetWarnings False
> DoCmd.OpenQuery "Query_DSN_Less", acViewNormal, acReadOnly
> DoCmd.SetWarnings True
>
> Set qdfPassThrough = MyDB.CreateQueryDef("")
>
> End Sub
>
>
> but after i quit the app and opened it again the Query_DSN_Less is still exist, from your explanation it should be deleted (i think)...
> am i missing something...please give more suggestions...
>
> Regards
> hendra
>
>
>
> ________________________________
> Dari: acravenrohm <yahoo@...>
> Kepada: MS_Access_Professionals@yahoogroups.com
> Dikirim: Senin, 6 Agustus 2012 4:47
> Judul: [SOLVED]: [MS_AccessPros] Re: vba to make Pass through Queries (with no DSN)
>
>
>  
> Hendra,
>
> if you don't give the Querydef a name, it will be treated as temporary and deleted automatically when it is closed.
>
> Set qry = CurrentDb.CreateQueryDef("")
>
> Note that. in Access 2000, replacing the empty string with vbNullString (which should have been identical) did not work but I haven't tried it in 2007+ Versions so it might be fixed.
>
> I would have expected you to need to use the dbQSQLPassThrough to define the QueryDefType but if it works for you without it, great.
>
> DSN-less works in every casde I have ever found and it allows me to convert the DAO Connect string to an ADO version for the few times I need it.
>
> Andrew
>
> --- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@> wrote:
> >
> > Yeeesssss !!!....It works...it works.... sorry i really excited.... :D
> > Thanx Duane for correcting the code....here my completly code, :
> >
> > Private Sub Command1_Click()
> > Dim strSQL As String
> > Dim qdfPassThrough As DAO.QueryDef, MyDB As Database
> > Dim strConnect As String
> > Dim qrySQLPass As QueryDefs
> >
> > If Not IsNull(CurrentDb.QueryDefs("qrySQLPass").SQL) Then
> > CurrentDb.QueryDefs.Delete "qrySQLPass"
> > End If
> >
> > Set MyDB = CurrentDb()
> >
> > Set qdfPassThrough = MyDB.CreateQueryDef("qrySQLPass")
> >
> > strConnect = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=CobaLink;User=root;Password=123456;"
> > strSQL = "SELECT categories.CategoryID, categories.CategoryName, categories.Description " & vbCrLf & _
> >                "FROM categories;"
> >
> > qdfPassThrough.Connect = "ODBC;" & strConnect
> > qdfPassThrough.SQL = strSQL
> > qdfPassThrough.ReturnsRecords = True
> > qdfPassThrough.Close
> >
> > Application.RefreshDatabaseWindow
> >
> > DoCmd.OpenQuery "qrySQLPass", acViewNormal, acReadOnly
> >
> > End Sub
> >
> > Why i really excited because i can use that PTQ for Make Table Query source and make other query based on the local tabel that have made,
> >
> > and  i can delete all of the query on quit event from the application, it's more safe i think...
> > Once again thank you Duane , thank you Bill ....
> >
> > Best Regards
> > Hendra
> >
> >
> >
> > ________________________________
> > Dari: Bill Mosca <wrmosca@>
> > Kepada: MS_Access_Professionals@yahoogroups.com
> > Dikirim: Minggu, 5 Agustus 2012 9:47
> > Judul: RE: Bls: Bls: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through Queries (with no DSN)
> >
> >
> >  
> > Guys
> >
> > I would bet dollars to doughnuts that you still have to create a DSN file for a
> > pass-through unless you use the ADO code I posted. The DSN file is embedded into
> > the connect string so you do not see it. Try doing a pass-through in a new db
> > and I bet you get a prompt for a DSN.
> >
> > I could be wrong but I don’t think so.
> >
> > Regards,
> >
> > Bill
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
> > Sent: Saturday, August 04, 2012 7:35 PM
> > To: Access Professionals Yahoo Group
> > Subject: RE: Bls: Bls: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through
> > Queries (with no DSN)
> >
> > It looks like you have the first { out of place. What happens if you try:
> > strConnect = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=CobaLink;
> > USER=root;PASSWORD=123456;"
> > qdfPassThrough.Connect = "ODBC;" & strConnect
> >
> > Duane Hookom
> > MS Access MVP
> >
> > > To: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > From: agesthahendra@ <mailto:agesthahendra%40ymail.com>
> > > Date: Sun, 5 Aug 2012 07:39:41 +0800
> > > Subject: Bls: Bls: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through
> > Queries (with no DSN)
> > >
> > > Thank you Duane,
> > >
> > > Here is my code i posted again :
> > >
> > > strConnect = "{DRIVER=MySQL ODBC 5.1
> > Driver};SERVER=localhost;DATABASE=CobaLink;USER=root;PASSWORD=123456;"
> > > qdfPassThrough.Connect = "ODBC;" & strConnect
> > >
> > >
> > > i've to changed the server name to my computer name, changed the other user
> > name with it's password...but still doesn't work...
> > >
> > >
> > > Regards
> > > Hendra
> > >
> > >
> > > ________________________________
> > > Dari: Duane Hookom <duanehookom@ <mailto:duanehookom%40hotmail.com>
> > >
> > > Kepada: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.
> > com <mailto:ms_access_professionals%40yahoogroups.com> >
> > > Dikirim: Minggu, 5 Agustus 2012 6:29
> > > Judul: RE: Bls: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > >
> > >
> > >
> > > Hendra,
> > > Could you please provide the connection string you used?
> > > I just created one using NT authentication with:
> > > ODBC;Driver={SQL Native Client};Server=MyServerNameHere;Database=MyDBNameHere;
> > Trusted_Connection=yes;
> > >
> > > Duane Hookom
> > > MS Access MVP
> > >
> > >
> > > > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%
> > 40yahoogroups.com>
> > > > From: agesthahendra@ <mailto:agesthahendra%40ymail.com>
> > > > Date: Sun, 5 Aug 2012 05:24:21 +0800
> > > > Subject: Bls: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > >
> > > > Thank you Duane,...still doesn't work, DSN is asked,...maybe better if i
> > looking for other way
> > > >
> > > > Regards
> > > > Hendra
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > Dari: Duane Hookom <duanehookom@
> > <mailto:duanehookom%40hotmail.com> >
> > > > Kepada: Access Professionals Yahoo Group
> > <ms_access_professionals@yahoogroups.com
> > <mailto:ms_access_professionals%40yahoogroups.com> >
> > > > Dikirim: Minggu, 5 Agustus 2012 3:48
> > > > Judul: RE: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > >
> > > >
> > > >
> > > > There are sample connection strings (including DSN-less) at:
> > > > http://www.carlprothman.net/Default.aspx?tabid=81
> > > > You can also try:
> > > > http://www.connectionstrings.com/
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > > ----------------------------------------
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > From: agesthahendra@ <mailto:agesthahendra%40ymail.com>
> > > > > Date: Sat, 4 Aug 2012 21:10:47 +0800
> > > > > Subject: Bls: Bls: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > > >
> > > > > Thank you Duane,...
> > > > >
> > > > > Would you give me an example what exactly you change in design view..?
> > > > > for example i have a simple query with ODBC Connect Str on Query
> > Properties = ODBC;DSN=Northwind;,
> > > > > Which part i have to change so the DSN is not needed like you said ? and
> > change to what..?
> > > > >
> > > > > Regards
> > > > > Hendra
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > Dari: Duane Hookom <duanehookom@ <mailto:duanehookom%40hotmail.
> > com> >
> > > > > Kepada: Access Professionals Yahoo Group
> > <ms_access_professionals@yahoogroups.com
> > <mailto:ms_access_professionals%40yahoogroups.com> >
> > > > > Dikirim: Sabtu, 4 Agustus 2012 19:51
> > > > > Judul: RE: Bls: [MS_AccessPros] Re: vba to make Pass through Queries (with
> > no DSN)
> > > > >
> > > > > I typically make a p-t query using a DSN. Then I go into the design and
> > change the connection string so the DSN is not needed. Duane HookomMS Access MVP
> >
> > > > > > To: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > From: agesthahendra@ <mailto:agesthahendra%40ymail.com>
> > > > > > Date: Sat, 4 Aug 2012 14:45:18 +0800
> > > > > > Subject: Bls: [MS_AccessPros] Re: vba to make Pass through Queries (with
> > no DSN)
> > > > > >
> > > > > > Bill,..
> > > > > >
> > > > > > Based on your codes that you had gave, how do to make the recordset that
> > retrieved from the codes into a local table..?
> > > > > > Why i want to use PTQ is then i can make it to be a source of an Make
> > Table Query, so i can make others query based on that local table.
> > > > > >
> > > > > > Regards
> > > > > > Hendra
> > > > > >
> > > > > >
> > > > > >
> > > > > > ________________________________
> > > > > > Dari: Bill Mosca <wrmosca@ <mailto:wrmosca%40comcast.net> >
> > > > > > Kepada: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > Dikirim: Sabtu, 4 Agustus 2012 10:22
> > > > > > Judul: Bls: [MS_AccessPros] Re: vba to make Pass through Queries (with
> > no DSN)
> > > > > >
> > > > > >
> > > > > >
> > > > > > Hendra
> > > > > >
> > > > > > So, it is as I predicted. You need to use a DSN file. The code I gave
> > you does not require a DSN. Hence, you are opening a DSN-less connection.
> > > > > >
> > > > > > Forget pass-through queries. They are not the answer to security.
> > > > > >
> > > > > > Bill
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , Agestha Hendra
> > <agesthahendra@> wrote:
> > > > > > >
> > > > > > > Bill,..
> > > > > > >
> > > > > > > Yes i had tried them....and....they both didn't work,...
> > > > > > > the process asked a DSN to continue,... :(
> > > > > > > Thank you Bill,...
> > > > > > >
> > > > > > > Regards
> > > > > > > Hendra
> > > > > > >
> > > > > > >
> > > > > > > ________________________________
> > > > > > > Dari: Bill Mosca <wrmosca@>
> > > > > > > Kepada: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > Dikirim: Sabtu, 4 Agustus 2012 3:23
> > > > > > > Judul: Bls: [MS_AccessPros] Re: vba to make Pass through Queries (with
> > no DSN)
> > > > > > >
> > > > > > >
> > > > > > > ツ
> > > > > > > Hendra
> > > > > > >
> > > > > > > Why don't you give it a try and see if you can create a new query
> > using the methods at those links?
> > > > > > >
> > > > > > > Let us know what happens.
> > > > > > >
> > > > > > > Bill
> > > > > > >
> > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , Agestha Hendra
> > <agesthahendra@> wrote:
> > > > > > > >
> > > > > > > > Thanx a lot Bill,...
> > > > > > > >
> > > > > > > > I was trying to search about DSN_Less PTQ too..., i found some :
> > > > > > > >
> > > > > > > >
> > http://www.dbforums.com/microsoft-access/1006185-writing-pass-through-queries-vb
> > a.html
> > > > > > > >
> > > > > > > > and
> > > > > > > >
> > > > > > > >
> > http://stackoverflow.com/questions/10744170/how-do-i-create-a-passthrough-query-
> > in-access-using-a-dsn-less-connection
> > > > > > > >
> > > > > > > > i have not tried it yet, how do you think about thoose links
> > about...?
> > > > > > > >
> > > > > > > > Regards
> > > > > > > > Hendra
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > ________________________________
> > > > > > > > Dari: Bill Mosca <wrmosca@>
> > > > > > > > Kepada: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > > Dikirim: Sabtu, 4 Agustus 2012 0:56
> > > > > > > > Judul: Bls: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > > > > > >
> > > > > > > >
> > > > > > > > テつ
> > > > > > > > Hendra - Important!!!
> > > > > > > >
> > > > > > > > Be sure to set the cnn.ConnectionTimeout = 60
> > > > > > > >
> > > > > > > > Otherwise, if your code has a syntax error or you misspell either
> > the SQL Server instance or database Access will just freeze up.
> > > > > > > >
> > > > > > > > Bill
> > > > > > > >
> > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
> > wrote:
> > > > > > > > >
> > > > > > > > > Hendra
> > > > > > > > >
> > > > > > > > > I used a windows authentication DSN. That's why there is no
> > password or user ID.
> > > > > > > > >
> > > > > > > > > By the way, After spending about 30 minutes searching for a way to
> > create a DSN-less passthrough I've come to the conclusion that it is impossible.
> > Access has to use ODBC. That requires a DSN even if you don't see it in the
> > query's connection string.
> > > > > > > > >
> > > > > > > > > On the other hand, you can open a recordset using ADO and that can
> > be DSN-less.
> > > > > > > > >
> > > > > > > > > Typical code:
> > > > > > > > >
> > > > > > > > > Option Compare Database
> > > > > > > > > Option Explicit
> > > > > > > > > Private cnn As ADODB.Connection
> > > > > > > > > Private rs As ADODB.Recordset
> > > > > > > > >
> > > > > > > > > Private Sub Form_Open(Cancel As Integer)
> > > > > > > > > Dim strSQL As String
> > > > > > > > > Dim strMSG As String
> > > > > > > > >
> > > > > > > > > On Error GoTo err_PROC
> > > > > > > > >
> > > > > > > > > Set cnn = New ADODB.Connection
> > > > > > > > > cnn.ConnectionString = "Provider=sqloledb;Data
> > Source=MySQLInstance;" _
> > > > > > > > > & "Initial Catalog=MyDatabase;User Id=zzz_test;Password=dirtydog1"
> >
> > > > > > > > > cnn.ConnectionTimeout = 0
> > > > > > > > > cnn.Open
> > > > > > > > >
> > > > > > > > > strSQL = "SELECT * FROM ErrorLog"
> > > > > > > > >
> > > > > > > > > Set rs = New ADODB.Recordset
> > > > > > > > > rs.Open strSQL, cnn, adOpenKeyset, adLockOptimistic
> > > > > > > > >
> > > > > > > > > Set Me.Recordset = rs
> > > > > > > > >
> > > > > > > > > exit_PROC:
> > > > > > > > > On Error Resume Next
> > > > > > > > > Exit Sub
> > > > > > > > >
> > > > > > > > > err_PROC:
> > > > > > > > > Dim strErrMsg As String
> > > > > > > > > Dim lngIcon As Long
> > > > > > > > >
> > > > > > > > > strErrMsg = "Error " & Err.Number & " (" & Err.Description & ") "
> > _
> > > > > > > > > & "occurred in procedure Form_Open of " _
> > > > > > > > > & "VBA Document Form_frm_dbo_Errorlog"
> > > > > > > > > lngIcon = vbOKOnly + vbInformation
> > > > > > > > >
> > > > > > > > > MsgBox strErrMsg, lngIcon, "Error"
> > > > > > > > >
> > > > > > > > > Resume exit_PROC
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > End Sub
> > > > > > > > >
> > > > > > > > > Private Sub Form_Unload(Cancel As Integer)
> > > > > > > > > Set rs = Nothing
> > > > > > > > > Set cnn = Nothing
> > > > > > > > >
> > > > > > > > > End Sub
> > > > > > > > >
> > > > > > > > > Bill
> > > > > > > > >
> > > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , Agestha Hendra
> > <agesthahendra@> wrote:
> > > > > > > > > >
> > > > > > > > > > Thank you Steve,..
> > > > > > > > > >
> > > > > > > > > > May i have your complete codes example to do that,...i'm
> > beginner in VBA,..
> > > > > > > > > >
> > > > > > > > > > Regards
> > > > > > > > > > Hendra
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > ________________________________
> > > > > > > > > > Dari: Steve Conklin <StephenMConklin@>
> > > > > > > > > > Kepada: MS Access Pros List
> > <ms_access_professionals@yahoogroups.com
> > <mailto:ms_access_professionals%40yahoogroups.com> >
> > > > > > > > > > Dikirim: Jumat, 3 Agustus 2012 23:33
> > > > > > > > > > Judul: RE: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > If you have a linked table to the same database, you can borrow
> > that table's connect property (that's what I usually
> > do).qPT.connect=currentdb.tabledefs("some odbc linked table").connect Steve
> > > > > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com>
> > > > > > > > > > From: wrmosca@
> > > > > > > > > > Date: Fri, 3 Aug 2012 15:21:45 +0000
> > > > > > > > > > Subject: [MS_AccessPros] Re: vba to make Pass through Queries
> > (with no DSN)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > テつ
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > テつ テつ
> > > > > > > > > > テつ テつ テつ
> > > > > > > > > > テつ テつ テつ
> > > > > > > > > > テつ テつ テつ Hendra
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > The easiest way I know is to create a DSN file and use the
> > builder button in the properties box to select it as the connection string. It
> > doesn't actually use the DSN file. It just copies the parameters.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > A typical connection string to a SQL Server database using
> > windows Authentication would look like this:
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > ODBC;DRIVER=SQL
> > Server;SERVER=InstanceNameGoesHere;DATABASE=DBNameGoesHere;Trusted_Connection=Ye
> > s
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Regards,
> > > > > > > > > >
> > > > > > > > > > Bill Mosca, Founder - MS_Access_Professionals
> > > > > > > > > >
> > > > > > > > > > http://www.thatlldoit.com
> > > > > > > > > >
> > > > > > > > > > Microsoft Office Access MVP
> > > > > > > > > >
> > > > > > > > > >
> > https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> > > > > > > > > >
> > > > > > > > > > My nothing-to-do-with-Access blog
> > > > > > > > > >
> > > > > > > > > > http://wrmosca.wordpress.com
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > --- In MS_Access_Professionals@yahoogroups.com
> > <mailto:MS_Access_Professionals%40yahoogroups.com> , "agesthahendra@"
> > <agesthahendra@> wrote:
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > Hi Everyone,...
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > I'm trying to write VBA to make a PTQ but with no DSN in the
> > syntax but
> > > > > > > > > >
> > > > > > > > > > > using Connection string since connection string don't require
> > a DSN.
> > > > > > > > > >
> > > > > > > > > > > Any example to do this would be appreciated...thank you.
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > Regards
> > > > > > > > > >
> > > > > > > > > > > Hendra
> > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > テつ テつ
> > > > > > > > > > テつ テつ
> > > > > > > > > >
> > > > > > > > > > テつ テつ
> > > > > > > > > > テつ テつ
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > テつ テつ テつ テつ テつ テつ テつ テつ テつ テつ テつ テつ テつ
> > テつ テつ テつ テつ テつ
> > > > > > > > > >
> > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > ------------------------------------
> > > > > > > > > >
> > > > > > > > > > Yahoo! Groups Links
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Yahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (33)

Recent Activity:

• New Members 3
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___