clear me about to open table...

User avatar
sal21
PlatinumLounger
Posts: 4364
Joined: 26 Apr 2010, 17:36

clear me about to open table...

Post by sal21 »

I use this statemento to open recodset from a table... and in the same tiam after the selection i ned to write into the same table, is correct? Because i see the code is very, very slow!

Code: Select all

SQL = "SELECT * FROM VIAGGIANTI_TAB WHERE VIAGGIANTI_TAB.AGG=#" & Format(DATA_AGG, "MM/DD/YYYY") & "# ORDER BY SPORTELLO"
    GAF_RS.Open SQL, DATA_MART_CONN, 2, 2

User avatar
HansV
Administrator
Posts: 78553
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: clear me about to open table...

Post by HansV »

What exactly is your question?
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4364
Joined: 26 Apr 2010, 17:36

Re: clear me about to open table...

Post by sal21 »

HansV wrote:What exactly is your question?
Resolved, tks.