473,890 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2007

Hi:
Any quick opinions on Access 2007?
Has anyone got this to coexist with Access 2003?
Thanks
Ira
Dec 14 '06 #1
5 3911
Yes. You can do a custom install of Office 2007.
Instruct it to use a different folder, and not remove previous versions.

Only problem so far is that every time you switch versions, the installer
runs again to register the current version. The A2007 installer takes long
enough that I usually go and make a coffee. Not sure if that's good for my
health (getting up more often) or bad (more coffee and stress.) :-)

Access 2007 contains some seriously useful new functionality, e.g.:
- rich text for comments.
- built-in calendar popup for date fields.
- right-click combos to edit the underlying data.
- totals at bottom of datasheets.
- Search box in horizontal scrollbar.
- a download to export PDFs.
- ability to create a template database containing the setup you want to
include in every new database.

It also solves a number of existing issues, e.g:
- Trusted Locations solves A2003 security dialogs.
- MouseWheel.
- Email addresses get "mailto:" prefixed in hyperlink fields.
- Percent fields recognise percents.
- Warns if you create a field named Name, Date, Month, Year.
- Command buttons can show picture + caption.
- AutoFill in datasheets removed.
- Several filter bugs fixed.
- Improved Excel imports.

There's lots of other stuff that may or may not be useful:
- Multivalued fields and attachments
- Layout view
- Split forms
- Ribbon and Navigation Pane
- Tabbed layout of open forms.
- Modify database schema while using the data (datasheets.)
- Embedded macros with error handling.

And naturally, there's lots of bugs in anything with this much new stuff in
it, e.g.:
- Assigning a specific printer to a report doesn't work.
- OldValue is reported incorrectly for multivalued fields.
- Ribbon and minibar functionality don't work for rich text in subforms.
- Some other stuff is broken, e.g. text box set to:
=[Form].[RecordsetClone].[RecordCount]
- Interface issues, e.g. ribbon items still disabled after resetting on code
error.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ira Solomon" <is******@solom onltd.comwrote in message
news:j2******** *************** *********@4ax.c om...
>
Any quick opinions on Access 2007?
Has anyone got this to coexist with Access 2003?
Thanks
Ira

Dec 15 '06 #2
- Assigning a specific printer to a report doesn't work.
- OldValue is reported incorrectly for multivalued fields.
Allen,

Thanks for that great report on A2007! The new features look
interesting, but two of the bugs you mentioned kind of worry me. We
have several sticker printers in our factory and, of course, I must set
up those reports as specific printers. Is there a work-around?

If we are talking about the same feature, I use the OldValue as
part of an Audit Trail scheme I have in place.

Thanks again,
Hank Reed

Dec 15 '06 #3
As a workaround for the printers issue, you could try:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html
What that does is to allow the user to select one of their printers, and
have the report remember to go to that by default. Haven't tested it, but it
relies on previously existing technology, and should work in A2007.

OldValue will give you a problem for your audit log, but only if you use
multi-valued fields. You probably won't want to use those.

We are uncovering new bugs in A2007 each day. Today's is that the Spelling
Checker makes a mess of your words in a rich text field that contains a
carriage return. Others are preparing lists of bugs as well.

At this stage, my recommendation would be to wait until Service Pack 1 is
released for Office 2007 if reliability is important to you. Of course
there's no news of that yet, but I would not expect it before Q2-2007 at the
earliest. If you enjoy new technology for its own sake and don't mind
battling the bugs, then go for it.

Ultimately it will be a great product, but it's not yet.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Hank" <ha********@aol .comwrote in message
news:11******** *************@j 72g2000cwa.goog legroups.com...
>- Assigning a specific printer to a report doesn't work.
- OldValue is reported incorrectly for multivalued fields.

Allen,

Thanks for that great report on A2007! The new features look
interesting, but two of the bugs you mentioned kind of worry me. We
have several sticker printers in our factory and, of course, I must set
up those reports as specific printers. Is there a work-around?

If we are talking about the same feature, I use the OldValue as
part of an Audit Trail scheme I have in place.

Thanks again,
Hank Reed

Dec 15 '06 #4
"Allen Browne" <Al*********@Se eSig.invalidwro te in
news:45******** *************** @per-qv1-newsreader-01.iinet.net.au :
Only problem so far is that every time you switch versions, the
installer runs again to register the current version. The A2007
installer takes long enough that I usually go and make a coffee.
Not sure if that's good for my health (getting up more often) or
bad (more coffee and stress.) :-)
Have you checked if MichKa's A97 trick might have an analog in the
A2K7 MSI installer scripts?

http://trigeminal.com/usenet/usenet019.asp?1033

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 15 '06 #5
Haven't tried yet, David.

At this stage I'm spending way to much time with finding workarounds for the
new bugs, but I am interested in the results if someone does try this.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...
"Allen Browne" <Al*********@Se eSig.invalidwro te in
news:45******** *************** @per-qv1-newsreader-01.iinet.net.au :
>Only problem so far is that every time you switch versions, the
installer runs again to register the current version. The A2007
installer takes long enough that I usually go and make a coffee.
Not sure if that's good for my health (getting up more often) or
bad (more coffee and stress.) :-)

Have you checked if MichKa's A97 trick might have an analog in the
A2K7 MSI installer scripts?

http://trigeminal.com/usenet/usenet019.asp?1033

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Dec 16 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

37
5286
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end development tool? Let's get serious. Microsoft continues to publish numerous articles and videos on how you...
27
45586
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same height as they were in previous versions or will they be the "ribbon" style that takes up a huge portion of the screen? Also when I use Access 2007 to open an Access 2003 database that has custom menu bars they display as they did in Access...
1
11556
prn
by: prn | last post by:
Hi folks, I'm relatively new to Access, but I seem to have drawn the short straw, so I have the assignment for my workplace of looking for problems/inconsistencies in migrating applications to Access 2007 from previous versions. We don't have a lot of Access applications, but even a dozen or so can be an interesting challenge. I have loaded a few that were created in Access 2003 into Access 2007 and all of the ones I have tried have come up...
5
3598
by: ARC | last post by:
Hello, A user posted a reply to a post of mine regarding the fact that Access 2007 would be free, or maybe I misunderstood? All I could find on Microsoft's site was information regarding the Access 2007 developer extensions and the runtime being a free download. But what about the full Access 2007 install? Surely that is not free? I couldn't find info on this. Possibly someone can clear this up? Many Thanks in advance,
17
7681
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my...
4
5491
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available in versions 3.0 or later of the class. However, also just found out that the new Rich Text property in Access 2007 ALSO does not support full text justification! This seems incredible, that MS would create a brand new application, and not...
8
28662
by: ajos | last post by:
hi frnds, im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception. to verify this error ive made a simple database in jsp(just to check if my mysql is working smoothly otherwise) which access' the username.....but in the process im getting a error--> java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) i have...
10
4586
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the opportunity to test some new features of Access2007 before actually 'stepping over'. First thing that troubles me of course is 'the ribbon', but my question now is about speed. I opened one of my Access 2000-apps in Access 2007. Speed and...
9
4502
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be slower.
1
4724
by: ARC | last post by:
I think I made a major blunder, and now Access 2007 no longer opens. I made the mistake yesterday of using the "test" option in wise installer for my Access 2007 runtime app. It actually installed the Access 2007 Runtime SP-1 (I did have full office 2007 SP-1, however). I didn't notice a problem until I had to use Access 97. Once I re-opened Access 2007, I got the usual message about the Installer (as it tries to repair every time you...
0
9976
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9815
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11215
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10802
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9618
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8008
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6035
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4259
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3267
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.