Networks

Ask something
Question Locked

Can Access 2007 Runtime end users update the database?

0 helpful
4 replies

by skated0rk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
First of all I don't have Access 2007. I am however about to upgrade just myself and maybe later my 40-60 end users. I am thinking about installing the runtime version on all the computers except mine because I will be the only person doing developement with access. The Access forms do not only select from the database but it adds data. Will the Access 2007 runtime users be able to use the forms to update the database on the microsoft sql server?

4 replies

by rintuttle

You are able to add data while in 2007 runtime mode. You are not, however, able to change the configuration or design of the database. Runtime is strictly for data entry and report generation; which is the primary objective for most end-users.

by loubonnett

ACC runtime will, by and large, work exactly like the regular .accdb version save for the ability to to create or modify objects. End users will be able to create and update records to your backend file. I suppose you might have some issues if your running make table queries though. Also, runtime versions don't display the default access ribbon or shortcut menus, so you'll have to design your own. It was a bit of a pain switching from the ease of menu customization to ribbons, but I got the hang of it after a few days. I hated the ribbon at first, but now that I've been able to design some really nice custom ribbons, I really like them.

by vramdass

Hi, not sure if this is the correct forum but here's my issue...
I have an Access 2007 app.
How do I go about -
acquiring and implementing the runtime software - I read somewhere that the
developer components or some other software can be downloaded for free only for Access 2007 - is this correct? What are the links?

This discussion is closed to new replies.