If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
splitting database w/ different versions
Not long ago I posted a question about splitting a database whose users have
either Access 97 or Access 2003 on their PC. I was told (by Douglas J. Steele and Tom Wickerath...thank you, gentlemen!) that this was the way to go. They advised to do the split with the Access 97 version. I understand that...the question is how to also split off the Access 2003 version from the "same" data. Or does splitting it once mean that all other users are now working on a split database? Also, they said that any changes to the front end should be made on the older version, then converted to the newer one on the appropriate PCs. How is that done? I've never split a database before, let alone one that is shared by multiple users with different versions. A step-by-step outline or similar simple instructions would be greatly appreciated! Thanks in advance. |
#2
|
|||
|
|||
splitting database w/ different versions
After splitting the Access 97 version, you will be left with two MDBs, the
'back-end' data MDB, containing only tables, and a 'front-end' application MDB, containing everything else - queries, forms, reports, and modules - plus links to the tables in the 'back-end' data MDB. Make an Access 2003 version of this 'front-end' application MDB, but leave the 'back-end' data MDB alone - Access 2003 can link to Access 97 tables. So you now have two versions of the 'front-end' application MDB, one in Access 97 and the other in Access 2003, both linking to the same tables in the same Access 97-format 'back-end' data MDB. Just give each user a copy of the appropriate 'front-end' application MDB - Access 97 users get the Access 97 version, Access 2003 users get the Access 2003 version. To create an Access 2003 version of the 'front-end' application MDB, just open it in Access 2003 - Access 2003 will ask whether you want to convert or open it, choose convert. -- Brendan Reynolds "Susan" wrote in message ... Not long ago I posted a question about splitting a database whose users have either Access 97 or Access 2003 on their PC. I was told (by Douglas J. Steele and Tom Wickerath...thank you, gentlemen!) that this was the way to go. They advised to do the split with the Access 97 version. I understand that...the question is how to also split off the Access 2003 version from the "same" data. Or does splitting it once mean that all other users are now working on a split database? Also, they said that any changes to the front end should be made on the older version, then converted to the newer one on the appropriate PCs. How is that done? I've never split a database before, let alone one that is shared by multiple users with different versions. A step-by-step outline or similar simple instructions would be greatly appreciated! Thanks in advance. |
#3
|
|||
|
|||
splitting database w/ different versions
Thanks, Brendan...I guess I was thinking it more difficult than it really is.
I'll try to get to it today, and let you know how it came out (tho' I think I'll try it on a copy, first!) Susan "Brendan Reynolds" wrote: After splitting the Access 97 version, you will be left with two MDBs, the 'back-end' data MDB, containing only tables, and a 'front-end' application MDB, containing everything else - queries, forms, reports, and modules - plus links to the tables in the 'back-end' data MDB. Make an Access 2003 version of this 'front-end' application MDB, but leave the 'back-end' data MDB alone - Access 2003 can link to Access 97 tables. So you now have two versions of the 'front-end' application MDB, one in Access 97 and the other in Access 2003, both linking to the same tables in the same Access 97-format 'back-end' data MDB. Just give each user a copy of the appropriate 'front-end' application MDB - Access 97 users get the Access 97 version, Access 2003 users get the Access 2003 version. To create an Access 2003 version of the 'front-end' application MDB, just open it in Access 2003 - Access 2003 will ask whether you want to convert or open it, choose convert. -- Brendan Reynolds "Susan" wrote in message ... Not long ago I posted a question about splitting a database whose users have either Access 97 or Access 2003 on their PC. I was told (by Douglas J. Steele and Tom Wickerath...thank you, gentlemen!) that this was the way to go. They advised to do the split with the Access 97 version. I understand that...the question is how to also split off the Access 2003 version from the "same" data. Or does splitting it once mean that all other users are now working on a split database? Also, they said that any changes to the front end should be made on the older version, then converted to the newer one on the appropriate PCs. How is that done? I've never split a database before, let alone one that is shared by multiple users with different versions. A step-by-step outline or similar simple instructions would be greatly appreciated! Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Record(s) cannot be read; no read permissions on 'table'. after splitting database | Krazy Katt | General Discussion | 2 | November 6th, 2005 03:33 PM |
HELP! CANNOT CONNECT TO SQL SERVER | Glint | General Discussion | 19 | May 9th, 2005 02:47 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Currentuser and splitting a database | hackmn_g | General Discussion | 1 | April 29th, 2005 08:45 AM |
splitting a database | Dennis | Running & Setting Up Queries | 2 | January 2nd, 2005 06:27 AM |