- Local time
- Today, 15:05
- Joined
- Feb 19, 2002
- Messages
- 46,993
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.However, even with improvements, ODBC is a technology for intermediate and expert level Access developers.