Avatar billede Per Juniormester
21. februar 2018 - 14:51 Der er 13 kommentarer og
2 løsninger

Access / flere brugere

Hej

jeg ar oprettet en database i Access 2016 som flere bruger på samme tid
når bruger nr 2 åbner kommer nedenstående meddeles

hvis brugeren klikker 10 gange forsvinder meddelsen
brugeren skal kun slå op

When attempting to open a database object in Design view, or when trying to save design changes to a database object, you may encounter this error message. Access requires an exclusive lock on the database to make design changes on some object types, since other users may attempt to use the objects. This error indicates that Access has not obtained an exclusive lock on the database. If you change the name of a table, or its field definitions, while someone has the table open, this will result in a serious error for the other user.  Therefore, you must have exclusive access to the database while you attempt to update the object. When you release your exclusive lock, other users will again be allowed to use the database.
It is recommended you implement source code control for development efforts by using the Microsoft Visual Source Safe Add-in for Microsoft Access. As an alternative, you could distribute local working copies of the database to each developer.

der der noget jeg har gjort forkert.

m.v.h.
Per Aarup-Jensen
Avatar billede terry Ekspert
21. februar 2018 - 15:17 #1
The message seems to indicate that you are trying to make design changes to the dB at the same time as other users are using it.
Is that correct?
Avatar billede terry Ekspert
21. februar 2018 - 15:18 #2
If the dB isn't slit up into a front-end (GUI) and back-end (data) then I would suggest you do that
Avatar billede terry Ekspert
21. februar 2018 - 15:20 #3
So each user has a copy of front-end and data is on server.
Avatar billede CRKrogh Ekspert
21. februar 2018 - 15:22 #4
Avatar billede bvirk Guru
21. februar 2018 - 15:23 #5
Med forbehold for kendskab til access 2016, kunne "attempting to open a database object in Design view" indikere at databasen ikke er delt op i en front end og en backend. Det er en fejl - såsnart en database bruges administrativt skal den deles op.
Frontend er den del som brugerne eller dig åbner - backenden er tabellerne og relationer i en særskilt fil (på netværket)
Udover ikke at blive låst til ikke at kunne udvikler på databaseappen, hvis en anden bruger har åbnet den, er det også sikrere - bare et eksempel på en ENKELT ting, så kan man ikke komme til at slette en tabel i tabller fanen eller hvad det hedder i access 2016.
Glem det med sourcesafe - noget gammelt fis at fyre af fra MS side - de er selv gået over til at bruge Git
Lær at bruge Git - det  got!
Nogle gange har du måske taget en kopi af en database for hvis nu???
Git er versionering af backup'er, som udgangspunkt af en mappe (med undermapper - konfigurerbart i .gitignore)
Avatar billede Per Juniormester
21. februar 2018 - 16:10 #6
Hej

jeg har ikke delt databasen - men kan se at det er det der skal til
tager en kopi hverdag og ligger ud på fælle drevet.

Jeg har et spørgsmål til når man har delt databasen, bliver FE kopieret over på den enkeltes egen drev ?
eller køre alle på samme FE base - bliver problemet i så fald ikke det samme ?

Per
Avatar billede CRKrogh Ekspert
21. februar 2018 - 16:20 #7
Kogebogen, jeg linkede til ovenfor, beskriver det ret godt....
Avatar billede terry Ekspert
21. februar 2018 - 17:35 #8
Per, could you answer the questions I asked please?
Avatar billede Per Juniormester
22. februar 2018 - 07:31 #9
hello Terry, sorry for my late reply I had to leave early yesterday
i did not split up the base in front end-and back-end, but i will try to do so today and see if it will solve the problems

b.r.
Per
Avatar billede Per Juniormester
22. februar 2018 - 10:47 #10
Hello

Problem is solved - the base is devided and the users do not have any issues

thanks for your help - both of you

b.r.
Per
Avatar billede terry Ekspert
22. februar 2018 - 10:51 #11
Hi Per
I'm more interested in this question
"The message seems to indicate that you are trying to make design changes to the dB at the same time as other users are using it.
Is that correct?"

I'm trying to find out when the error occurs, is it happening when you try and make design changes?

I've worked with Access for a number of years and unless MS have made some changes to 2016 which I am unaware of, then it should NOT be necessary to split the dB into FE/BE to be able to work in a multi user environment.
Its best to split the dB into FE/BE for a number of reasons and will probably solve your issues, but it would be nice to know if the problem could be solved without having to do so.
Avatar billede Per Juniormester
22. februar 2018 - 11:19 #12
Hi terry
I am working with different small bases all with multiple users. they have been running fine without any problems at all. I did not make any restrictions on the previous bases
but on the last version i made a "start" page and did hide the navigation pane.
I allowed the users to look in queries and I thought that the problems were due to one of the those reasons
I have in the past month kept the original in my own drive and made a copy  of that base and made it available when I had some updates – I see now that that could also be one of the problems

As you now might know by now, I am just a happy user of Assess, learning some of the many features that access has. In the past we used Excel but its not user friendly when you are multiple users.
Hope that it can help
b.r.
Per
Avatar billede terry Ekspert
22. februar 2018 - 11:51 #13
Hi Per Thanks for extra info :-)

BR
Terry
Avatar billede Per Juniormester
23. februar 2018 - 05:09 #14
Terry,
I need your help again :o)
i tried to secure the back end base with a password and it was quiet easy to do if you follow MS instructions

but when I go the go to the front end – and run a query, the system come up with “wrong pass word”

what is wrong ?
b.r.
Per
Avatar billede terry Ekspert
24. februar 2018 - 13:12 #15
Hi Per
You will probably need to delete your linked tables and then reconnect giving password when prompted

BR
Terry
Avatar billede 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.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

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