Under Tool/Startup.., Security Disappear, I Want It Back
Sep 13, 2006
Hello Access experts,
I am using MSAccess 2002. I have removed the tables and queries to reduce file size. I have set database password as "planning". In the form named "Form1" I have created a Shift-Key Enable/Disable button with password "SIMON". In Menu Starup, I have also disallowed Display Database Window, disallowed Built-in Toolbars and disallowed Toolbar/Menu Changes. Now I have problem because I cant unset the Security password and make changes in Startup.. because the Menu Tool/Security, Startup..etc have disappeared. How do I get them back again?
I thought I had this figured out, but apparently am still missing something...
When I start my DB, I get the default 'Security Warning' message every time asking if I want to cancel or continue... I thought this was an options setting under the Tools/Macro/Security setting. However, when I change this setting (default is Medium) to Low, exit Access and restart the DB I get the same warning message and the security setting is back to medium.
Am I in the right area to fix this? Why would my settings default back?
I've built a few simple databases in the past, but never one where security was required. Now someone wants a database where access to certain areas is limited. Everything I read about Access Security here makes it seem complicated, and flaky, so I was wondering about doing something simpler ;
1. Make the Back End password protected so no one can open it
2. Make the front end an MDE. Put certain forms behind a form which prompts for a password. Store the password in a table to allow it to be changed if required.
So this looks like a crude method to me, but it is for a small user base, where the manager needs access to certain info which employees shouldn't see. I suppose if an employee was so minded, and put in some effort, they could get around the simple password-protection, but is it worth setting up proper security for a small project ?
Can anyone offer any advice on how much more secure the database would be if I did it properly ?
I have a split database. The front end with forms etc is distributed to users and the back end with tables sits on a shared drive.
I have been trying to set the security on this and quite frankly it's driving me mad. I managed to get the security set with 5 user groups and about 100 users - it all worked well on my PC but when I distributed it, the copies open with the Admin as user, no password required, resulting in no security whatsoever.
Further reading showed me that I had to change the owner of all objects from Admin to a new adminitrator, who I named Custodian1. This I did. I then created a new database while logged on as Custodian1. So, the new database has all objects owned by Custodian1 and the database itself is owned by Custodian1.
The book said I had to delete the Admin user but, after asking if I was sure that I wanted to delete the user, Access would not let me.
I went through the Workgroup security wizzard a number of times to try to reset things that way, all to no avail. I then did the whole ownership change thing with the back end database and relaunched the wizzard. Still unable to delete the Admin user.
My final attempt was to use the wizzard and create a new WIF rater than edit the existing file. And still, I cannot delete the Admin user and distributed copies have no security.
I don't know how this ties in, but the distributed copies do not seem to be linked to the WIF although they find the Back End database, in the same shared drive/directory with no problems. If I set a password on a distributed FE database copy, it then cannot be opened as the users are not defined.
I'm obviously missing something fundamental to the whole process. A further difficulty is that I have the live database FE/BE, working copies FE/BE, The security wizzard backups FE/BA, and all the directories have similar names. On top of that, I have my normal none database duties to distract me. I'm finding it very hard to keep track of where I am or what I am doing.
Any help most gratefully appreciated and received.
I am trying to give a new user access to the front end of a DB.
When I copy the FE from the server to the local C drive ( Windows XP)
the FE loses all its relationships and the user is not able to query anything.
I go back to the server and find that the FE is just fine on the file server.
I also tried running the FE from my PC ( Windows 2000 SP4) and it works fine.
Do any of you know what the issue could be. I also checked to see that the new user has permissions on the folder on which the file is located on the server and she does...
Any thoughts on what the problem could be would be highly appreciated.
I have noticed that the "warnings" in my access 200o database no longer pop up. As example, if I went to delete a table or record, I used to get a pop up warning from MS Access asking for confirmation. Now the record just deletes without a warning. This seems to be happening with other things too.
Hi, I am new to access and I have found important tricks in this forum. Thanks to everybody
Now, I am trying to use a query with multiple criteria. In particular it has to query a table that contains info about candidates tblCands using text boxes, check boxes etc etc present in a form. First, it works correctly but if I close the form and re-run it, statements in query disappear.
Could someone indicate me what would be the problem?
Well this is going to take a bit of explaining, because my colleagues and I are totally baffled.
I have an Access 2000 front end connected to a Sql production server. I went to make some changes to my forms and subforms, but I did not want to do it with the live data. So I made a copy of the database to my own Sql server on my desktop. So far so good . . . Now when I opened my main form, my subform appeared, but its controls were invisible--I still had not touched the code.
I looked at all the properties for my form and subforms and it is set to Visible and Display always. Now, even stranger, when I advanced my records, if the subform had data its controls would become visible, and then disappear again when I reached a record that had no data for the subform (the main form and the subform are bound to two seperate tables within my database, all the subform controls are bound as are the majority of the form's controls).
Then I went to the code. Nowhere do I change the Visible related properties within the form/subform code. I decided to put a Stop in the Form_Current code of the subform and see what happens as I advance from record to record. What happened was that when I reached a record with subform data present the stop would be read and I would toggle through the Form_Current code. When I would reach a record with no subform data, the Form_Current code would not be read as evidenced by there being no Stop action.
Anyone have an idea of what's going on? Something gets changed when I connect to my local SQL server. Even when I reconnect to the production server the problem remains. Its like some property changes, although I cannot find it, and it is changed permanently. The only property I play with by code is that I enable the controls of the subform when there is NO data in the subform, and I disable the controls when there is data. This code follows:
Private Sub Form_Current() On Error GoTo Err_Form_Current
If Me!AssignedNumber = True Then Me!AssignedNumber.Enabled = False Me!txtWTNumber.Locked = True Else Me!AssignedNumber.Enabled = True Me!txtWTNumber.Locked = False End If
Finally I tried to set Visible to true within my code for the individual controls, but that still did not overide the problem. I connect to my server via an ODBC connection to a .dsn.
Sometimes when I send a copy of an Access 2003 application to a remote user, a stored procedure or function will disappear. What causes this, and how can I get the entire application over to the users?
I use Access2007 under Windows 8.1 64 bits.Just ignore any message related to a splash form.The form will register revenues in the table TblLanc Receita sPJ. When either saving record input or closing the form, incomplete records must be eliminated from the table. When opening the form you should be able to see the unbound list of revenue inputs made. The list will show empty though because the last time I closed the form thru the button Close, table data disappears. Also, the same happens if I get into the form design mode to analyze the code and re-execute the form.
Please, click on the button Add to input a couple of revenue records thru the form to verify what I just said.I translated relevant input fields so the input should not be a problem. Fields named Quotation, Direct Purchase, and Contract, can be filled in with any data... just make sure only one of these fields per record be input, otherwise you'll get a pokayoke message. Save each input. After 2 or 3 record inputs, close the form and re-open it. Table will be empty. Redo and save new inputs. Go to the form design mode just because. Re-execute the form. Table will be empty again.
Another point is I want to click on a record of the unbound list and have the clicked record fields properly filled in the form. From that point I would decide if the record would be deleted or changed. The functionality of the entire code works but the selection on the list. In other words I do not understand why I am not able to fill in the form with the selected record fields. My code should do that but it does not.
I am using MS Access 2003. I would like to setup table link to sqlServer 2005. sql server and access 2003 is in on the same pc. I have setup ODBC Data source to this sqlServer database. I tested the setup and it work fine.
Then I go to access and action; File/Get External Data/Link Tables.
On lick Link Tables, It open link popup windows. But when I select ODBC Databases() from the Files of Types dropdown, windows disappeared.
My property sheet has disappeared I don't know what I did. How can I make it reappears? I have try by pressing the SHFIT key but it won't work. Also, I have created a new database and open it, the property sheet isn't appeared. The icon are still there but when I press on it, it does not response.
hey, i hav seen a similar thread about this (i think bout a year ago or so) and i didnt no whether to continue it or start a new thread.Option boxes - Making items visible that thread did not fully answer my question and after searchin around n finding nuthin i hav decided to ask
in my form i have the payment methods=> cash, cheque, credit. i did have these in a drop down menu, but i wasnt sure how to do what i wanted...which is based on the selection either make a couple of fields (credit card details etc) visible or invisible. so what i have done is changed the drop down list into an option group with radio buttons. i currently have this coding
this seems to work although say if my first record has credit card selected, then all the fields are visible, but wen i move onto the next record which is cash or cheque...they are still visible until i reselect cash or credit again..(and vice versa)
In a report there is a text box that disappears if certain data appears in a record. It is supposed to disappear but I cannot determine why it is disappearing and I need to fix the criteria that make it disappear.
The text box is unbound (the control source is ="Bonus Point Legend"), and there is not any code that refers to it, nor are there any references to it in a query (I can delete the text box and the report runs just fine). Interestingly, if I add a new text box and use the paint brush to format it based off the one in question, it also disappears and acts just like the one in question. But I can't find any code that even references a generic control and makes it invisible. The tag field is not in use either.
I have a query that's been working fine for years, however...the powers that be have requested a change. We need to track the lining owners in cars. We've recently gone to SQL on the back end (which I basically know NOTHING about) but I set up the new table, refreshed the connection, etc.
I can see the table fine and it says it has a primary key, auto numbers, etc. however, as you can see from the jpg below when I add the table to the query and link the id as in all the other tables, for some reason, this one makes all the data disappear when in datasheet view.If I delete the table from the query - it all comes back.
I seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
I have a Login form, I set a query retrieve information from Login form's Text3 (username)
After that , if the user Successfully logged in then the Login form will close .
I set the query because i need to retrieve what is His/Her Department .
But , after I closed the Login Form , the query result disappear ...
Then I try open Login Form again and login again ... the result come out again ...
How to solve this problem ? Everytime the Form closed the criteria cannot work ad ... It will prompt me the parameter box want me to type again the criteria ...
