Rights Problem when Importing DB (Access 97)

[Avlan]

Hi.

I have an odd problem: I am testing databases for conversion to Office
2003, and I received a database from an Office in another country. It
was secured, but I got the right MDW-file and the admin user and pass
and I got it working; I can now view and design the whole thing. I
imported the whole thing into a new database, so the database should be
without security (gave full rights to 'users'-group and cleared the
admin-pw). It seems fine, untill I try to open it in Access 2003: It
gives the same, old error "The user account doesn't have permissions to
convert or enable this database. etc.".

If I go to access 97 (in which the DB opens without a problem) and I
make (yet again) a new, blank database, and try (yet again) to import
the data/queries etc. from the (already unsecured) DB, all of a sudden
I get "You don't have the necessary permissions to use the
"p:\PATH\PATH\OBJECT.MDB" object. etc."

When I make a more or less blank database in Access97 and try to
convert it to Access2003 there is no problem (so it's not in the
MDW-files?)

Now, I've fiddled around with them MDW-files, so I'll try from scratch
again, but it seems odd to me that I can open a access97-file without
any sign of security but I cannot import data from that database in a
blank access97-database... Anyone any ideas how come?

PS the DEFAULT path for the mdw-files are:
ACCESS97: C:\WINDOWS\SYSTEM32\SYSTEM.MDW
ACCESS2003: C:\Documents and Settings\%user%\Application
Data\Microsoft\Access\system.mdw

correct?

Thx

 

[Joan Wild]

Hi.

I have an odd problem: I am testing databases for conversion to Office
2003, and I received a database from an Office in another country. It
was secured, but I got the right MDW-file and the admin user and pass
and I got it working; I can now view and design the whole thing. I
imported the whole thing into a new database, so the database should be
without security (gave full rights to 'users'-group and cleared the
admin-pw).

You need to do that in the correct order. Open it and login as the
owner/administrative user. Give full permissions to all objects (don't
forget the Database Object) to the Users Group. Then using the workgroup
administrator, rejoin the standard system.mdw. Open Access (no login) and
create a new database and import all the objects from your old mdb. Now the
Admin user will own all the objects.

 

[Avlan]

Doesn't work. I can open the database as admin, set every 'check' I can
for every table/query/form etc. and after that it idd opens without pw,
also in the original system.mdw, but when I then make a blanc DB and
want to import (get external data > import) I still get the message
that I do not have rights on the object...

 

[Avlan]

I just found that I do not have permissions to view permissions on the
'database' (In User And Group Permissions), neither users nor admins...
That is odd, it seems something went wrong in setting the database
without security.. However, I did everything possible. Is it possible
that I should set yet another group with full rights and stuff?

 

[Avlan]

AND with the first system97.mdw it now ALSO gives me this limitation...
I locked myself out, somehow. What's the standard user that 'logs on'
to Access97 when you start it?

 

[Joan Wild]

Doesn't work. I can open the database as admin, set every 'check' I can
for every table/query/form etc. and after that it idd opens without pw,
also in the original system.mdw, but when I then make a blanc DB and
want to import (get external data > import) I still get the message
that I do not have rights on the object...

You are missing the Database Object. In 97, you have to click on the
Objects combobox and scroll up to see it. Give the Users Group full
permissions on it.

 

[Avlan]

Hmm somehow, I can't give the 'modify' right on the database to users
(or any group). It's greyed out. I can see, however, that I (admin) are
the owner of the database, but I cannot change ownership either (its
greyed out too).

How can I be the owner but apparently, I still do not have all the
security rights?

 

[Avlan]

Right.

I have tested it with a clean database, and the rights appear the same,
so that should not be the problem. I found out he didnt take every
permission I had set, so I redid it, and it looked better. Still a
security problem though.

I noticed it had linked tables, so I also stripped all the other
..mdb-files in the directory from security but STILL it can not import
the database in a new, blanc file.

Are you SURE I only have to set 'users' to full control and not for
instance 'admin' (since it has made a custom admin with full rights)?

THx ;-)

 

[Joan Wild]

Right.

I have tested it with a clean database, and the rights appear the same,
so that should not be the problem. I found out he didnt take every
permission I had set, so I redid it, and it looked better. Still a
security problem though.

I noticed it had linked tables, so I also stripped all the other
.mdb-files in the directory from security but STILL it can not import
the database in a new, blanc file.

Are you SURE I only have to set 'users' to full control and not for
instance 'admin' (since it has made a custom admin with full rights)?

Yes I am sure. However your other message said you could set full
permissions on all objects; you need to login as a user that can do this
(member of the Admins Group or the owner - check the owner tab to see what
user owns the database object)