A Saturn V rocket is 40+ year old technology. Can it still be used to get to earth orbit and provide the astronauts with...

Addicted -

Although I do wonder how your solution could be EASALY Used out of the Box to allow your database to be collocated on instances around the world with a...

excuse me for being thick, but lets say for instance that I have a 50 million row table of sales transactions....do I assume that in your world of JET this...

Answer me this, who is going to maintain your work when you are no longer around to do so? Are you training others to provide support? Do you expect others...

The OP seems to be looking for justification of his personal decisions regarding architecture.

Sure, stick with this system. It will work. Will anyone else be able to help support...

https://support.microsoft.com/en-us/kb/303528

ARTICLE: How to keep a Jet 4.0 database in top working condition

You'll have to ask Garry Robinson, or consult his book(I...

WHEN TO USE:

SQL SERVER

========

* For Network or non-Network Databases larger than 5 Terabytes and 25 Billion rows - use SQL Server

* For Network Databases smaller than 5 Terabytes and 25...

Well. The issue is, especially in technology, words and terms do have meaning and in order for us to communicate well, we need to understand the shared meaning. NOSQL is...

One big complaint I would have in parting is that the users need to have physical access to the DB stores. Sure you can play games and obfuscate, etc.... but...

To put this in perspective, you can make this as simple or complicated as you want.

You're in control.

If you want a 15 billion row (contained within 1500 *.MDB files) MS-Jet...

You've put tons of time and effort into this and it sounds like you've done amazing work.

However, tons and tons of the work you've done is just replicating the functionality...

I think my main concern would be maintainability. YOU understand what you've done, and it seems to work well for your organization. I hate to use the Bus example, but...

David Webb, no everyone does not have to be off because ODBC database connections are not persistent.

And although Win32 Perl ODBC module (by David Roth) allows UNLIMITED OPEN CONNECTIONS, I...

I think it is important to ask questions such as whether it is more prudent to use:

MS-Access, MS-Jet Engine(w/o MS-Access), SQL Server Express, or SQL Server

for any particular database...