A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem with Access database conversion



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2004, 12:15 PM
Mark
external usenet poster
 
Posts: n/a
Default 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  
Old September 24th, 2004, 12:25 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default

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  
Old September 26th, 2004, 04:46 AM
xionglina
external usenet poster
 
Posts: n/a
Default



djweioud ewldjskapchjdsl adls fjkdsla jkdlfs jdf slkqj


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.