Remove security from 97/implement 2000

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I have searched through groups.google.com for many days on
this and nothing seems to work for me. Up to a month ago,
all of our Office product were Office 97 but we need to
update to at least Office 2000 soon. So I'm trying to
upgrade our databases from Access 97 to Access 2000. This
is proving to be a major problem. The problem is that our
Access 97 databases have security implemented on them. So
I chose to upgrade two databases that only two users use
and those two users don't use any other databases so
nothing else could get messed up. I read all up on how to
get unsecured data out of the databases and it seemed to
work (by creating the unsecured database and them
importing all objects). After I accomplished this, I
upgraded the databases. Fine and dandy. But for some
reason some of the coding doesn't work anymore when trying
to run it. It tells me "Run-time error '3027': Cannot
update. Database or object is read only." At that point it
gives me an option to debug or end. I try to debug and
look at the code and as best I can tell it looks fine. If
I go to a backup copy of the Access 97 database that still
has security implemented it works fine. So I'm guessing I
need to implement security on this Access 2000 database,
but I can't. I implement security following directions
from other posts on newsgroups and the security goes in
fine, but when I try to import database objects from the
supposedly unsecured Access 2000 database that is giving
me the problem, it tells me that I don't have permissions
to access the database. How can this be cause it is
already unsecured?

I'm totally frustrated and at whitts end. If anyone can
help me with this I'd greatly appreciate it.

Do I need to clarify the issue?

Charles
 
some of the coding doesn't work anymore when trying
to run it. It tells me "Run-time error '3027': Cannot
update. Database or object is read only." At that point it
gives me an option to debug or end. I try to debug and
look at the code and as best I can tell it looks fine.
Click to expand...

Well, you must show us the lines of code, & say what line the error occurs
in. Otherwise there is no way of knowing what is happening.

HTH,
TC
 
I figured it out finally. It was getting to a point in the
code where it was trying to convert a .txt file to a .dat
file. Apparently, .dat files are not recognized by
Access2000 so I had to add them into the registry at
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0
\Engines\Text\DisabledExtensions

Once I did this everything worked fine. I don't understand
why Access97 would work fine and Access2000 would not. I
never had to do this with Access97. I thought a newer
version would have encompassed "more" not less.

Oh well, the problem is fixed.

Microsoft Knowledge Base Article - 245407
 
Back
Top