If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a Password With an SQL IN Clause
I am trying to delete records from an external database using a SQL IN
clause, but my syntax is obviously flawed. My code looks like this: DELETE * FROM myTable IN "C:\myFolder\myDatabase_BE.mdb" ";PWD=abcd" This gives me an error message that says my password is invalid although I am using the same password in a SELECT statement without a problem. -- Rob Evans |
#2
|
|||
|
|||
Using a Password With an SQL IN Clause
On Mon, 19 Apr 2010 12:46:01 -0700, revans611
wrote: One workaround would be to temporarily attach the table, run the Delete statement, and detach. -Tom. Microsoft Access MVP I am trying to delete records from an external database using a SQL IN clause, but my syntax is obviously flawed. My code looks like this: DELETE * FROM myTable IN "C:\myFolder\myDatabase_BE.mdb" ";PWD=abcd" This gives me an error message that says my password is invalid although I am using the same password in a SELECT statement without a problem. |
Thread Tools | |
Display Modes | |
|
|