Yes.. We are still using access 97...

[samcoinc]

This just happened today.. (I was totally surprised it worked..) Hell - I was surprised it has been working in windows 10..

 

[GPGeorge]

That's a rock solid mdb, sir!

 

[The_Doc_Man]

I guess in a way you are lucky. None of the library upgrades killed your DB, because I know that some of the Windows upgrades did some things to A LOT of the .DLL files. Not to mention (if you used any) the .OCX files.

 

[samcoinc]

99% of the backends are now postgresql.. we have been slowly migrating things to our ERP and some java..

Access keeps plugging away though..

 

[samcoinc]

We found a way to install office 97 on windows 7.. (there were some hoops to jump though - found online instructions..)

Then 7 -> 10 -> 11 upgrades.

I tried fresh installing office 97 on windows 10 but failed.

sam

 

[samcoinc]

The BE has nothing to do with the FE as long as you are using Access as the FE. As long as the RDBMS supports ODBC, Access can use it. Do NOT confuse Access the RAD tool with Jet and ACE the desktop database engines.

sure - we would probably not use access again. So - code is just for reference.

(although I am using access 2021 to interface between our erp and our internal applications..)

sam

 

[samcoinc]

You seem to be sneering at a piece of software that has served you for 25 years Not sure where you'll find something better

Not sneering. Just not something we want to do anymore. It did serve us very well. We were able to do some amazing things. We just can't keep it up anymore. Plus integrating it into our erp wasn't a perfect solution. The 10 year plan is to put the stuff that we developed in house - into our erp. It certainly not going to be as flexible - but sometimes we try to program to every possible contingency.

we don't need to.

sam

 

[samcoinc]

Not sure where you'll find something better

We have not...