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

Seeking syntax for pass-through query to delete SOME table records

P: n/a
MLH
I have a table with the following fields:
AreaID AreaCode Exchange City

The table is in an Access 97 database. The table actually
resides on a Linux box and is attached via a MySQL ODBC
process. I want to write a pass-through query to delete records
with AreaCodes beginning with 5.

I am not familiar with Pass-Through and could use a bit of help.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Pass-through Queries are for "passing through" Jet and ODBC _unchanged_
Queries in the SQL dialect of the server database. Thus, your question would
better be asked in a newsgroup devoted to MySQL, where MySQL's dialect of
SQL is better known.

Larry Linson
Microsoft Access MVP

"MLH" <CR**@NorthState.net> wrote in message
news:60********************************@4ax.com...
I have a table with the following fields:
AreaID AreaCode Exchange City

The table is in an Access 97 database. The table actually
resides on a Linux box and is attached via a MySQL ODBC
process. I want to write a pass-through query to delete records
with AreaCodes beginning with 5.

I am not familiar with Pass-Through and could use a bit of help.

Nov 13 '05 #2

P: n/a
MLH
You are right. Thx Larry.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.