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
|
|||
|
|||
Linking Access 97 tables to Access 2002 tables
My company is in the middle of XP deployment, including
Access 2002 upgrades. Part of the people have Access 97, part Access 2002. My problem is that the Access 1997 users of an Access 97 form cannot write back to the Access 2002 database tables. Getting the 'db in unrecognizable format'. However, Access 2002 users can write to an Access 97 db, but not vice versa. Any ideas? |
#2
|
|||
|
|||
Linking Access 97 tables to Access 2002 tables
"michaelwoodard" wrote in
: However, Access 2002 users can write to an Access 97 db, but not vice versa. Any ideas? Leave the back end in A97 format, and distribute A2000 and A97 front ends as required. Tim F |
#3
|
|||
|
|||
Linking Access 97 tables to Access 2002 tables
As Tim mentions, the backend data mdb file needs to be in the lowest version
you are using. Although it was written for Access 2000, the information at http://support.microsoft.com/default...b;en-us;296179, also applies to Access 2002 and 2003. Good luck. Sco M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+ Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo Miscellaneous Access and VB "stuff" at www.ScoBiz.com "michaelwoodard" wrote in message ... My company is in the middle of XP deployment, including Access 2002 upgrades. Part of the people have Access 97, part Access 2002. My problem is that the Access 1997 users of an Access 97 form cannot write back to the Access 2002 database tables. Getting the 'db in unrecognizable format'. However, Access 2002 users can write to an Access 97 db, but not vice versa. Any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Acess 2002 Service Pack 3 | J. Haney | General Discussion | 2 | July 29th, 2004 12:59 AM |
Access 97 to 2002 problem | Harry J | General Discussion | 4 | July 15th, 2004 11:52 PM |
Cannot open tables in Access 2002 | Sriram | General Discussion | 3 | July 11th, 2004 07:12 AM |
Access 2003 / Visio 2002 Conflict | SP | General Discussion | 0 | June 23rd, 2004 05:02 AM |
Need help with Tables Design and Relationships | Tom | Database Design | 24 | May 19th, 2004 06:51 PM |