Question Advice on copying database

[SiTheITGuy]

Hello, I created a database for my work which helps us analyse call statistics and decide whether we have met KPIs etc. The problem is that the SQL database it gets the data from is read only and always will be. What I would like to do it take a copy of the database and then I can safely 'override' the information held within my database.

I know I could achieve this with an update query but then every time I ran the update query it would overwrite any changes I or my colleagues had made. My next thought was to append it each week so that the, for example, the last week's worth of calls were copied. I think this would work but is obviously a bit dangerous as we could accidentally overwrite data if we chose the wrong dates!

If the above makes sense, can anybody suggest a better way to achieve this? I am reasonable on Access and happy to pluck away for a while but am not a programmer!

Thank you.

 

[gemma-the-husky]

why is the dbs read only?

anyway, you can have an access database as follows:

link to the tables in the sql database
have access tables additional to those in the sql database within the access dbs
in the access tables, you can store whatever you like.