PC Review


Reply
Thread Tools Rate Thread

Converting 97 mdb to 2003 mdb produces errors with MSysobjects and MsysACES

 
 
Diane
Guest
Posts: n/a
 
      4th Apr 2006
When i am trying to convert my access databases i get an error saying

Record(s) cannot be read; no read permission on 'MSysobjects'

also

Record(s) cannot be read; no read permission on 'MSysACEs'


Any ideas how to get around this?

 
Reply With Quote
 
 
 
 
Douglas J Steele
Guest
Posts: n/a
 
      4th Apr 2006
That's generally a sign of corruption in the original database.

Take a look at what Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm, specifically at
http://www.granite.ab.ca/access/corruption/symptoms.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Diane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When i am trying to convert my access databases i get an error saying
>
> Record(s) cannot be read; no read permission on 'MSysobjects'
>
> also
>
> Record(s) cannot be read; no read permission on 'MSysACEs'
>
>
> Any ideas how to get around this?
>



 
Reply With Quote
 
=?Utf-8?B?S2xhdHV1?=
Guest
Posts: n/a
 
      4th Apr 2006
In addition to a possible corruption problem, Microsoft recommends you not go
directly from 97 to 2003. They recommend a two step process 97 to 2000 then
2000 to 2003.

"Diane" wrote:

> When i am trying to convert my access databases i get an error saying
>
> Record(s) cannot be read; no read permission on 'MSysobjects'
>
> also
>
> Record(s) cannot be read; no read permission on 'MSysACEs'
>
>
> Any ideas how to get around this?
>
>

 
Reply With Quote
 
david epsom dot com dot au
Guest
Posts: n/a
 
      5th Apr 2006
http://support.microsoft.com/?kbid=282357
You receive error messages when you convert Workgroup Information (.mdw)
file to Access 2002

(david)


"Diane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When i am trying to convert my access databases i get an error saying
>
> Record(s) cannot be read; no read permission on 'MSysobjects'
>
> also
>
> Record(s) cannot be read; no read permission on 'MSysACEs'
>
>
> Any ideas how to get around this?
>



 
Reply With Quote
 
Diane
Guest
Posts: n/a
 
      5th Apr 2006
The original database is working fine on an Access 97 platform in a
live enviorment with multi users. any further advice would be gratfully
appricated.

thanks

 
Reply With Quote
 
Douglas J Steele
Guest
Posts: n/a
 
      5th Apr 2006
Just because a database works doesn't mean it hasn't been corrupted: it just
means that the corruption isn't causing any problems.

Converting means that all of the database is inspected, including parts that
may normally not be used. This is the exact same phenomenon as why you can
have an application that works fine, but be unable to convert it to an MDE.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Diane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The original database is working fine on an Access 97 platform in a
> live enviorment with multi users. any further advice would be gratfully
> appricated.
>
> thanks
>



 
Reply With Quote
 
Albert D.Kallal
Guest
Posts: n/a
 
      6th Apr 2006
"Klatuu" <(E-Mail Removed)> wrote in message
news:FF339FC9-2454-417E-A8EC-(E-Mail Removed)...
> In addition to a possible corruption problem, Microsoft recommends you not
> go
> directly from 97 to 2003. They recommend a two step process 97 to 2000
> then
> 2000 to 2003.


I not heard the above advice. Considering that acesss2000, 20002, and 2003
ALL DEFAULT to the Same access 2000 format, I can't see why this step would
be suggested?

I see little, if any advantage of converting to a2000, and THEN to a2003.
Really, can't think of any advantage here....

However, it certainly suggested that when converting form access 1.0, or
2.0, then converting to access97 is a suggested idea, since access 97 did
have some features built in that aid in this converting. Further, access97
has roots *closer* to the very old and original versions.

Funny, but MS even came out with a 2.0 converting add-in for a2003 (so, this
means their is some VERY old applications out that are being converted!!!).

However, I don't believe there is any difference when converting from a97 to
a2000, or a2003.

I am open to suggestions, or being corrected on this issue..but I not seen
it suggested that anything at all is gained by converting to a2000, and THEN
a2003....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Access 97 to Acees 2003 & get conversion Errors eidinger2000 Microsoft Access 1 4th Feb 2010 07:09 AM
a running access 2003 db app produces errors in access 2007 GaryM@optusnet Microsoft Access Queries 0 27th Mar 2008 08:49 AM
Converting 2002 mdb to 2003 mdb produces several MSYS* Tables ??. =?Utf-8?B?d2VtM3Jk?= Microsoft Access VBA Modules 1 31st Mar 2006 02:21 AM
webresource.axd produces errors Peter Strĝiman Microsoft Dot NET Framework 1 14th Dec 2005 03:42 AM
DCDiag produces errors =?Utf-8?B?UkhT?= Microsoft Windows 2000 Active Directory 9 30th Dec 2004 06:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:28 AM.