Windows SharePoint Services Overview

re: Windows SharePoint Services Overview

Alan Cossey — Sat, 13 Jan 2007 16:41:40 GMT

Re differing numbers of records showing depending on whether I am online or offline with Office Live, setting the RecordSource property of the main form to "SELECT DISTINCTROW Customers.* FROM Customers;" rather than basing it on the table itself ensures that only one record for each customer appears for the main form and allows the form to be updateable. Alan Cossey

re: Windows SharePoint Services Overview

Marcy Gaynes — Thu, 11 Jan 2007 19:52:47 GMT

I have not seen a response as to what replaces replication in 2007? I have many clients using this feature. I also have user-level security on most systems. Am I going to be stuck in 2003 forever? Could someone from Microsoft please respond? Thanks!

re: Windows SharePoint Services Overview

Alan Cossey — Mon, 08 Jan 2007 15:59:12 GMT

Access 2007 and Office Live. I am trying out Office Live Premium with Access 2007 and there looks to be loads of potential here. However, there are some strange things happening. One is that if I set up a form/subform based on two lists in OLP, I get the expected no. of records showing if I take the data offline, but not if I run it online. For example, I have two customers. Customer #1 has two branches; customer #2 has one branch. The main form is based on the Customer list and the subform on the Branches list with linked master and child fields based on the unique fields in those two lists, i.e. the OLP-generated ID's.

When I look at the form with it online to OLP, I see three records, the first two being identical and which are for customer #1. However, if I take the data offline, I get two records as you would expect in Access, i.e. Customer #1 has one main record with the expected two records in the subform. Though I need to sort out the above, what I would most like to know is where best to discuss Access 2007 working with Office Live / Sharepoint. It seems that Microsoft are restricted to telling people they are pleased that they are trying out Access 2007 with Office Live when questions are posted rather than answering any questions. I hope there is a suitable place to discuss this sort of stuff with interested people (Microsoft and/ or other people) as there is a huge potential for using Access 2007 across, but there is next to no support for those of us trying it out (at least that I can find).

re: Windows SharePoint Services Overview

Robert A Williams — Sun, 24 Dec 2006 01:30:28 GMT

I too am a freeky user, and have run our Company records on unique Access databases designed by me in Office 2007 Beta then B2TR. It is one hell of an improvement on the last major use in Office pro 95.

However, I am limited to SQL 2005 as my "Server" and data collection point. Why don't MS set up Sharepoint to run on XP? Many of us who don't need to go to sophisticated servers could well use such a development on our internal LAN setup.

Think about the really small guy for once in a while.

re: Windows SharePoint Services Overview

Andrew Maltas — Fri, 01 Dec 2006 22:17:33 GMT

I have developed a field service system for logging engineers calls in access2000 with a sql2000 back end.

I am under increasing pressure to provide customer data on the web, so i would like some way of converting forms and reports to web pages that are limited to particular users(some form of user login) Is this possible in access 2007? Also is there such a thing as an Access 2007 runtime license and would it work on windows 2000?

re: Windows SharePoint Services Overview

Toby Getsch — Thu, 16 Nov 2006 13:19:53 GMT

Any chance your team can get some demo videos up on Channel 9? channel9.msdn.com/.../In_the_Office

re: Windows SharePoint Services Overview

Suntisuk Lorkrilert — Mon, 18 Sep 2006 12:50:53 GMT

Execuse me to post here, A small feature I think Access miss is Vertical Label that arrange character from bottom to top. Please consider. Thank you,

Suntisuk

re: Windows SharePoint Services Overview

luca — Thu, 14 Sep 2006 09:22:50 GMT

first of all, I am not a developer, but a "smart" final user... I love Access as I can do things with it without having to call my IT dpt for a 6 months specs/planning/testing for creating simple applications... on the other hand I am more more frustrated with the following points:

- size limitation (2GB)

- file size growing as soon as you start playing around (compacting is a pain!)

- can't always copy and paste SQL from other applications

- MOST IMPORTANT: I can't group my queries/tables/etc in a proper manner. I end up having quite complex DB a lot of queries and I can only organise them by numbering, impossible to categorise them. The favourites functionality is sxxt! is this finally solved? ciao Luca

re: Windows SharePoint Services Overview

Chris Maina — Wed, 13 Sep 2006 21:50:03 GMT

Am I to understand from the above that there will be no replication in Access 2007 (Nigil Scott AUg25th). Replication the one reason we use Access. Internet replication over VPN is vital for portables. Also I have been trying to relicate to an http address but there isa bug in Access 2003 that causes this fail. I am hoping to find this function alive and well in Access 2007. Replication and Internet replication being database to database without the need for servers is a winning feature. Is this functionality in 2007, if not what replaces it?

As our company considers the future based on this anything you can tell us about this would be most useful Chris

re: Windows SharePoint Services Overview

Tim — Fri, 08 Sep 2006 22:09:31 GMT

Could Transact-SQL and store procedures be added to the next version of Access?