L
Luke
I use linked tables (via ODBC) to update selected data
into my Access tables. The linked tables require a
password to open (same password for all). With all other
tables I use SQL Pass-Through queries to supply the
password. But for this 1 table only I am unable to do
that and must use the table itself (due to its sheer
size - 40+ million rows).
I use ADO to update my Access tables and need to provide
the password upon update start. Very simplified version
of the code follows:
Public Sub UpdateAccessTable()
Set cnn = CurrentProject.Connection
cnn.Execute "INSERT INTO <Access table>
SELECT <Linked table>
FROM <Linked table>
WHERE (Year>2002);"
cnn.Close
Set cnn = Nothing
End Sub
Any ideas how to do this or where to find out?
Thank you for you help.
Luke
into my Access tables. The linked tables require a
password to open (same password for all). With all other
tables I use SQL Pass-Through queries to supply the
password. But for this 1 table only I am unable to do
that and must use the table itself (due to its sheer
size - 40+ million rows).
I use ADO to update my Access tables and need to provide
the password upon update start. Very simplified version
of the code follows:
Public Sub UpdateAccessTable()
Set cnn = CurrentProject.Connection
cnn.Execute "INSERT INTO <Access table>
SELECT <Linked table>
FROM <Linked table>
WHERE (Year>2002);"
cnn.Close
Set cnn = Nothing
End Sub
Any ideas how to do this or where to find out?
Thank you for you help.
Luke