Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 18th, 2006, 09:21 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default Access 2007 - wtf?

Folks,

   Has anyone been using Access 2007? It looks EXACTLY like FileMaker. WTF?! I don't see a good future for access developers. Time to move on to VB, C# and ASP.Net with SQL Server 2005.

   Yikes!

What do you think?


mmcdonal
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old December 18th, 2006, 03:02 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

It was time to move on 5 years ago. ;)

Bob

 
Old December 18th, 2006, 03:25 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Yeesh, I heard that. I am good with SQL Server 2000 in Access, Query Analyzer and Enterprise Manager, and have some Programming Databases and SQL 2005 with VB and C# books, so I guess I will hit those between semesters here. I mean really, what were they thinking?!



mmcdonal
 
Old December 18th, 2006, 05:47 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Okay, Mike, What is Filemaker?

Was hoping when MS depracated JET we would be getting an improved sort of Access with a "lite" version of SS in place of JET.

 
Old December 19th, 2006, 05:19 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

I wouldnt run to another db to quick just yet... the client I am working for is just starting to use 2k3, every other client I have worked for has been "even less up to date than that", is about as good as I can put it. Still come across 97 businesses!

For me, it is only the IT businesses themselves that are really affected by this. No one else has time to retrain the staff they have just trained.
 
Old December 19th, 2006, 08:17 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

FileMaker is a bland datasheet type of database like Access. It is hard to do anything in it, so it languishes. Access 2007 went to a FileMaker interface, so it looks like a spreadsheet, and you really have to know how to hide things in order to get it to work like a client interface. Basically it looks like MS decided to dumb down Access to cater to the 95% of users who just create spreadsheets in it. So the developers have to fight with the interface.

I wasn't talking about going to another database, just another architecture. Instead of client server with Access, moving to client server with .Net, and web based applications.

Speaking of web based applications, don't let anyone tell you SharePoint is good for a database interface. It is kludgy and not nice at all.

Anyway, I will take a run at Access 2007 and see what it is about, but I think the hand writing is on the wall with this one. MS had a good product in PhotDraw, but they gutted it and put it in Word and PowerPoint. I think they are gutting their data architecture and parsing it out throughout office. Office 2007 creates files in a native XML format, too. Like anyone needs XML on the desktop. And what user really ports data across platforms to need XML? (he asked rhetorically...) Yeesh, MS.

mmcdonal
 
Old December 19th, 2006, 08:32 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

I hear you big time on XML, not everything is a web-destined... seems pointless frankly... help (the very able and dont need help) 0.05% of the population out by putting the other 99.95% out.
But when is anybody actually going to get "user" use out of this... should be a add-in or feature, not a standard! This is the kinda thing that happens when they draw the requirements from IT people though, rather than the actual users!
Looks on the face of it as big a step as from 95-97, but I feel it is possibly a backwards step in some regards. I like the intuitivity in the UI though but that said, I havent spent a great deal of time on it yet, so I may be wrong!

Incidentally, have you done the xls rename to zip yet? If not, make an xls file (2007 only) and then rename the file as .zip, now open it in winzip... interesting, I hope you'll agree!
 
Old December 19th, 2006, 08:45 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I tried the zip thing. Oh dear, that's not good.

Well, I think MS believes everything is SharePoint bound. the problem is that while WSS is good for collaboration (and it is, believe me) it is not a good archive. And the old Office docs work just as well. Probably the xml supports the SPS search feature.

mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending email in access 2007 maxgrunt BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 1 July 31st, 2008 09:21 PM
Access 2007 JohnBoy VB.NET 2002/2003 Basics 1 March 16th, 2008 09:33 PM
Access 2007 Ribbons? bgnetman Access VBA 2 October 30th, 2007 11:03 AM
Access 2007 won't let me select a ribbon bgnetman Access 0 October 23rd, 2007 12:04 PM
Access 2007 security warning tang_moor Access 1 February 8th, 2007 08:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.