Newbie data mgmt question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to write some code that will run a simulation X number of times and
generate data that will then be sorted, averaged, etc. Using a local Access
database (no back-end)

More specifically (and for the insurance-inclined), am trying to use Access
to generate simulated insurance losses from frequency and severity parameters
(which are known in advance)

Does one always have to physically write the simulated data to a table to
sift through it? Is it possible to simulated such insurance losses and house
them only in physical memory without writing them to a table (probably need
+500k simulations for convergent results which is probably a lot of records
in an Access table)

All thoughts welcomed and appreciated. Thanks
 
It is best to write these values to a table -- especially
with the amount of records you will need to sift through,
you would not want to use an array. If you do not want to
create that table in your working database, create it in a
"scratch" database and attach to it.

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Cheers Crystal...my thinking exactly since my original post

Think I will figure out some code that will create a temp db in the user's
local temp folder, create a table in that temp db, then have the simulation
populate that table

If anyone had the code readily at hand that would help guide me as to how to
achieve this it would be greatly appreciated

Many thanks
 
I have some code you could pattern after but it is a bit
long to post and I don't have it on a website...

actually, if the simulation table will always have the same
structure, do this:

1. create the table in another database
2. make a backup of the empty database so you can "delete"
everything without having to open it, do it, and
compact/repair -- by simply deleting the database and
replacing it with the empty backup
2. link to it

then you can do everything as if it were resident (except
change the design)

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top