Rommel

Sharepoint is a great product for those who can utilize it but what about for those who cannot utilize it or the product is not that needed to implement?

I really think it would be better for Microsoft to give an Option aside from Sharepoint and SQL server. 

This option is what we asked since version 2000:  Access database file size limit - 2 gig upsizing to greater heights compare to MySQL which is free.

1.  Though it is said that we can create multiple database (backend) but it is also recommended to keep all tables in one DB, therefore, sooner or later, it will outgrow the size limit.

2.  Though it is said that there is MS SQL, different users have different knowledge level for different tools.  Since we are users in Access, therefore we are looking this after in Access.

3.  Basically same as I have posted here:   http://channel9.msdn.com/shows/Access/The-Access-Show-Episode-Two/

This will surely satisfy the customers needs and wants.

Different Users have different needs and wants.  One user may not want to use the ribbon because of his own personal views and experience, one user may want to use the new features base on his own views and experience.  One user can create application or projects using different tools, one user can create application or projects using only few tools base on his present knowledge.

While I think, creating program doesnt only limited to those professional programmers.  That is why there is the beginner, advanced and expert programmer.  Thus, the level of knowledge varies.

On the other hand, what is true here is that Microsoft is a company who's objective is to attain PROFIT.  That is why they created or innovate products that would meet that goal.  And we cannot do anything about that.

That is why Sir Clint Covington Sir, I would not mind if the price of Access will increase due to my requested features, because what is the use of paying small amount and nothing or limited things that can be done. 

I guess it will be best for Microsoft to give many options to the customers to increase the chances of sale.

For example:  Sharepoint is great for those who can utilize it but some people may avail of sharepoint but not all, so they choose other

                        option.

                        The other option would be stand-alone Access DB with huge size capacity which will cater the knowledge level of the user

                        The other option would be MS SQL which will also cater the higher knowledge level of the user on server.

                        I think on this way, Microsoft Access programmers have many options which will also cater to their own and customers/client  

                        needs.

                        I think also, on this way, instead of Access users will migrate to MySQL which is free, Microsoft can ensure that their customers

                        have options and Microsoft can make the sale.

P.S.  I am only pertaining to MICROSOFT ACCESS and its users which is the main topic of this site.

My comment on Access 2007 and for the new Access 2010:     Addition to my previous post

The new features presented here in the demo are neat and would be useful in the long run as developers would use it. 

However, those features are in my opinion not very much immediately useful because for many years now, it is a fact that most developers have stayed using version 2003 instead.

It would be VERY MUCH useful and recognized if the password security and database file size capacity were enhance, upgraded, upsized because it is MUCH MORE NEEDED than added new features presented here in the demo.

With these new features, we pay for it which are not useful for us.  But if what we pay is very useful for us, we would not hesitate cashing out money for it. 

Why do I protest to upsize to SQL server?  It is because:

1.  Access database it much more easier and friendlier to use and maintain.

2.  Access database is much more easier to deploy.

3.  Access database is my choice.

Eventhough there is this MySQL that is free and unlimited database size capacity and more robust security but the fact is the above 3 reasons.

Using MySQL is very possible in the very near future but if password security and database file size capacity were not enhanced, upgraded, upsized, that would be enough for Access developers to continue using access database.

codexproject@yahoo.com

My comment on Access 2007 and for the new Access 2010:

1.  ABOUT THE RIBBON AND NAVIGATION PANE

     Previously I really hate Ribbon because I need to learn how to use and program in XML to create the ribbon but when I learned it thru   

     reading and researching, I kind like it now and same towards the ribbon.  Previously I expressed my hate to ribbon on different access

     forums and microsoft blog and forums or discussions but now its ok. Maybe I have to learn more.  What I just need is the complete

     reference material like command idMso and other idMso.

    On my learning and working with Ribbon, I find the reference material available for download in Microsoft.com Site somewhat lacking

    especially for control id ( idMso ).  I need the complete reference for the purpose below:

     a. for customizing the office button and QAT toolbar (disabling them)

     b. for customizing the office button (to change the logo or its picture)

     though it is indicated in the license agreement that the logo should appear there, but I guess it would not matter since the application is

     still recognizable thru its filename extension.  and the "poweredby AccessRuntime2007" will be visible.

2.  SECURITY / MACROS / SANDBOX MODE / TRUSTED LOCATIONS / DIGITAL SIGN

      Previously I also asked Microsoft to dumped this securities for this will disable the application especially on runtime when the startup

      involves functions and macros.  However, upon some researches, I have managed to solve it.

3.  MDB OR ACCDB TO EXECUTABLE FORMAT

     I really dont know if it is possible to create executable file from mdb or accdb format for an executable file is not a database file format, 

     they are totally different format, but I dont know maybe Microsoft find a way to do it since they are the creator of the application.  Having

     the accdb or mdb format into an executable file is much more elegant.

4.  ENCRYPTION / USER LEVEL SECURITY

     On version 2007 and 2010, its encryption method is strengthened.  Actually in everythingaccess.com, you can find a utility that will even

     more change the encryption method to a more powerful one.  However, still every access forum sites that I have joined, the moderators

     there say that the security is likened to a "LOCK ON A SCREEN DOOR".  It is same as USELESS.  They would suggest upsizing to SQL servers

     if we are after for security. 

     But since I am using Access product, I would like to suggest to empower the security of access (the encryption). 

     On the other hand, I am grateful that the ULS has been abandoned because that is really a waste of time and construction.  It is just   

     redundant security to password security.  It is better to have one password security that will satisfy its purpose.

5.  DATABASE FILE SIZE CAPACITY

     On many forums I have joined with, they say (especially the moderators and VIP's) that 2 gigabyte per database is enough but we all

     know that someday it will outgrow and need more space.  They also say that you can use as many backend database files as you want so

     there is no need to ask to increase its size capacity.  What they say could be thru but I think in the long run, it will rise more problem. 

    They say that when you really need more space, you should UPSIZE to SQL SERVER.  But the only problem there is that we need to learn

    another product and that is using SQL Server. And maybe the customer might need to learn SQL too which is impossible for medium to

    small business enterprises. Also that would incur us additional expense.

    Another option is to use MySQL which is freea and unlimited size capacity.  But again you need to learn how to use and administer

    MySQL.

    The MySQL option would be preferrable since the product is free and all you need to do is to learn it.

     If that is the case and if we take into consideration that Microsoft products are user-friendly,  why should Microsoft limit the database size

     of its Access database.  It is futile if the purpose is to bring the customer to upsize to MS SQL because there is MySQL.  Why not satisfy

     their Access customers wants and needs instead so that Microsoft will even more bring their customers closer to them?

     The fact that Microsoft has built new technology (SharePoint) thru internet, but it is also a fact that not all customers use internet. 

     So I would also like to ask to upsize the size capacity of Access database, not only limited to 100GB but even to higher size capacity liken

     to MySQL if Access is to be competitive.

6.  OTHER SUGGESTIONS

     Many users still dont want Ribbon because it is hard for them to create.  May I ask Microsoft to create a wizard or an addin to assist the

     users in the creation of Ribbon.

7.  Maybe there are still many features that needs to be incorporated.  But the above features that are requested are in my opinion and base

     on my experience are the most needed and wanted features in MS Access database application.

     Hoping for Access Development Team to hear us.