Access 2.0

[LMB]

Hi,

Our church purchased a program called Church Windows . They are trying to
import records from another database CDMS. Apparently, Church Windows was
made with Access 2.0 and we need Access 2.0 on the computer to do the
export/import. Since Access 2.0 is so old, is it available for download
somewhere? I still have Office 97 Pro but can't find my Office 2.0. I did
find an old floppy disk that has Microsoft Office Proffessional Disk
1-setup. This would have been my backup copy but I didn't write how many of
how many. I am thinking it had 4 disks? Any ideas or suggestions?

Thanks,
Linda

 

[Allen Browne]

Hi Linda. Access 97 can read (and therefore import) an Access 2 mdb.

 

[LMB]

Thanks....We will give it a try. The company said we needed Access 2.0.
Ha!, I found my old Windows 3.1 floppys.......there are 6 of them.

 

[Chris Mills]

Thanks....We will give it a try. The company said we needed Access 2.0.

Ha!, I found my old Windows 3.1 floppys.......there are 6 of them.

Allen is always correct, in this case that A97 or later can certainly
handle/convert Access2.0.

However, I would not like to use a later version of Access to MAINTAIN an
earlier version, and you seem to imply that your system is (and will remain
for the forseeable future) in Access 2.0.

Another perplexing thing is that you say you purchased (or obtained) this
Access 2.0 system. In that case, I would doubt that you have the security
and/or capacity to maintain it yourself, that would be up to your supplier?
Alright it's a church, but you can't do much without an Access expert in your
congregation!

I think, it's easy enough to convert from Access 2.0 to a later version, and
certainly you should, but not unless you have someone experienced in both
systems.

I hate to be a wet blanket, but I have here Office 4.3 Professional which
consists of 24 floppy disks! I can't remember whether individual components
(just Access) might have been sold separately. I have (ONE) customer known to
be still using Access 2.0, and as far as I'm concerned Access 2.0 is and was
just fine, even lovable. The trouble is, you'll have a hard time finding
anyone, even your best-programmer friend, who wants to service Access2.0
nowadays (excepting Allen of course, which makes two of us!)

The last reason is the most compelling to upgrade. Although I love Access2.0,
I have to advise customers I might not be available in future, and who else
they gonna find?

Also, this was written by someone else. Even if you have rights to modify it,
and you are the best guru in the world, trying to understand someone else's
code can be somewhere between difficult and near-impossible.

For a single-time record import, it's quite possible that someone suitably
experienced, could import from CDMS to Access97(or later) and thence to
Access2.0, using just the in-built Access capabilities. But I don't know
precisely. By-and-large, imports not available directly are done through "text
files" or "CSV files"(comma-delimited files), which virtually every system
supports. Such imports also require careful checking and possible fix-ups, on
less than (say) 500 records it may be just as easy or economic to re-type
them.

HTH
Chris

 

[Rick Wannall]

Wow! I didn't know that there still WAS anyone who would speak kindly of
Access 2.0. Hell, I can barely find serious developers who speak kindly of
Access, never mind the version.

I'm with you. It think Access was amazing starting with 2.0, and I probably
could do most of what I actually do with it still. (Not that later versions
aren't great or don't do anything significant in addition, just that most of
what's done in a data-based application could be done even with 2.0.)

Delighted to see that in this group there are people who would say such a
thing as "far as I'm concerned Access 2.0 is and was just fine, even
lovable".

Hear, hear!

 

[Chris Mills]

Wow! I didn't know that there still WAS anyone who would speak kindly of

Access 2.0.

Although, as I get older and forget more of Access, the "Intellisense Help" of
later versions sure does come in handy )

Did I really say lovable? Oh alright then.

(before any later-version defender gets too upset, I should say I may have a
selective memory on useful functionality, and there are many arguable aspects
between versions)

Cheers
Chris

Thought for the day: Access 2.0 has NO REGISTRY SETTINGS!!!!!

 

[Allen Browne]

Yes, nostalgia aside, there were problems with A2 that were never fixed:
- bookmark bug never fixed,
- Y2k dates never fixed properly (at least for people with non-US date
formats),
- no intellisense,
-16-bit thunking,
- workarounds through wizards,
- no way to determine if a form was at a new record,
- no Date type (had to use Variant),
- inconsistent dates formats in VBA (code did not work across regional
settings),
- no Boolean type (had to use Integer),
- no Undo method for forms or controls (had to SendKeys "{Esc}"),
and the list could go on.

Of couse, some of the bugs in Access 2 are *still* there in the latest
versions:
- Some queries still return wrong results.
- Once you have begun entering a new record, it still returns a spurious
bookmark (actually the bookmark of the record you visited most recently.)
- We still lose data when we close a form:
http://allenbrowne.com/bug-01.html

 

[Chris Mills]

Ah,
Regardless of merits or otherwise, yes A2.0 assistance IS still available in
this newsgroup!

Timewarps are REAL!

Cheers
Chris

 

[Rick Wannall]

Well, okay, but other than those...

 

[Tony Toews]

Wow! I didn't know that there still WAS anyone who would speak kindly of
Access 2.0. Hell, I can barely find serious developers who speak kindly of
Access, never mind the version.

Then those "serious" developers are arrogant *rseholes.

I'm with you. It think Access was amazing starting with 2.0, and I probably
could do most of what I actually do with it still. (Not that later versions
aren't great or don't do anything significant in addition, just that most of
what's done in a data-based application could be done even with 2.0.)

Delighted to see that in this group there are people who would say such a
thing as "far as I'm concerned Access 2.0 is and was just fine, even
lovable".

Hear, hear!

Agreed.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Marcin]

Hi,

Our church purchased a program called Church Windows . They are trying to
import records from another database CDMS. Apparently, Church Windows was
made with Access 2.0 and we need Access 2.0 on the computer to do the
export/import. Since Access 2.0 is so old, is it available for download
somewhere? I still have Office 97 Pro but can't find my Office 2.0. I did
find an old floppy disk that has Microsoft Office Proffessional Disk
1-setup. This would have been my backup copy but I didn't write how many of
how many. I am thinking it had 4 disks? Any ideas or suggestions?

Thanks,
Linda

===========================================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM:http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net

==========================================================================

 

[Pat Hartman\(MVP\)]

I still keep the A2.0 help files around.