L
Lucky
Create SQL Pass-Through query (thus supplying logon id,
password, etc.) and create simple ADO code, something
like:
Sub PeriodicalUpdate()
Dim cnn As New ADODB.Connection
Dim strSQL As String
Set cnn = CurrentProject.Connection
StrSQL = " <enter your SQL string to make-table>"
cnn.Execute StrSQL
cnn.Close
Set cnn = Nothing
End Sub
To schedule it use form OnTimer event or Scheduled Task
(Windows) or check www.splinterware.com and download free
(or purchase) Windows Scheduler.
Hopefully this helps.
Lucky
password, etc.) and create simple ADO code, something
like:
Sub PeriodicalUpdate()
Dim cnn As New ADODB.Connection
Dim strSQL As String
Set cnn = CurrentProject.Connection
StrSQL = " <enter your SQL string to make-table>"
cnn.Execute StrSQL
cnn.Close
Set cnn = Nothing
End Sub
To schedule it use form OnTimer event or Scheduled Task
(Windows) or check www.splinterware.com and download free
(or purchase) Windows Scheduler.
Hopefully this helps.
Lucky