Office 2021 Release Date (Rumors) - Any changes with Access? (1 Viewer)

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:56
Joined
Feb 19, 2002
Messages
42,970
However, even with improvements, ODBC is a technology for intermediate and expert level Access developers.
I disagree. Programmers should not be DBA's. That makes it a little hard to develop Access apps with ODBC BE's but not impossible. For any of my larger clients, I wouldn't ever be given access to the production database and for many of them, I wouldn't even be given access to the test database. I would have to go through the DBA to have any change made. You just start with Jet/ACE but use good client/server techniques. Once the schema is fairly stable, hand it off to the DBA and then switch the be using the linked tables manager to the new test BE in SQL Server. If the developer has done his job well, NOTHING needs to change.
 

Users who are viewing this thread

Top Bottom