Removal of User Level Security in ACCDB

[ions]

Dear MS Access Expert.

I learned that User Level Security (.mdw) files were abandoned in ACCDB?

Why did Microsoft do this? Is there some kind of new security in ACCDB to replace user level security?

Is Microsoft trying to push developers to migrate to VB.Net for multiple user database applications?

Thanks

Peter

 

[boblarson]

Dear MS Access Expert.

I learned that User Level Security (.mdw) files were abandoned in ACCDB?

Yes, that is true, however if you use the MDB file format you can still use ULS in Access 2007.

Why did Microsoft do this?

From what I can tell, it was due to the fact that ULS was not really secure anyway and was very confusing to users. I know that the reasons have been stated to the Access MVP's from the Access team, but I don't think it was while I was one, so I missed out on that conversation.

Is there some kind of new security in ACCDB to replace user level security?

Right now, it is basically a single encryption password and if you want security they suggest a SQL Server backend or SharePoint.

Is Microsoft trying to push developers to migrate to VB.Net for multiple user database applications?

Not VB.NET but SharePoint.

 

[ions]

Bob you can create database applications with Sharepoint?

I thought it was more a portal for departments to share information and files?

Slightly confused.

 

[boblarson]

Bob you can create database applications with Sharepoint?

I thought it was more a portal for departments to share information and files?

Slightly confused.

Yes, with 2003 and 2007 you can connect to SharePoint lists and use them as tables. You have to maintain the Referential Integrity as those versions do not have that. But they can be used. There are other limitations as well. They do not work with large datasets. And, they are not overly quick.

 

[ions]

Where does Access fit into the Microsoft strategy at the moment and the future.

Are they pushing Access as a single user database application?

Thanks

Peter

 

[boblarson]

Are they pushing Access as a single user database application?

No, more like small group/departmental. And so far it seems that they are still committed to bringing it out. Access 2010 has some very good stuff in it.

 

[ions]

Thanks Bob.

Will 2010 be ribbon based? I haven't touched 2007.

Appreciate your answers.

Peter

 

[boblarson]

Thanks Bob.

Will 2010 be ribbon based? I haven't touched 2007.

Appreciate your answers.

Peter

Yes, it uses the Ribbon, just like 2007. There are some enhancments in 2010 which aren't in 2007 (like being able to edit existing Ribbons - add/remove tabs, groups and buttons, including by code - without using XML).

 

[ions]

Thanks Bob