Printable View
Hi all,
I have a project in hand for which I am really confused as to how to start the project coz it contains a lot of tables and reports in Access. I would like to know from those experts out there that, is it advisable to do the coding in VB with Access as the Back End or should I do the coding in VBA for Access? Please suggest.
Thanks
You have double posted:ehh:
Do the coding in VB. You might change the backend at some point in the future, and then where would you be?
You are absolutly right. Thanks for the info.
BTW is there a way to use Excel as the backend on one of the forms?
Thanks
there should be. i remember seeing something like excel files as a source of a dsn in odbc.
You can use Excel with ease, you just need to include the proper references in the project. Once there, you can do anything you want with Excel.....slowly. I have found that using Excel seems a bit slow, but I haven't worked with it much, and it could be just the particular way I was doing things.