make archive table in Back-end

[johnboy7676]

I have the following code that archives a table, and it works, but I'd
like to archive the table to the back-end, which is on a network
drive. (DAO)

Dim strSql As String
Dim strTableName As String

strTableName = "tblMasterFile" & Me.txtArchiveYear

strSql = "SELECT tblMasterFile.* INTO " & strTableName & " FROM
tblMasterFile;"

DoCmd.RunSQL strSql


Also, once the archived table is on the back-end, how can I link to it
automatically?

Thanks, John

 

[Douglas J. Steele]

If you still need to access the data, why are you moving it to another
table? I doubt very much it will speed anything up.

 

[John]

If you still need to access the data, why are you moving it to another
table? I doubt very much it will speed anything up.

No, not for speed, the table is pretty small. Simply to have the
archived yearly data in one location (back-end), and then to have that
data available for all users.

Thanks, John

 

[Tony Toews [MVP]]

No, not for speed, the table is pretty small. Simply to have the
archived yearly data in one location (back-end), and then to have that
data available for all users.

It's a lot easier to figure out some means of filtering various forms
to default to using current data only and yet make it easily available
for history purposes.

Tony

 

[johnboy7676]

It's a lot easier to figure out some means of filtering various forms
to default to using current data only and yet make it easily available
for history purposes.

Tony

Hmm, well, you're probably right. I think I'll set it up more like
you describe.

Thanks for the advice.
John