Search results

Dear All, I would like to set up a database with an admin password, I open it, go to Tools >> Security >> User and Group Accounts >> Change Logon Password I fill in the New password, Verify fields, then hit OK and I got this error message: "Cannot update. Database or object is read-only."...

Yes I understand that, but on the screenshot it is only me opening the frontend (so not more people) and still it locked the backend is there a way to solve this? My point is that even if 1 person enters the frontend it makes the backend ineditable, so what is the point in splitting the...

Then maybe I do something incorrectly, but if I open a query in the frontend it locks the backend file as well Pls see screenshot attached Could you please advise? Many many thanks!!

If I understand it correctly there is a frontend part with the forms and linked tables, and there is a backend part with the tables containing the data My question is, if a user in the frontend opens a query then it will make the backend ineditable as well because an .ldb file gets created for...

That is a good idea, I will try it Many thanks!

Dear All, I have a database that is used by 20 users at the same time They access tables through queries that are customized to their needs (approx 40 queries) It happens oftentimes that they open a query and they get a Record is deleted message, and when trying to open the underlying table...

Hello, Thank you it works fine!! (however I put that to AfterUpdate event) :)

Dear All, I am struggling with an issue in Access: Is it somehow possible with a query or a form that if one field is filled in with a specified character string (like "OK"), another field in the same record gets updated automatically (eg to today's date)? (so not only shows it but gets...

I get an error message: "Permission denied" :( Could you please advise? many thanks!

Dear All, Could you please help me with how to back up a database in VBA language? I would just need a very basic stuff that saves the currentdb as a new file, overwriting the previous backup (no need for dialog boxes or anything, just a simple copy-paste stuff) Your help would be very...

Thank you!! The datasheet view did the trick!

I understand but the problem is that a form displays each record only (one at a time) while a query shows all the records and I would need to see all the data in one screen if possible Could you please advise? Thank you!

Dear All, How is it possible please to lock certain fields in a query from editing? (if the recordset is updateable of course) I tried to change the dataset to Snapshot but it locks all the fields and not just separate ones... Many thanks in advance! ;)

Thank you very much it works perfectly!!!

Dear All, Could someone please tell me how I can count only unique values in a field using only one query? At the moment I do it with two queries, the first makes a Group by, to get the unique values, then the second makes a Count on the results of the first query. But I think there must be...

Dear All, HAPPY NEW YEAR!!!! I have a database that has numerous fields I would like to create a new field that displays for example how many given values are in each record eg Field1 Field2 Field3 Field4 New field k x x z 2 "New field" is 2 as there are two "x"...

I found the solution and it works fine!!!! There are 2 solutions: - change Group by to First in the query or - use a Left function: Left([memo field],10000) :)

Strange thing that those cells in the Memo field are empty! And when I append them to another table then the strange characters appear....

Dear All, When I use an append query on my table that contains a Memo type field I get these characters ꌎ in some of the cells of the Memo type field....weird Could you please advise? Many thanks! ;)

Woow, that solution is a bit simpler than compiling a code... :)) Many thanks that would definitely solve my problem!!