Notifikationer

Markér alle som læst Log ud

brobaek Nybegynder

29. juli 2002 - 10:53 Der er 28 kommentarer og
1 løsning

Permissions

Jeg har en database LALA.MDB. Jeg har hidtil kunne åbne den uden problemer.

For nylig gav jeg i access en kollega adgang til databasen (Access + fil adgang), men når hun åbner den kommer der en fejlmeddelse :

You do not have the necessary permissions to use the 'S:\00000 RA\BUDGET\LALA.MDB' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

Derefter prøvede vi at logge hende på min NT-maskine (samme konfiguration, blot en anden PC). Det medførte, at min cached NT profil blev slettet.
Hun kunne stadig ikke åbne databasen.

Derefter loggede jeg mig på igen, og vupti... Nu kom samme fejlmeddelse til mig.

Vi har begge fuld control til alle relavante filer (LALA.MDB, Secured.MDW) og er begge admin i databasen.

Det må jo være en NT indstilling, idet vi ikke engang kan logge på databasen.

Please hjælp - det er en forbandet vigtig database...

Synes godt om

terry Ekspert

29. juli 2002 - 11:18 #1

If I understand you correctly this has NOTHING to do with Access's buildt in security but NT permissions etc.

Am I righ tin saying that the dB is on a network drive and the access rights too this drive are through NT security?

If this is correct then you should be able to copy the dB to a local drive (C:) and open it there, have you tried this?

Synes godt om

hossein Nybegynder

29. juli 2002 - 11:57 #2

brobaek
Var det kun dig som brugte databasen indtil nu?
Har I prøvet at åbne den på sammetid?
Du har ikke opdelt databasen, opdel databasen så kan flere brugere åbne den!

mvh Hossein

Synes godt om

brobaek Nybegynder

29. juli 2002 - 12:39 #3

Terry >>
I just tried to copy the db to local drive (C:), but the same error occured.
You are right in, that the access is through NT security, but I can open eg. a text-file with exactly same permissions from the same directory.

It looks like the error occurs "between NT permisions and opening the Access database".

We have for fun tried to remove all permissions from a specific user (therefore, no NT permissions to that user to open the file). That results in another error (saying, that the user have no right to open that file), that the one described above.

Synes godt om

brobaek Nybegynder

29. juli 2002 - 12:40 #4

Hossein >>
Det har ikke noget med en / fler-brugere at gøre. Vi kan slet ikke åbne databasen.

Synes godt om

terry Ekspert

29. juli 2002 - 12:47 #5

What about LINKED tables? If there are linked tables then you also need permissions to these!

Synes godt om

brobaek Nybegynder

29. juli 2002 - 13:05 #6

There is linked tables, but they are in the same folder - and have excactly the same permissions.

Then my VBA-code uses a few external txt-files to save data, but still they are in the same folder, and have the same permissions.

Synes godt om

terry Ekspert

29. juli 2002 - 13:08 #7

Try making a new database and importing ALL objects from the original.

Synes godt om

brobaek Nybegynder

29. juli 2002 - 13:18 #8

When I try to import objects from LALA.mdb then the samme error occur...

Synes godt om

hossein Nybegynder

29. juli 2002 - 13:36 #9

Kan du reparere den?

Synes godt om

brobaek Nybegynder

29. juli 2002 - 14:01 #10

Jeg kan slet ikke åbne db'en.

Synes godt om

terry Ekspert

29. juli 2002 - 14:07 #11

OPEN Access, NOT your dB.
Then in the Tools+database utilities menu choose compact + repair. Now find your dB and press OK.

I have a feeling that your dB is CORRUPT :o) and you may not be able to do much about it. But you do have a backup dont you ?

Synes godt om

brobaek Nybegynder

29. juli 2002 - 14:19 #12

Terry>>
Same error occurs, when I try com compact+repair it...

And, of course (or by chance) I have backups - one, for each chance in version. But all who uses Access security + users displays the same error.

That why I suspect Access security+users to be the cause...

For fun I tryed to change the name of secured.mdw to xxx.mdw - same error occured.

Its funny, aint it ;-) Specially because I quit from this job on wednesday, and the db is result of a lot of work from a lot of people...

Synes godt om

terry Ekspert

29. juli 2002 - 14:23 #13

ARE we using Access security? If you are then you MUST make sure that you ARE using the CORRECT MDW file.

Synes godt om

brobaek Nybegynder

30. juli 2002 - 10:03 #14

Okay - now I tried some funny stuff...

I got a restore of a week old LALA.mdb og Secured.mdw (one week ago the db worked perfect). Then I brought it home to my private PC and tested it...

Same result - error. I've tried to run the one week old db on 3 different computers and same error occur...

HOW CAN THIS HAPPEN ?

I've tried too to put back date in case that there is an date error, but it doesn't help...

Synes godt om

terry Ekspert

30. juli 2002 - 10:09 #15

You say (I got a restore of a week old LALA.mdb og Secured.mdw (one week ago the db worked perfect).)

WHERE DID IT WORK PERFECT? and does it still work perfect where it worked perfect?

Did you put the week old LALA.mdb og Secured.mdw on your private PC or just week old LALA.mdb?

You MUST use both the original files!

Synes godt om

brobaek Nybegynder

30. juli 2002 - 10:35 #16

When I wrote "work perfect" I means, I could open the Access db and use it. As written above currently it does not work in any way - I cant open the db...

Regarding the old files. I took both (old and original) files and placed them on my PC, but where they didn't work...

Synes godt om

terry Ekspert

30. juli 2002 - 10:53 #17

HOW do you open the dB?

If you are using Access security and have a workgroup file (Secured.mdw) then you have to either set this up as the default workgroup file on the PC OR you must open the database using a shortcut. The shortcut actually has to start Access with parameters telling which dB to open and which workgroup file ui sto be used. IF you do NOT do this then Access will be trying to open the default workgroup file.

Synes godt om

brobaek Nybegynder

30. juli 2002 - 11:00 #18

How do I either set up a default workgroup file or start with a shortcut telling which workgroup file to use ?

Synes godt om

brobaek Nybegynder

30. juli 2002 - 11:11 #19

THERE IT WAS.... THANKS SO MUCH TERRY...

Because my cached profile was deleted, information about office paths was deleted (thus that path to the secured.mdw).

I opened MS Access Workgroup Administrator and then it worked perfectly after I redifened the path...

Thanks so much - you really deserve the points...

Synes godt om

brobaek Nybegynder

30. juli 2002 - 11:11 #20

My entire group thanks you too - you have just saved about 3 month of working hours...

Synes godt om

terry Ekspert

30. juli 2002 - 11:16 #21

who do I send a bill to? :o)

Synes godt om

brobaek Nybegynder

30. juli 2002 - 11:33 #22

Well, I just told the others that I used an external consultant to solve the problem, and thereby got 3000 DKK for him...

Unfortunately I just drank them up, celecbrating that it works ;-)

Synes godt om

terry Ekspert

30. juli 2002 - 12:14 #23

:o(

Synes godt om

brobaek Nybegynder

30. juli 2002 - 13:55 #24

Btw - the name LALA.mdb have absolutely nothing to do with Teletubies...

Synes godt om

terry Ekspert

30. juli 2002 - 13:57 #25

LALA Teletubies ?

Synes godt om

brobaek Nybegynder

30. juli 2002 - 18:11 #26

You know, Lala from Teletubies...

Synes godt om

terry Ekspert

30. juli 2002 - 18:20 #27

sorry, no I dont :o(

Synes godt om

susanne_larsen Nybegynder

30. juli 2002 - 18:46 #28

is a cartoon caracter - U havn´t missed much if U havn´t seen it though ;)

Synes godt om

brobaek Nybegynder

30. juli 2002 - 18:47 #29

Agree ;-)

Synes godt om

Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Følg dette spørgsmål

Opret Preview

Access kurser

Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Se alle Access kurser

Flere spørgsmål fra Access kategorien

Titel	Indlæg	Oprettet	Seneste aktivitet
en word dotx fil stilles om til at blive gemt i skyen Af per2edb i Access	9	16/04/202620:11	21/04/202615:43
AI integreret i Access Af per2edb i Access	3	06/04/202610:42	06/04/202612:58
Autonummerering Af hlnviv i Access	2	06/03/202606:24	06/03/202607:48
stigende sortering på et Link felt Af hlnviv i Access	6	03/03/202613:18	04/03/202608:09
Access database udskriver ikke rammer korrekt Af Uvanga i Access	8	18/11/202500:24	18/11/202510:25

Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten

Seneste artiklerRSS