G
Guest
I am trying use the solver functionality via Access.
Here is my situation:
I am creating a dataset in Access. I tranfer that to a excel spreadsheet.
I need to run an optimization on that data using the solver function. I then
need to transfer the results back into Access.
Here is my experience:
I can transfer the data into the spreadsheet using the
docmd.transferspreadsheet code.
I cannot get the solver function to work without locking up the computer and
having to reboot.
I am using Office XP
Any suggestions?
Here is my situation:
I am creating a dataset in Access. I tranfer that to a excel spreadsheet.
I need to run an optimization on that data using the solver function. I then
need to transfer the results back into Access.
Here is my experience:
I can transfer the data into the spreadsheet using the
docmd.transferspreadsheet code.
I cannot get the solver function to work without locking up the computer and
having to reboot.
I am using Office XP
Any suggestions?