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
|
|||
|
|||
Problem with Access database conversion
Hello
Can anyone help or suggest what might be wrong with the following: I have two MS Access 97 .mdb files that make up a relatively simple database system (one file is the interface, the other holds the data and) that have linked tables. I am running MS Access XP (2002) on my PC and wish to upgrade the database, as I now unable to modify the structure, create queries etc. I have converted both files to Access 2002 version, but when I open the main form of the database and try to browse the records, I get a 'Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience' message. Can anyone tell me whether this is to do with the conversion of the database or might it be with coding. Could the data have become corrupted. Any help would be greatly appreciated. Thanks Mark |
#2
|
|||
|
|||
Did you receive any error messages when you performed the conversion?
Chances are, there is something wrong with the database that has no yet shown up under A97. See article: Converting from Access 97 at: http://members.iinet.net.au/~allenbrowne/ser-48.html The section entitled "Conversion Issues" gives 5 steps for sorting it out by decompiling, and a link to follow if the corruption is not resolved. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mark" wrote in message ... Hello Can anyone help or suggest what might be wrong with the following: I have two MS Access 97 .mdb files that make up a relatively simple database system (one file is the interface, the other holds the data and) that have linked tables. I am running MS Access XP (2002) on my PC and wish to upgrade the database, as I now unable to modify the structure, create queries etc. I have converted both files to Access 2002 version, but when I open the main form of the database and try to browse the records, I get a 'Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience' message. Can anyone tell me whether this is to do with the conversion of the database or might it be with coding. Could the data have become corrupted. Any help would be greatly appreciated. Thanks Mark |
#3
|
|||
|
|||
djweioud ewldjskapchjdsl adls fjkdsla jkdlfs jdf slkqj |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conversion Problems | Katherine R | New Users | 11 | December 19th, 2004 12:38 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Problem accessing SQL Server in upsizing wizard | Edward | General Discussion | 1 | July 5th, 2004 06:00 AM |
Please Help, The database is in an unexpected state; Microsoft Access can't open it. | Gary A. Hollenbeck | New Users | 2 | May 20th, 2004 05:42 PM |