When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
2) What are the major reasons for upgrading to 2002 ?
13  2562 
On 06 Feb 2004 16:51:42 EST in comp.databases.ms-access, "Noesis
Strategy" <no****@nomail.com> wrote: When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
I'm not sure, I have 2003 somewhere but no time to look at it, I would
assume at least the same level of backward compatability as 2002 gives
in that you can at least save as an earlier version. MS did promise
that Jet 4.0 and later would not change file format so all versions
could read all versions but alas 2000 can't open a 2002 format file.
2) What are the major reasons for upgrading to 2002 ?
Do you mean 2002 or 2003?
A lot of people I know will choose the version "MS -1" so that
whatever MS has as the current version, they use the one before it,
this is to give the latest version time to mature and stabilize in the
hands of others, there's an old saying "The pioneers are the ones with
arrows in their backs". I also know of consultancy companies that
stick to this rule 100%, I wouldn't want them to consult for me as
this shows a lack of knowledge of product quality and IMHO consultancy
in general, any fool could give that level of consultancy, you could
buy the book that they read for less than their fees and get the same
level of advice.
There has been in the past, a pattern to some MS products where a
release cycle went bad-good-bad-good, e.g. Windows 95 releases, the
base was bad, a was better, b not so good, c was better, interestingly
the Knight Rider style boot screen went in different directions on
each release, perhaps leaning toward the good or the bad :-)
The same sort of thing happened with Access:
1 bad so I hear (I didn't start until 2)
2 - good - brilliant compared to 1 - introduced rushmore as well.
95 bad -wouldn't pee on it if it was on fire - never improved
97 good - considered the bugfix for 95
2000 bad -started really bad but improved a bit
2002 good -I would consider a bugfix for 2000
2003? Following the pattern, should be bad, the MS -1 philosophy works
for this version, the same wouldn't for some previous ones. Personally
I would hang around here and see who ends up like the areforementioned
pioneers, there was a time when I always wanted to use the latest and
greatest, etc but experience has taught me otherwise.
I backed off 95 before it was too late, I wish I could say the same
for 2000, got burnt on that one.
--
A)bort, R)etry, I)nfluence with large hammer.
I did in fact mean upgrading to 2003.
The user interface looks very dated on 2002. While this may seem minor,
getting users to adopt our new knowledge management procedures entails
having a user interface that draws them to the system. I was hoping 2003
had an improved appearance.
"Trevor Best" <bouncer@localhost> wrote in message
news:rp********************************@4ax.com... On 06 Feb 2004 16:51:42 EST in comp.databases.ms-access, "Noesis
Strategy" <no****@nomail.com> wrote:
When I ordered my new laptop, Sony didn't offer Access 2003 in its
bundles.Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have
allthe office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
I'm not sure, I have 2003 somewhere but no time to look at it, I would
assume at least the same level of backward compatability as 2002 gives
in that you can at least save as an earlier version. MS did promise
that Jet 4.0 and later would not change file format so all versions
could read all versions but alas 2000 can't open a 2002 format file.
2) What are the major reasons for upgrading to 2002 ?
Do you mean 2002 or 2003?
A lot of people I know will choose the version "MS -1" so that
whatever MS has as the current version, they use the one before it,
this is to give the latest version time to mature and stabilize in the
hands of others, there's an old saying "The pioneers are the ones with
arrows in their backs". I also know of consultancy companies that
stick to this rule 100%, I wouldn't want them to consult for me as
this shows a lack of knowledge of product quality and IMHO consultancy
in general, any fool could give that level of consultancy, you could
buy the book that they read for less than their fees and get the same
level of advice.
There has been in the past, a pattern to some MS products where a
release cycle went bad-good-bad-good, e.g. Windows 95 releases, the
base was bad, a was better, b not so good, c was better, interestingly
the Knight Rider style boot screen went in different directions on
each release, perhaps leaning toward the good or the bad :-)
The same sort of thing happened with Access:
1 bad so I hear (I didn't start until 2)
2 - good - brilliant compared to 1 - introduced rushmore as well.
95 bad -wouldn't pee on it if it was on fire - never improved
97 good - considered the bugfix for 95
2000 bad -started really bad but improved a bit
2002 good -I would consider a bugfix for 2000
2003? Following the pattern, should be bad, the MS -1 philosophy works
for this version, the same wouldn't for some previous ones. Personally
I would hang around here and see who ends up like the areforementioned
pioneers, there was a time when I always wanted to use the latest and
greatest, etc but experience has taught me otherwise.
I backed off 95 before it was too late, I wish I could say the same
for 2000, got burnt on that one.
--
A)bort, R)etry, I)nfluence with large hammer.
The Help interface of Access 2003 is not nearly as user-friendly as in
Access 2002. The "improvements in security" have proven to be more of an
irritant than an actual improvement in security (does it really help you to
have to click to open every database that isn't "electronically signed",
even your own, because "this database may contain code that can do
damage"?). Other than that, there are some improvments, most of them
office-wide, not Access-specific, to collaboration, and corporate and
enterprise tools (e.g., the interface to SharePoint).
Larry Linson
Microsoft Access MVP
"Noesis Strategy" <no**@none.com> wrote in message
news:40***********************@news.rcn.com... I did in fact mean upgrading to 2003.
The user interface looks very dated on 2002. While this may seem minor,
getting users to adopt our new knowledge management procedures entails
having a user interface that draws them to the system. I was hoping 2003
had an improved appearance.
"Trevor Best" <bouncer@localhost> wrote in message
news:rp********************************@4ax.com... On 06 Feb 2004 16:51:42 EST in comp.databases.ms-access, "Noesis
Strategy" <no****@nomail.com> wrote:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.Recently, I have begun to design Access databases using an copy of
Access2002 from my previous laptop. It works fine, but I would like to have allthe office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003
files?
I'm not sure, I have 2003 somewhere but no time to look at it, I would
assume at least the same level of backward compatability as 2002 gives
in that you can at least save as an earlier version. MS did promise
that Jet 4.0 and later would not change file format so all versions
could read all versions but alas 2000 can't open a 2002 format file.
2) What are the major reasons for upgrading to 2002 ?
Do you mean 2002 or 2003?
A lot of people I know will choose the version "MS -1" so that
whatever MS has as the current version, they use the one before it,
this is to give the latest version time to mature and stabilize in the
hands of others, there's an old saying "The pioneers are the ones with
arrows in their backs". I also know of consultancy companies that
stick to this rule 100%, I wouldn't want them to consult for me as
this shows a lack of knowledge of product quality and IMHO consultancy
in general, any fool could give that level of consultancy, you could
buy the book that they read for less than their fees and get the same
level of advice.
There has been in the past, a pattern to some MS products where a
release cycle went bad-good-bad-good, e.g. Windows 95 releases, the
base was bad, a was better, b not so good, c was better, interestingly
the Knight Rider style boot screen went in different directions on
each release, perhaps leaning toward the good or the bad :-)
The same sort of thing happened with Access:
1 bad so I hear (I didn't start until 2)
2 - good - brilliant compared to 1 - introduced rushmore as well.
95 bad -wouldn't pee on it if it was on fire - never improved
97 good - considered the bugfix for 95
2000 bad -started really bad but improved a bit
2002 good -I would consider a bugfix for 2000
2003? Following the pattern, should be bad, the MS -1 philosophy works
for this version, the same wouldn't for some previous ones. Personally
I would hang around here and see who ends up like the areforementioned
pioneers, there was a time when I always wanted to use the latest and
greatest, etc but experience has taught me otherwise.
I backed off 95 before it was too late, I wish I could say the same
for 2000, got burnt on that one.
--
A)bort, R)etry, I)nfluence with large hammer.
On Sat, 07 Feb 2004 19:14:57 GMT in comp.databases.ms-access, "Larry
Linson" <bo*****@localhost.not> wrote: The Help interface of Access 2003 is not nearly as user-friendly as in
Access 2002. The "improvements in security" have proven to be more of an
irritant than an actual improvement in security (does it really help you to
have to click to open every database that isn't "electronically signed",
even your own, because "this database may contain code that can do
damage"?). Other than that, there are some improvments, most of them
office-wide, not Access-specific, to collaboration, and corporate and
enterprise tools (e.g., the interface to SharePoint).
Now you mention it Larry, I do remember this irritating security thing
akin to opening a word or Excel doc with macros, any way to turn it
off so I'll know where to go next time I look at it?
Even better, how to electronically sign an app, I can't imagine how
I'd distribute an application in 2003 if it presented every user with
a question like this, it's bad enough sending people an attachment and
their mail program warns them that some files contain viruses, they
then mail be back and ask why I sent them a virus, arrrrrrg!
<rant>
I find more and more MS apps are getting too namby pamby, the other
day I went to edit a login script on a DC, the files in c:\winnt were
hidden, click her to show files, etc, ferchrissakes I'm logged into a
server as an administrator, stop treating me like a plebe.
</rant>
--
A)bort, R)etry, I)nfluence with large hammer.
Trevor Best previously wrote: Now you mention it Larry, I do remember this irritating security thing
akin to opening a word or Excel doc with macros, any way to turn it
off so I'll know where to go next time I look at it
For your own machine you can set security level to low as in Excel.
Or you can say that you trust your own apps (I.e on your own machine)
Even better, how to electronically sign an app, I can't imagine how
I'd distribute an application in 2003 if it presented every user with
a question like this, it's bad enough sending people an attachment and
their mail program warns them that some files contain viruses, they
then mail be back and ask why I sent them a virus, arrrrrrg!
AIUI No way round this.
Either the user puts up with not-trusted messages or you buy an electronic
certificate from one of the trusted sources (having proved to them that
you CAN be trusted and paying them 200 dollars for the privilege)which the
user can say is trusted.
Peter Russell
ru***@127.0.0.1 (Peter Russell) wrote in
news:me**********************@russellscott.btinter net.com: Trevor Best previously wrote: Even better, how to electronically sign an app, I can't imagine
how I'd distribute an application in 2003 if it presented every
user with a question like this, it's bad enough sending people an
attachment and their mail program warns them that some files
contain viruses, they then mail be back and ask why I sent them a
virus, arrrrrrg!
AIUI No way round this.
Either the user puts up with not-trusted messages or you buy an
electronic certificate from one of the trusted sources (having
proved to them that you CAN be trusted and paying them 200 dollars
for the privilege)which the user can say is trusted.
What do those cost, and how long do they last before you have to pay
again?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
As an update I have come across this article: http://office.microsoft.com/assistan...HP010397921033
&CTT=98
If you click on the ShowAll option on this page there is some info near
the bottom which provides a way of starting Access without the warnings,
using an automation script.
Certificates from Thawte or Verisign cost 399/400 dollars for 2 years.
Peter Russell
David W. Fenton previously wrote: ru***@127.0.0.1 (Peter Russell) wrote in
news:me**********************@russellscott.btinter net.com:
Trevor Best previously wrote:
Even better, how to electronically sign an app, I can't imagine
how I'd distribute an application in 2003 if it presented every
user with a question like this, it's bad enough sending people an
attachment and their mail program warns them that some files
contain viruses, they then mail be back and ask why I sent them a
virus, arrrrrrg!
AIUI No way round this.
Either the user puts up with not-trusted messages or you buy an
electronic certificate from one of the trusted sources (having
proved to them that you CAN be trusted and paying them 200 dollars
for the privilege)which the user can say is trusted.
What do those cost, and how long do they last before you have to pay
again?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Sun, 8 Feb 2004 18:23 +0000 (GMT Standard Time) in
comp.databases.ms-access, ru***@127.0.0.1 (Peter Russell) wrote:
[electronic sigs] AIUI No way round this.
Either the user puts up with not-trusted messages or you buy an electronic
certificate from one of the trusted sources (having proved to them that
you CAN be trusted and paying them 200 dollars for the privilege)which the
user can say is trusted.
Cheers Peter.
--
A)bort, R)etry, I)nfluence with large hammer.
On Sun, 08 Feb 2004 19:08:14 GMT in comp.databases.ms-access, "David
W. Fenton" <dX********@bway.net.invalid> wrote:
[electronic sigs for Access app] What do those cost, and how long do they last before you have to pay
again?
I would assume one would last for the life of the application so once
rolled into an MDE it won't expire as the MDE shouldn't change
although I expect your right to put it into an updated one will expire
(these companies wouldn't stay in business long if it didn't, bit like
selling ever lasting light bulbs).
--
A)bort, R)etry, I)nfluence with large hammer.
ru***@127.0.0.1 (Peter Russell) wrote in
news:me**********************@russellscott.btinter net.com: As an update I have come across this article:
http://office.microsoft.com/assistan...ssetID=HP01039
7921033 &CTT=98
If you click on the ShowAll option on this page there is some info
near the bottom which provides a way of starting Access without
the warnings, using an automation script.
So, in order to avoid the security warning, they recommend using a
VBScript, executed by the Windows Scripting Host?
And they have the nerve to call this *security*?
Pretty clearly, MS is forcing digital rights management on all of
us.
I think it's pretty clear to me I won't be using that version of
Access for anything, ever.
Certificates from Thawte or Verisign cost 399/400 dollars for 2
years.
Ridiculous. Absolutely ridiculous.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Trevor Best <bouncer@localhost> wrote in
news:1b********************************@4ax.com: On Sun, 08 Feb 2004 19:08:14 GMT in comp.databases.ms-access,
"David W. Fenton" <dX********@bway.net.invalid> wrote:
[electronic sigs for Access app]
What do those cost, and how long do they last before you have to
pay again?
I would assume one would last for the life of the application so
once rolled into an MDE it won't expire as the MDE shouldn't
change although I expect your right to put it into an updated one
will expire (these companies wouldn't stay in business long if it
didn't, bit like selling ever lasting light bulbs).
The architectural limitations listed in the article Peter Russell
cited are pretty severe. They mean I'd have to re-architect every
single Access application I've ever created and do huge numbers of
search and replace operations (to replace public variables with
class module members).
I guess I'm annoyed that I'm committed to a system that was
improperly designed in the first place, VBA.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"David W. Fenton" <dX********@bway.net.invalid> wrote in
news:Xn**********************************@24.168.1 28.74: The architectural limitations listed in the article Peter Russell
cited are pretty severe. They mean I'd have to re-architect every
single Access application I've ever created and do huge numbers of
search and replace operations (to replace public variables with
class module members).
I guess I'm annoyed that I'm committed to a system that was
improperly designed in the first place, VBA.
Pete Barnes: "This means the end of civilization as we know it."
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
On Feb 09 2004, 12:20 pm, "David W. Fenton" <dX********@bway.net.invalid>
wrote in news:Xn**********************************@24.168.1 28.74: So, in order to avoid the security warning, they recommend using a
VBScript, executed by the Windows Scripting Host?
Well, they are not recommending it per se, they just happen to use VBScript
in the example. You might as well write a generic Access app launcher in VB
that will do it, which will also be useful for other things such as front
end auto updating. So it's an extra annoyance, but hardly more.
--
remove a 9 to reply by email This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: wolftor |
last post by:
1) Is there a free runtime version of Access available that is more recent
than the one for Access 2000?
2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?...
|
by: Frederick Noronha \(FN\) |
last post by:
---------- Forwarded message ----------
Solutions to Everyday User Interface and Programming Problems
O'Reilly Releases "Access Cookbook, Second Edition"
Sebastopol, CA--Neither reference book...
|
by: Aidan Tobin |
last post by:
Hi,
I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much...
|
by: Lauren Wilson |
last post by:
Hi Folks,
I have a widely distributed Access 200 Application. I must retain my
ability to support users who are still on Access 2000 and Access 2000
Runtime. However I also need to upgrade my...
|
by: Uwe Range |
last post by:
Hi to all!
A customer of mine told me some days ago that her IT-people told her
ACCESS would not be such a good idea for continuing with our project,
because Access will not be continued in the...
|
by: RM |
last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported
a number of web sites. Installed VS .Net 2003 on Friday and now
all web sites using .Net & MS ACCESS get this strange error upon open.
...
|
by: gerr |
last post by:
Visual studio 2003 "HTTP/1.1 500 Internal Server Error" when trying to
create a new Asp.net site with Visual Studio 2003 on localServer XP
Pro/IIS 5.1. Everything worked fine prior to installing...
|
by: yolenman |
last post by:
Hello -
This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge.
I'm working with a small limousine...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |
