Search results for query: user access rights

We have 10 salesmen who go in the field to go and sell our products (They all have tablets with Windows 11 and Access 365 as FE), the taxman require them to issue a digital tax invoice right there in the field, but to do that they need to connect to our local server and this can be done via WIFI...

hi thank you for your reply. Yes @The_Doc_Man you're right when i implement a code fix then switching to view mode and then close the form, all the code changes are not saving. so currently what i'm doing right now is to close my access and recode before switching to view mode

I am an enthusiastic user of RegEx in Access, but in this particular case I'd use another tool to edit/transform the data first, such as PowerGrep where you can keep playing with the data until you get it right.

Hello everyone, I am facing an issue with the Microsoft Access Edge Browser Control on one of our user's computers, which started occurring yesterday. The user has the same Office365 version Version 2402 (Build 17328.20142) as everyone else, but for some reason, the Edge Browser Control isn't...

It must be a standard module, not a form's module. And of course the form being accessed must also be open at this moment and contain a valid value. Additionally, @Gasman is right again.

@Gasman You commented about the download link below the video on YouTube. There were links on that page but I've since changed it to the specific page: http://dev-soln.com/access-shortcut-right-click-tool/ However both your comment & my reply have disappeared. Did you delete your comment? I...

This is ridiculous! Now they don't like Access, they want the same results, but in Excel. Way harder and, if we want it elegant, then impossible. And once a week they will add more users and data. (WTF? Microsoft Access is the right solution!) Sorry and thanks everybody for your time and ideas.

They do not have to be individual AD users. You can also give AD groups the rights. Access to server must of course not be possible without allowed AD group membership. Note: sql user 'sa' is always deactivated in my servers, AD admins or an explicit SQL-Server-Admin AD User are entered as...

Where's the most likely place to look for? Let me take back a step. Do you know any article, site or book that explains the correct method and settings for adding a database to sql server? The objective is users are able to access the data from FE, but can not login to server with SMS. I may...

Why Access? Your data is so simple (just one table--which is actually correct for your data) so what does Access do that Excel can't? Excel will let you filter, easily sort, it's easy to input data, it has a user friendly Find function, it can be made "pretty". I don't think Access is the...

It's the most secure and preferred method from the dba's perspective and most everyone else's, Yes,,, until you introduce microsoft Access into the picture, and you give your company the impression that "don't worry, my app is the only way people will be able to mess with this data" - at that...

That was only to distribute the file. You could never run the app from the .exe. Running the .exe unpacked the database. .accde only hides the code. A simple trick is to rename the .accde to .accdr. That tells Access to pretend to be the runtime engine. This might break things in the app...

I've been developing apps in MS Access for a few years now, but have not come across this error message. I took an app that I've been developing for quite some time, made some changes (nothing to the tools/references), performed a compact/repair, and saved the file to the network for a...

I faced this and it was one of my disappointments in combining Microsoft access with SQL server. But I think in the end if you raise the right kind of error what the right level of severity it might, might in some cases come back to the calling application but likely not to Microsoft Access...

Marshall, I copied your database from Downloads to Documents Renamed the copy to "Jan30_165_DM_Test_Target.accdb" ?currentdb.Name C:\Users\JP\Documents\Jan30_165_DM_Test_Target.accdb Then invoked the following from your module1 DataMacroFiles "C:\Users\jp\Documents\" <======invoked here...

This COULD be a permissions problem. When you use a split database, the front-end gets copied to each user's machine. If the user performs the action to PULL a copy from the place designated for that purpose, then the user is the owner of the copy and should have Full Control (but not less...

@TadesaeN , all fixed. Project is progressing well. Got login, user access rights, attachments & working on assigning tasks & reminders at the moment. Most comprehensive CRM i've seen. Able to "drill down" to related organisations & related personnel, assign personnel to job roles within...

Do you know if Access honors SQL Server's application roles? I've not seen that explained, but if it does, that would be awesome.

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/application-roles?view=sql-server-ver16 If you have not set any rights for this user in the database, you have completely enabled access to the database somewhere.

Here is a sample from another forum that is short, sweet, and to the point. http://www.vbaexpress.com/forum/showthread.php?16913-Solved-Need-code-to-open-a-WORD-document-for-read-only When the Word document fills the screen, it also "overlays" (and thus hides) Access. When the user clicks the...