Need help with MS Access 2003 Form [closed]

asked 2014-01-23 14:40:02 +0100

fldynamatic gravatar image

updated 2015-09-02 22:57:35 +0100

Alex Kemp gravatar image


I need to convert an Access form to Base ( or import it). The form has several push buttons that contain links to different Excel Spreadsheets. So for example if I push the button for fred, it will launch Excel (later to become Calc) and open the spreadsheet containing Fred's data. How can I recreate this using base?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 03:52:07.570362


"later to become Calc" will not work, but first you have to care about the data. Using a sheet as data base table restricts you to read only. If you want to alter the data using a form, you need a true database management system (recommend), or you stay with the Jet engine of Access (only on Windows) or you use the embedded HSQL engine, or you use dBase format. In any case you have to first convert/transport your data, then create the odb connection file and then the form.

Regina gravatar imageRegina ( 2014-01-25 19:01:41 +0100 )edit

Thanks for you inputs.

fldynamatic gravatar imagefldynamatic ( 2014-01-29 10:06:05 +0100 )edit