I created the .accde to distribute only the compiled file. But I have a problem. When you open the file .accde there is this problem of security: You can not determine whether the content is from a trusted source. Leave off the contents, unless they provide essential capabilities and the source is considered reliable. Open the file or cancel the operation? How Can I avoid the visualization of this security alert?
View RepliesI have a database with confidential data (to be used internally only). I do not want a person opening the database to get access to the tables or other elements.
All of the security setting on all computers are set to disable macros. So anyone who opens the application now has access to seeing the table eve though I have set all the ribbons, right click, etc so no user can get to them.
Is there a way to override the security alert so I can show it in a popup prior to load?
have a table with a list of employees with their badge numbers and the expiry date of their badges. I want to be able to run a query that will list/alert any badges that are due to expire with one months notice. How do I do this?
View 4 Replies View RelatedI have a master to child table relation which is one to many. Each one is represented by a different form.
The problem is, the user enters the primary key "JobID" on the master form, then he needs to enter a few records on the child list with the same "JobID" which is the foreign key in that case. I don't want the user to enter the "JobID" every time he enters a new record in the child form.
Is there a way I can copy the primary key to the foreign key each time the user enters a new record in the child form?
I have an Access 2007 mydb.accdb file. If I click on it, it starts up fine. If I click on it again, then focus goes to the already open db.
If I do the same but with the .accde of the same db, for each click a new instance opens. This is not good, in that a single user then can have multiple instances running without noticing it, and that might mess things up. What Windows setting to use, to convince Win XP that only one instance of mydb.accde should run, similar to the .accdb?
Any way to send auto alert without opening Ms. Access program.
I have created a program which requires to send auto alert on certain dates. Due to some travel plans manager might not be able to open the program every day (might not open the program on certain dates where I set the alerts) and the chances are he will miss those alerts if he won't open the program.
I need to create a guest database for a small hotel. And I would like to create a pop-up alert that appears when I open MS Access to remind me birthdays of the guests.
View 1 Replies View Relatedi want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower.the alert message will be something like this. Tomorrow one borrower need to return the book. click ok to view the data.can access 2007 do this kind of alert message..?
View 4 Replies View RelatedMy requirements is to send the alert messages with the approaching due date on every Monday of the week. I am able to send alert messages on Monday. My Problem is: How to send alert messages on Tuesday if Monday is Vacation. Is there a way to do it in access? I don't have much experience in access.
View 6 Replies View RelatedIm seeking for a solution to prompt all user with windows alert for Notification
Case 1:One staff applied leave and clicked "Submit" , after clicked I want the system will prompt his/her Supervisor for his/her leave approval or like a notification that the Supervisor need to go somewhere to approve (Selected Supervisor)(Maybe the Supervisor need to 7x24 Opening the access database).
I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.
The question I have is there a way for Access to send me a notification that someone has requested the change?
I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...
I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.
Hello,
I cant seem to get a certain setting right. I am trying to setup a user for the database that I have been working on. It keeps saying the following:
"It says I do not have necessary permissions to open. Have the system admin. Or person who created the object establish appropriate permissions for you."
I have that person assigned to the following:
Full Permissions
Full Data Users
Updated Data Users
And they still are unable to open the database.
Now from what I have read on this forum, I shouldn't give any personal permissions. So I have assigned users to groups and given the groups permissions.
In regards to the security question, what are bare minimums for a user to open the database, use the switchboard, choose a form, enter/change data via the form, and view reports.
I dont know the difference between:
Open/Run
Read Design
Modify Design
Administer
And I am afraid to give more than what I need, and I feel like I am just guessing and hoping to set it right. Thanks for any direction in this area.
I have a user that has to enable the security everytime he opens a database I have. What would cause this? No one else has any issues and this user has all the permissions he needs.
View 1 Replies View RelatedI will be sending out copies of a program to several locations. Once I send the program I have absolutely no control over it. The FE file will always be in the same folder. The setup process creates C:MyFolder with the FE file in there. Is there a way to to programmatically disable the warnings throughout setup or to make C:MyFolder a trusted location?
View 3 Replies View RelatedI created *.mdb database and I used (user-level security wizard) to give each user a username and a password. The dB file is saved in D: drive. The security wizard created a shortcut on the desktop to open the dB through it. After using that wizard I cannot open the database directly from drive D:.If I try to open it , it says"You don't have necessary permissions to use the database".Now, there are many users should use this db through the network.
View 1 Replies View RelatedI have an Access 2003 db being used through Access 2007 in order to use user-based security.It is a spit db with the be being on a shared server.For some reason, the security login has been deactivated after working fine for over a year. The user goes right to the autoexec macro file without having to log in.
They are also getting a "Read-Only" message at the top about only being able change table in linked tables.The DB is configured to utilize the logon as a parameter in some queries.
I have inherited a 2003 db with unknown PIDs for the Group & User security.When trying to alter User details, I'm asked for a PID, so I'm trying to find the PID for the existing users.
I've gone to unhide the systems tables to get a dump of the data & hopefully find the PIDs but no luck so far.There is a Parent ID & if I run a query from the Users DB file, it appears as if it something like japanese writing ???
I have some Databases that were created back in Access 97 and have managed to upgrade these databases to work in Access 2013, fixing any modules and forms which broke when upgrading the databases.User access and permissions within the database were controlled by User Level Security (the Workgroup.mdw file) which is not secure anyway I guess, as someone could easily copy the entire database.
The database as it stands now works perfectly in Access 2013, however anyone can do anything with the database which is my main issue. Im wanting to limit access for certain forms / tables / reports to certain users, then out right deny other users from accessing the database.
Ive seen the SQL Server 2014 Migration Assistant for Access, which looks to store the tables on SQL server then map these to the Access database, so i guess i could deny certain users from accessing tables that way, or only allow them to read the tables. However I'm not sure how that would lock them out of certain forms / reports and queries in the databases?
I need securing an Access database. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).
I found this post [URL] .... about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.
I have a question about user level security / access control.For my database I have a back-end containing the tables and a front-end with forms, queries and everything. I have set up the access user level security.Dependent from the access level of my users, some front-end options will be hidden and some queries retrieve only part of the data. For example: I have a form to calculate clients' end prices. A vendor can only see prices for his own clients, not for other vendor's clients.
BUT: to make the query work, all users need access to the tables and the back-end must be stored in a public place, right? Now all vendors can just open the back-end and see all information.Maybe protect the BE with a password and store this in the queries?
I have a database whereby users already have to sign in with a username and password, using a form which them allows them to view a front page. The front page allows them to access data and add/amend it.
I now have to adjust this setup as we have directors who want to view the system, but we don't want them to amend it.
Is there anyway to change the current setup that I already have or do I have to scrap it and start again?
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
View 1 Replies View RelatedI was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
View 1 Replies View RelatedI have created a database and made the steps to the user-level security and VBA protected the project but i lost the passwords and the MDW file.
is there any way to reset the VBA pass then reset the security level?
this is very important for my business it's a school database with lots of info and it's critical for me to update or at least export some reports and forms to a new project
I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.
The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.
I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.
I am developing a database for our fleet of company vehicles. What I'd like to know is is it possible to set up some kind of alert where a dialog box appears (like the sort of thing in Outlook with reminders).
What I'd like is, for example, if a vehicle requires a service a pop up would appear, a couple of weeks before, when the database is opened to alert the user that it will be required soon.
If anyone knows how to do this it would be greatly appreciated.