Backup table in Access with specific date ranges - best way

[jaryszek]

Hello Guys,

My process:

1. split database
2. in back-end there is one big table with all dates and users which are inputing data which i want to backup.

Now,
i would like to create back up automatically once a day - i have already solution and additionally i would like to back up table with dates choose by user.

So for example administrator wants to backup database for quater 1 from 01-01-2017 to 31.03.2017 so he can choose date range and after that...
and here what are you solutions Access Gurus?

My idea is to write code which will be taking data ranges, aplly as filter in query and somehow will be transfering table into new access database.

Do you have maybe any ideas ?



Thank you for all your suggestions.
Best Wishes,
Jacek Antek

[JoeM]

Create the query that has the records you want to backup. Then you can use that in a Make Table Query to export those records to a new table in another database.
See post #15 here for what that code may look like: https://access-programmers.co.uk/for...4&postcount=15

[ranman256]

Just backup the db to a folder;

Dim vTarg,vSrc

vTarg = "\\server\folder\myDb" & format(now,"yyyymmdd-hhnn") & ".accdb"
VSrc= "\\server\folder\myDb.accdb"

filecopy vSrc, vTarg

[jaryszek]

Hi Guys,

i have mixed both of your solutions and it is working fine !

Thank you very much
Best Wishes,
Jacek Antek

[JoeM]

You are welcome!