I have an Access DB that I have lots of VBA code behind the forms and a few modules.
Currently, I create an Access accde for the customers instead of distrubuting the whole database to everyone. They download the frontend piece to their desktop and they can run reports, enter data against records, etc.
Right now it's a 2007 b/c most of the users don't have 2010 so I started looking into sharepoint and putting the front end out there hoping that I could convert the databases to Access 2010 and the customers could use it that way.
When i tried to publish the accde to Access Services, it gave me the error of VBA is passowrd protected which it's not but I'm guessing that it's b/c it's an accde and the VBA isn't available unless you're in the accdb.
Is it possible to publish a 2010 accde to Access Services and customers that have Access 2007 still use it?
2nd question:
If I have to publish the accdb to Access Services, how do I force it to open a particular form on the web?
I've was success in publishing the DB but it was asking me to choose a form to open upon using the Db and when I went to File/Options/General Applications, Web form was 'none' and there wasn't anything in the dropdown that I could choose.
I have a default form if you open it in Access and it works fine but I can't do it for the Web.
Thanks!
Currently, I create an Access accde for the customers instead of distrubuting the whole database to everyone. They download the frontend piece to their desktop and they can run reports, enter data against records, etc.
Right now it's a 2007 b/c most of the users don't have 2010 so I started looking into sharepoint and putting the front end out there hoping that I could convert the databases to Access 2010 and the customers could use it that way.
When i tried to publish the accde to Access Services, it gave me the error of VBA is passowrd protected which it's not but I'm guessing that it's b/c it's an accde and the VBA isn't available unless you're in the accdb.
Is it possible to publish a 2010 accde to Access Services and customers that have Access 2007 still use it?
2nd question:
If I have to publish the accdb to Access Services, how do I force it to open a particular form on the web?
I've was success in publishing the DB but it was asking me to choose a form to open upon using the Db and when I went to File/Options/General Applications, Web form was 'none' and there wasn't anything in the dropdown that I could choose.
I have a default form if you open it in Access and it works fine but I can't do it for the Web.
Thanks!