Jim Dettman
jimdettman at verizon.net
Mon Feb 28 13:27:47 CST 2011
Very limited (I fired it up once to date). You must develop your app as a web database and not all Access features are available. And a existing database won't always convert to a web enabled database either, so it's not as cut and dry as one would think. There are restrictions on the data types, control events, primary keys (all must be longs). There is also an off-line caching mode that can be used, which so far looks messy (here's your replication replacement). But that may be my lack of understanding. It's come a very long way over what was offered in A2007, but I think it still has another version to go before I'd want to try anything with it. This release feels like Access 1.1 (Access 2007 + SharePoint being 1.0), which introduced a host of new features (and made Access really usable for the first time), but didn't become solid until Access 2.0. And I haven't checked the licensing yet, but I've heard a couple grumble that it's pricey. Unless I had hundreds of users, I think I would stick with a TS setup and Citrix and just run with one version of an app. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond Sent: Monday, February 28, 2011 01: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