Access 2010 is now available!

Excellent. Thanks to everyone on the Access team whose dedication and committment have resulted in a product we can all be proud to use. George Hepworth

Congratulations, Access team. I know you've worked hard on this version and from what I can see so far it is a vast improvement. And that is saying a lot because I thought the previous versions were great as well.

Yes, a real nice thumps up to you folks. This is quite the release with a great list of new features. While I seem to find a new favorite feature every week, the new browser control is really is nice and works so smooth and reliable. Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

I just got a retail copy of Access 2010 and installed in XP (SP3). I am wondering where is the Package Solution Wizard (Developer extension). I understand that it should be in File/Save & Publish section but it is not there. Appreciate any help and guide to get this feature visible. Thanks.

Is this a Bug in A2010 (64)

Replace function giving compile error

The most exciting Access release for years! Keep up the great work!

I want to publish a 2010 Access database to a host sharepoint server. Do I need to buy any license / install any software in the clients computers to have access to that database? Thanks. Sam Caro

@ Alcsy

Where is package wizard. There is both Package option, and package + sign option. During the access install, there is an option you have to select (I don't think it selected by default). You find this option under add-ins. However, for various reasons, that option can become disabled (and re-install does not re-enable this). So, to re-enable just go File->options->add ins. Then you see the combo box selected with "com add-ins". Select the GO button, and then you see in the list the developer extensions. Check the box. Now when you go file (to backstage) you see the package option. So, to be clear, there is BOTH options (two of them). One is package application, and the other is Package and sign. To see the package option, you have to do the above steps if you don't see the option. @ Sam Caro - > Do I need to buy any license / install any software in the clients computers to have access to that database? Nothing need be installed on the client side, just a standard browser. In fact, the browser does not even have to be a windows box (tested this on a Linux box running fireFox). Quite much anything with a browser works without having to install any software. Now, licensing is much a different issue and more complex then a post that can be done here. Albert D. Kallal

Edmonton, Alberta Canada

Thanks Albert for your nice explanation regarding using Access in a Browser without addons. I found this site regarding licenses both for internal and external users. Looks expensive. Sam Caro www.sharepointconfig.com/.../indicative-sharepoint-2010-licencing-costs Server + CAL licenses for internal users Internet sites server + licenses for external users License Price SharePoint 2010 Server ~£3100 SharePoint 2010 Standard CAL ~£60 SharePoint 2010 Enterprise CAL* ~£53 SharePoint 2010 Internet Sites Standard ~£7,500 SharePoint 2010 Internet Sites Enterprise ~£27,000

How to market something without ramming the most expensive suite down the throats of consumers,

@ Sam Like I said, pricing is really going to depend on how you do this. You can purchase on-line hosting for $5 to $10 per month for a user. You can purchase Access hosting for less then $100 per month. As far as I know, you can setup anonymous access to your Web site without any cal's needed. (users will be read only). And, you could in theory share one Guest logon. There really 100 different ways to approach this issue. This much comes down to will you go to the trouble to setup your own server and hire the expertise to ensure your company network is safe, or will you purchase some type of hosting like most small business do for their web sites. We have many choices here, and that is good. So, you can host your own if your are worred about your data and where it sits. @If the "Genius" at Microsoft only knew Oh golly gee, should I feed the troll today? Sure, I in a good mood today! The home edition of office includes Excel, word, PowerPoint, one note. Retail is $150 and with new Dell it only $120. That is not even $50 per program. When word perfect came out it was $600+ dollars for one program and things like grammar checking was optional. The paid edition of Google docs is $50 per year, so after 3 years the above edition is cheaper. And, after 5 or 6 years you come up WAY ahead. And, if you want, you can use the free on-line edition of office here: http://office.live.com Hard to beat free don’t you think? In fact, there even a free off-line edition of office if you want. So, I not sure what your concept of cost and value is, but your choices range from web based (free) all the way up to full editions. Now, I probably should not feed the trolls here, but with a choice of free editions of office, I am hard pressed to figure out why you can't see great value in some of the choices you have here. Why would you not choose to use great tools to get your work done when your choice to use those tools have become so affordable? This really comes down to how you value your time. You can spend a whole day to simply walk across you city. Or you can do the same task in less than an hour by driving or taking the bus. Using great tools is the difference between cutting your grass with a dull stick as opposed to having a great comfortable riding lawn mower. Choosing office is really a question as to how you value your time. A trick in life and in business is that by using great tools you make YOUR time valuable. You can't making a living cutting grass with a dull stick, but you can with great lawn equipment. If you have some work to do, office not only lets you cut though your work tasks like a hot knife though butter, but the result is your time becomes more valuable. That why we don't cut grass with dull sticks and that's also why I use office. I value my time and by valuing my time, I make my time more valuable. Albert D. Kallal

Edmonton, Alberta Canada

kallal@msn.com

SharePoint: Too expensive. Time will tell...

Looks like that ACCESS Services need : SharePoint 2010 Internet Sites Enterprise ~£27,000 . * Note the enterprise CAL is additive i.e. this requires EACH USER to ALSO have a standard CAL. SharePoint 2010 Standard CAL ~£60 SharePoint 2010 Enterprise CAL* ~£53 . MS ACCESS 2010 is an excellent product regarding features and price.

I still hope that one day there will be MS Sharepoint 2014 EXPRESS Edition for small workgroups... Sam Caro

Since 2010 has now been released, I've started work on converting our 2007 runtime application to 2010 runtime. Why is the runtime 175 megs now, when 2007 was only 57 megs? This is a big issue for our users, who download our application with the runtime and sql express packaged with it - adding 100 megs to the download size is a major problem. Thanks,

Mike

@ Sam I think most small business will not setup their own web server. In fact, I don't think ANY of my clients host their own web servers now. Yet every single one of my clients has a web site. So, I think purchasing hosting is likely how the smaller business will go, and are doing so now. Few small business will go through the large expense to purchase and setup a web server just for ONE application. This is even the case when talking about non SharePoint. So, most small business will not spring the money to setup and run and maintain that web server. It can take quite a bit skill to correctly expose that small network to the web server AND the wild internet if you don't know what you are doing. This is a big step for smaller business. The in house skill and expertise needed to run and host one's OWN web server is usually beyond the IT ability of a small business. This issue remains regardless of the SharePoint requirements issue. For smaller business, they not going to pay a bunch of people to setup a web server to run one application but will likely continue what they are doing now and that quite much means purchasing some hosting. The same goes for SharePoint, they purchase on-line hosting versions. There is many vendors doing this, including Microsoft. You can choose dedicated hosting, or shared hosting (cloud computing). I would like (love) to see a small business edition of SharePoint. However, even then I find most smaller companies are not prepared to run a web server regardless of what software they plan to run on that web server. So, I don't think this really going to be any different for those smaller business that want to adopt SharePoint. They now for the most part don't want pay to run and maintain that server. So, they will have to purchase on-line hosting just like all of them are doing so now. Albert D. Kallal

Edmonton, Alberta Canada

kallal@msn.com