Go Back   Access World Forums > Access World > The Watercooler

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2019, 05:06 PM   #1
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 649
Thanks: 79
Thanked 76 Times in 76 Posts
vba_php is on a distinguished road
from version 1992 to version 2016

Who here has been around since the birth of access? I remember working with access 1992 when it came out, and that was just out of curiosity and how I became interested in programming. I made follow up calls for my father's financial planning seminars using automated dialing in access 1997, which he coded and set up for me. I've used 92, 97, 2000, 2003, 2007, 2010 and 2013 although I'm currently working in 2010.

What is everyone's favorite features of access and their least favorites? What do you wish they would bring back that has been deprecated? What do you think was a bad idea to introduce?

I remember the ribbon being introduced in 2007 and I thought that was a terrible idea. If I remember right, that didn't last long, and they transitioned to a similar look that we have now. I believe the data macros were introduced in 2010? and I've never been a fan of those. I think the macro creation interface also changed somewhere between 2003 and 2010.

My biggest gripe about converting one version to another was the fact that I would constantly get the error "unrecognized database format" after opening an accdb file with the newer version and then opening it again with an older version. I never did figure this one out, so as a workout around I took note of the problem and just used the appropriate version to open accdb files and develop them. I would be interested to hear if anyone else encountered this and was able to fix it. Perhaps it had something to do with the system objects and their structures in the newer version that came out at that time?

vba_php is offline   Reply With Quote
Old 11-11-2019, 07:54 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,394
Thanks: 13
Thanked 4,124 Times in 4,056 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: from version 1992 to version 2016

There was no "1992":

https://www.fmsinc.com/MicrosoftAcce...y/features.htm
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 11-11-2019, 08:16 PM   #3
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,748
Thanks: 93
Thanked 1,724 Times in 1,595 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: from version 1992 to version 2016

My first version of Access was 2.0 under Win 3.1, which was an OK setup.

Before that, I used Paradox for DOS, which I liked, But when Borland created Paradox for Windows, I feel that they screwed the pooch by leaving out events that even Windows itself would have recognized. I felt, after side-by-side comparison, that Access was the superior product, and I have never looked back.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 11-11-2019, 11:12 PM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,351
Thanks: 115
Thanked 3,108 Times in 2,826 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: from version 1992 to version 2016

The first version of Access was 1.0 which I still have on a VM



I also have VMs for all other versions of Access. In my opinion, A97 was the first mature version and that A2003 together with A2010 were the most stable and feature rich versions. I still use A2010 as my main development platform though I have Office 365 as well.

As for the ribbon, its much the same as it was when introduced in A2007 except it can now easily be minimised/hidden. I've grown to like it though not the hurdles of creating new ribbons.

The unrecognised database format error occurs whenever an app with a new 'structural' feature is opened in a previous version. For example if you tick the option to allow bigint support in A2016/2019/365 then open it in A2010/2013
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)

Last edited by isladogs; 11-11-2019 at 11:50 PM.
isladogs is offline   Reply With Quote
The Following 2 Users Say Thank You to isladogs For This Useful Post:
Tera (11-12-2019), vba_php (11-12-2019)
Old 11-11-2019, 11:42 PM   #5
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 1,007
Thanks: 73
Thanked 52 Times in 45 Posts
MickJav will become famous soon enough
Re: from version 1992 to version 2016

Quote:
Originally Posted by The_Doc_Man View Post
My first version of Access was 2.0 under Win 3.1, which was an OK setup
Same here no inteli sence made things interesting lol
__________________
All open code examples and free projects are only available from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Creating a new project then add styles to it download open code example from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is offline   Reply With Quote
Old 11-12-2019, 02:09 AM   #6
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 649
Thanks: 79
Thanked 76 Times in 76 Posts
vba_php is on a distinguished road
Re: from version 1992 to version 2016

Quote:
Originally Posted by pbaldy View Post
Paul, it says version 1.0 was released in Nov 1992 so yes technically there was. I just didn't say "version 1.0".

Quote:
Originally Posted by isladogs View Post
I also have VMs for all other versions of Access.
VM, as in Virtual Machine?

Quote:
Originally Posted by MickJav View Post
Same here no inteli sence made things interesting lol
The IDE's I have installed on my laptop are for Visual Studio 2019, Dreamweaver, PHP's Eclipse, Python and Android Studio, and all of them contain the intellisense feature.
vba_php is offline   Reply With Quote
Old 11-12-2019, 06:23 AM   #7
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,245
Thanks: 29
Thanked 285 Times in 271 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: from version 1992 to version 2016

Access 2000 or Office 2000 not sure, that version of Northwind is still my go to.


AccessBlaster is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing MS Access database (2016 Version) Rakesh935 Forms 6 08-14-2018 05:15 AM
New features in Access 2016 version 1710 isladogs General 9 11-16-2017 09:34 AM
best version ridonc General 2 03-02-2015 04:57 AM
Access full version or Access Runtime version for deploying the front-end? docxyz General 3 11-24-2014 11:51 PM
What version to go for ? BeeJayEff General 14 09-15-2013 03:11 PM




All times are GMT -8. The time now is 02:25 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World