Question Access 2010 'View Only' version

[sonof27]

Morning All,

I was hoping someone could point me in the right direction for some info on the 'View Only' version of Access 2010. Our company is moving from Access2k to 2010 later this year and in it's wisdom is going to restrict many users to 'View Only' and only purchase limited full access licences. It would be nice to know, as I'm converting many of my DB's, if there is something I need to do differently to ensure users on a 'View Only' version will still be able to used the DB and be able to read and update the data on the tables.

Any info would be greatly appreciated. Thank-you.

 

[Galaxiom]

I fully agree with the company's wisdom. The less users with full Access the better.

Only the developers need the full version. There are no limitations to data entry using the RunTime so long as the Forms are provided. They just can't design and don't get the Navigation Bar (equivalent to Database Window in old versions) which is a good thing.

They can't really open tables, forms queries or reports without a button to do it.

 

[gemma-the-husky]

OP

are you expecting these to be VIew Only - and not be able to change the data.

Unless they changed stuff in A2010 - that isn't what happens. You can't design new forms. but you can change data through existing forms.

 

[sonof27]

Many thanks guys. Thats about what I wanted to know, and thought would be the case, just was not able to find anything on it. I will have to wait to see if any of my dodgy VBA will be rejected by the 'View Only' version. Thanks again for the info.

 

[Galaxiom]

Best use the right name for what you call "view only".

Runtime.

 

[sonof27]

Now that makes it much easier to find some info . View Only was what our IT department called it, no wonder I could not find anything. Many thanks again

 

[Galaxiom]

View Only was what our IT department called it...

That your IT department used such an unusual term is a slightly scary thought.
I do hope they were just re-expressing "runtime" in a language they thought the other staff would understand better.