Helloo
I have an Access2003 database in which users with Access 2003, a client with Access2007 . But Office 2003 will no longer be available.
What do we possibly wrong?
Helloo
I have an Access2003 database in which users with Access 2003, a client with Access2007 . But Office 2003 will no longer be available.
What do we possibly wrong?
when you first open a. mdb with Acc2007 I think he wonders whether the new one. accdb format will ... Although trite, but I assume that's what makes it NOT (otherwise you have your solution already ...).
Otherwise if you have the new Office 2007 already installed SP1. Office 2007 CD is a bad beta.
Otherwise, it might also be that the references from Access2007 to higher versions which must be included in Office 2003 will no longer be available. Time in the VBA editor (ALT + F11) in Tools -> check references.
If the client is no longer with Access2007 in the DB, you can see this, however, normally open with 2003. Would the references should be changed but the DB does not work permanently?
According to MS it should not be a problem:
If separate locking files are maintained for both Office Access 2007 files and files that are created in earlier versions of Access, it is possible to have databases named Db1.mdb and Db1.accdb open in Office Access 2007, at the same time without creating any locking file conflicts. This is because two different locking files (. Ldb and. Laccdb) are created. So, it is possible for one user to open at. Mdb file in Office Access 2007, while another user opens the same. Mdb in an earlier version of Access. In this case, both sessions use the same. Ldb locking file.
Is it a back-end data or the application itself?
In the latter case, of course, a simultaneous opening with A2003 and A2007 are not possible!
How should probably go? Would the references should be changed but the DB does not work permanently? No, if the references automatically goes to Office 2007, they can be the (theoretically) just as well again for Office 2003.
Bookmarks