Re: How to select rows from a mapped protected .MDB and insert into local table
- From: mikepallorad@xxxxxxxx
- Date: 10 Aug 2006 06:09:03 -0700
sorry again
yes Bob you are right
I copy pasted the older commented string.
actually it is ";jet OLEDB:Database Password=" & Text1.Text
the error is in the select Statement.
Private Sub Commandbtn_Click()
Dim Cn As ADODB.Connection
Set Cn = New ADODB.Connection
Cn.CursorLocation = adUseClient
adocon.Open "Provider......;pwd=" & me.text1.text
strSQL = "insert into [Table1] (x,y,z) values ( SELECT [x1],[y1],[z1]
from "
strSQL = strSQL & "[Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
strSQL = strSQL & Left(Drive1.Drive, 2) & "\MappedDB.mdb;et
OLEDB:Database Password=" & Text1.Text & "].[MappedTable])"
Cn.Execute strSQL
End Sub
may be i will go for the normal recordset method to retreive and add
and linking ... i didnt try it before ....
will it be faster than the recordset method ?... i will try.....
.
- Follow-Ups:
- Re: How to select rows from a mapped protected .MDB and insert into local table
- From: Bob Barrows [MVP]
- Re: How to select rows from a mapped protected .MDB and insert into local table
- References:
- [ADO] How to select rows from a mapped protected .MDB and insert into local table
- From: mikepallorad
- Re: [ADO] How to select rows from a mapped protected .MDB and insert into local table
- From: Bob Barrows [MVP]
- Re: How to select rows from a mapped protected .MDB and insert into local table
- From: mikepallorad
- Re: How to select rows from a mapped protected .MDB and insert into local table
- From: Bob Barrows [MVP]
- Re: How to select rows from a mapped protected .MDB and insert into local table
- From: mikepallorad
- Re: How to select rows from a mapped protected .MDB and insert into local table
- From: Bob Barrows [MVP]
- [ADO] How to select rows from a mapped protected .MDB and insert into local table
- Prev by Date: Re: How to select rows from a mapped protected .MDB and insert into local table
- Next by Date: Re: How to select rows from a mapped protected .MDB and insert into local table
- Previous by thread: Re: How to select rows from a mapped protected .MDB and insert into local table
- Next by thread: Re: How to select rows from a mapped protected .MDB and insert into local table
- Index(es):
Relevant Pages
|
|
