In clause

H

Helder Conceicao

I have one database password protected... It is possible to use them in a "in
clause" in the sql?

Example: INSERT Into Zsrc_Alunos SELECT * FROM Alunos IN ""
[DATABASE=C:\BDS\Age_real.mdb;]

Where i put the password in the sql expression?

Thanks for the help.
Helder Conceicao
 
C

Chris O'C via AccessMonster.com

The db password needs to go inside the brackets.

INSERT Into Zsrc_Alunos
SELECT * FROM Alunos IN "" [;DATABASE=C:\BDS\Age_real.mdb;pwd=thepassword]

Chris
Microsoft MVP


Helder said:
I have one database password protected... It is possible to use them in a "in
clause" in the sql?

Example: INSERT Into Zsrc_Alunos SELECT * FROM Alunos IN ""
[DATABASE=C:\BDS\Age_real.mdb;]

Where i put the password in the sql expression?

Thanks for the help.
Helder Conceicao
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding sequence numbers to paragraphs 0
Creating a Search using a combo box and then creating a report. 4
Table Security in Access 2013 1
Dynamic Naming of Form Button 3
Using a Password With an SQL IN Clause 1
Help creating a search form in Access XP 0
not in criteria fails 2
IN clause on password protected external mdb 1

Top