Linking 2003 database to 97 Access data

[tom]

Apparently, I am able to link a 2003 Access database
to data in a 97 Access database with no adverse
effects. Am I missing something here?

 

[Douglas J. Steele]

Nope. In fact, that's a recommended approach when upgrading is a gradual
process. Split the application into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Convert the front-end to the new version of
Access, and distribute it to those users for whom it's appropriate. Have all
users link to the same back-end, in the "original" version of Access. Once
everyone's converted, you can convert the back-end.

(NOTE: Any changes to the front-end should always be made in the oldest
version, and then converted to the newer version(s).)

 

[tom]

Nope. In fact, that's a recommended approach when upgrading is a gradual
process. Split the application into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). Convert the front-end to the new version of
Access, and distribute it to those users for whom it's appropriate. Have
all users link to the same back-end, in the "original" version of Access.
Once everyone's converted, you can convert the back-end.

(NOTE: Any changes to the front-end should always be made in the oldest
version, and then converted to the newer version(s).)

Unfortunately, I dont think data can be updated with
this arrangement. I wanted to use the new frontend
with the 97 database before committing. It all seems
to work well on a test updated DB, but that is not
under fire of real time conditions.

 

[Douglas J. Steele]

The data should be updatable. If it's not, make sure that users still have
the appropriate access to the folder where the MDB is located.

 

[aaron.kempf]

good stuff.

I dont think that MDB is reliable enough for any real-world use.

I would reccomend Access Data Projects; and a move to SQL Server.

It is a superior product; you're not keeping your eggs in a basket
without a database engine. It's not that Access doesn't have a good
database engine; it just doesn't have any engine.

It's obsolete. Randomness like this is a way of life when you're
working with MDB.

-Aaron