=> Access Query to SQL Server syntax Query

[Rhonda Fischer]

Hello,

I am endeavoring to increase the speed of my
Access application, it is currently quite slow.

Are there any performance benefits in converting my
Access queries to either a 'Pass-Through' query or
VB Code.

However, I have not found a means to pass arguements
into my 'Pass-Through' queries using SQL Server syntax?
My 'Pass-Through' query uses a connection string of:
_________________________________________________________
ODBC;DRIVER=SQL
Server;SERVER=ZSQUIRREL;DATABASE=TurnersMgmtSystem;Trusted_
Connection=Yes
_________________________________________________________


And my Visual Basic code doesn't provide me with the means
to display more than one record in my recordset to a
Continuous Form with unbound text fields. My Visual Basic
code uses a connection string of:
_________________________________________________________
cnn.Open "Provider=sqloledb; Data Source=ZSQUIRREL;Initial
Catalog=TurnersMgmtSystem; Integrated Security=SSPI"
_________________________________________________________

Does the connection string used in my VB code ensure a
quicker retrieval of information than that used in my
Pass-Through query?

Thank you for you suggestions.

Kind Regards
Rhonda

 

[[MVP] S. Clark]

The following link is some background reading about the development of
client / server apps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnapg/html/apgintro.asp


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-