By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Parallel Threads in Access

P: 84
I currently use an SQL command line that utilizes parallel threads. ex.
select /*+ PARALLEL (ACCOUNT 20) */ Account_ID, Customer_Name, Add_Date from Customer_Info. By running this query using parallel threads, it returns results in less than one minute. If I did not use the parallel threads, it would take 20 minutes or more to run. This command is run using SQL+
Is it possible to use Parallel thread processing in Access? If so, how?
Nov 27 '06 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
PEB
I think that no! If there was an opportunity to do this.... It should be great!

But let other experts on Access tell their opinion!

:(
Nov 27 '06 #2

PEB
Expert 100+
P: 1,418
PEB
A question?

Are u using Access database or u use your SQL database?

If u use your original SQL database you can pass queris directly to the Server and in this case it should be possible!

But with Access database seems impossible!

:)
Nov 27 '06 #3

NeoPa
Expert Mod 15k+
P: 31,656
The only parallel processing supported by Access, as far as I know, is Asynchronous execution of queries.
Execute Method


Runs an action query or executes an SQL statement on a specified Connection or Database object.

Syntax

object.Execute source, options

querydef.Execute options

The Execute method syntax has these parts.

Part Description
object A Connection or Database object variable on which the query will run.
querydef An object variable that represents the QueryDef object whose SQL property setting specifies the SQL statement to execute.
source A String that is an SQL statement or the Name property value of a QueryDef object.
options Optional. A constant or combination of constants that determines the data integrity characteristics of the query, as specified in Settings.



Settings

You can use the following constants for options.

Constant Description
dbDenyWrite Denies write permission to other users (Microsoft Jet workspaces only).
dbInconsistent (Default) Executes inconsistent updates (Microsoft Jet workspaces only).
dbConsistent Executes consistent updates (Microsoft Jet workspaces only).
dbSQLPassThrough Executes an SQL pass-through query. Setting this option passes the SQL statement to an ODBC database for processing (Microsoft Jet workspaces only).
dbFailOnError Rolls back updates if an error occurs (Microsoft Jet workspaces only).
dbSeeChanges Generates a run-time error if another user is changing data you are editing (Microsoft Jet workspaces only).
dbRunAsync Executes the query asynchronously (ODBCDirect Connection and QueryDef objects only).
dbExecDirect Executes the statement without first calling SQLPrepare ODBC API function (ODBCDirect Connection and QueryDef objects only).
Nov 27 '06 #4

P: 84
The only parallel processing supported by Access, as far as I know, is Asynchronous execution of queries.

Thanks for the updates. I have created a passthrough query that is working for me
Nov 30 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.