Mark Simms
marksimms at verizon.net
Mon Feb 28 18:54:02 CST 2011
Nope, but heard it is the typical Microsoft roll-out....a high, high wall of undocumented "features" and surprises. Some are finding this feature quite useful, but only after climbing up that wall. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of Rusty Hammond > Sent: Monday, February 28, 2011 1:57 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access and SQL Server > > Reading your decriptions of what you are doing, sounds like a good fit > for the new Access Sharepoint services. I'm curious if anyone on the > list has used the service. > > From what I understand, with Access 2010 and the Access Sharepoint > service, you can create your app in Access, then post it to Sharepoint > and your forms, reports, queries, etc... Are converted to Sharepoint > pages. One caveat seems to be that you have to use Access Macro's and > not any vba for it to work. Anyone have any experience with this yet? > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Monday, February 28, 2011 11:47 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access and SQL Server > > > Are any of your developing full blown ACCESS/SQL Server applications > for clients? > > I am just beginning to do this. I have three applications that need to > access data from the internet. > > Real (old) men use SQL Server and HTML, written in notepad. I am not a > real man. Though I am old! ;) > > Real young men use SQL Server and C#. I aspire to be young (again). > Physiologically, that ain't happening. I am learning a ton of C# and > SQL server stuff but I am not yet to the point of doing full on > database > applications in C#. > > Given the above, while I aspire to C# there is a lot to learn before I > am going to write an app in C# which I have to maintain (and write > reports for). Someday but not this month. > > This month I hope to actually place in production two Access > applications, both running under a runtime environment, which Access a > SQL Server database over the web. > > >If so what type of an app is it? > > One app is a time sheet / reporting application for a non-profit. This > organization has a handful of part time employees who meet with parents > of children with disabilities. The purpose is to provide information > about resources available to the parents. > > So individuals go to people's homes, discuss their child's disabilities > and provide the parents referrals to organizations which can actually > assist the parent in dealing with the disabilities. > > These employees need to document every visit. They have to enter very > basic name/address info for the parents, and then enter some records > child to that parent info with referrals, literature etc. > These employees will enter their time sheets from their homes or a > local > wi-fi hot-spot from their laptop. > > Management of this non-profit will then run reports about what work was > done by the organization. > The organization has to report to the money guys (grants) and to the > IRS > IIRC. > > >If so what type of an app is it? > > The next application I am developing is a volunteer database for the > local prison. They do various training programs and need to maintain a > list of volunteers, a list of projects, which volunteers are working on > which projects, and the date/times of the project meetings. Stuff like > that. They will have a couple of people actively maintaining the > database - adding / deleting / updating records. There will be a > handful of people just looking at reports. > > The people using the database will access it from their home computer > or > laptop from a wi-fi hot-spot.. > > >If so what type of an app is it? > > And finally (for now) I go into the prison for various reasons. Some > volunteers may check certain inmates out. In order to do so I have to > fill out a specific piece of paper for each inmate I am checking out, > every time I want to check that inmate out. The paper lists my name / > address, the prisoner's ID number, and a list of exact places and start > / stop date / times where I will be taking the prisoner. I can take > them to church, or to an AA meeting, or a restaurant etc. There is > space on the form for three locations / dates / times. > > So the next application allows me to maintain a list of inmates that I > might routinely check out, a list of locations (addresses) and allow me > to fill out this paperwork with a few mouse clicks and then turn that > into a PDF and fax it off to the prison. > > ATM it will be only me using it, but if it is actually faster than > manually filling in the paper and faxing it, then other volunteers who > check out prisoners may want to use it. > > > So there you have my three ACTIVE Access / SQL Server projects. Each > of > these is being designed > from scratch to: > > 1) Use SQL Server for the data store. > 2) Use Hamachi VPN to get at the SQL Server > 3) Use a runtime > > And because of the first two above, to be usable over the internet. > > John W. Colby > www.ColbyConsulting.com > > On 2/28/2011 7:56 AM, Tony Septav wrote: > > Hey All > > Thanks > > I have got to try out Stuart suggestion for updating stored > procedures > in SQL Server using ACCESS. > > I am not finding any significant differences in speed when using > ACCESS tables and queries versus > > SQL Server tables and pass through queries, I assume that is because > I > am doing my testing on my > > local machine and not on a network (or Web). > > > > Are any of your developing full blown ACCESS/SQL Server applications > for clients? If so what type of > > an app is it? > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > ********************************************************************** > WARNING: All e-mail sent to and from this address will be received, > scanned or otherwise recorded by the CPI Qualified Plan Consultants, > Inc. > corporate e-mail system and is subject to archival, monitoring or > review > by, and/or disclosure to, someone other than the recipient. > ********************************************************************** > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com