 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / July 2008Read only when loging in
It has been awhile since I did this. I have created an Access 2003 program and have sent the DB to someone. She says she only has read permissions and can not write out new records. I know it has something to do with the System.MDW file. Do I just send her mine and tell her where to put it? This DB does not need any special permissions or passwords for people. I just want to make it simple. Soon this will go on a server. What do I do them? Maybe I seem like someone new, but it has been a long time and I do not have any references or can I find any references on this. So can anyone help me? Thanks for the help ahead of time. arep It doesn't necessarily have anything to do with the mdw file. Is this database secured? How did you send the file - via CD/email? Perhaps the file has the Read-Only flag set.  SignatureJoan Wild Microsoft Access MVP : It has been awhile since I did this. I have created an Access 2003 : program and have sent the DB to someone. She says she only has read [quoted text clipped - 10 lines] : : arep > It doesn't necessarily have anything to do with the mdw file. Is this database secured? > [quoted text clipped - 18 lines] > : > : arep I did not do anything in the DB for security, if that is what you want to know. I did not do anything special. All I did was on startup, hide everything so that the could not see the tables,etc. and limit the toolbars. I sent the DB by email by attaching the file in zipped format. I suggested that she update to our version of Access, the 2003. Anymore ideas? Thanks, arep I did not do anything in the DB for security, if that is what you want to know. I did not do anything special. All I did was on startup, hide everything so that the could not see the tables,etc. and limit the toolbars. I sent the DB by email by attaching the file in zipped format. I suggested that she update to our version of Access, the 2003. Anymore ideas? Thanks, arep Sometimes a user's description can lead you astray. Does she get a message on opening that it is read only? Has someone else got it open at the same time? Does she (all users) have full permissions on the folder where the mdb is located? Does she get no message, but just isn't able to add a new record - that could be because the recordsource for the form isn't updateable. SignatureJoan Wild Microsoft Access MVP > I did not do anything in the DB for security, if that is what you want > to know. I did not do anything special. All I did was on startup, [quoted text clipped - 15 lines] > Joan Wild > Microsoft Access MVP I found out she is out until tomorrow. She did not get an error message. She tried to add a record and after adding it, it was not there. No one else if using the DB. I just sent it to her to try it out. Eventually it will be put on a server. I do not know where she put it so I will ask her tomorrow. So I do not know if she has full permissions on the file. arep > Sometimes a user's description can lead you astray. Does she get a message on opening that it is read only? Has someone else got it open at the same time? Does she (all users) have full permissions on the folder where the mdb is located? Does she get no message, but just isn't able to add a new record - that could be because the recordsource for the form isn't updateable. > > -- > Joan Wild > Microsoft Access MVP I found out she is out until tomorrow. She did not get an error message. She tried to add a record and after adding it, it was not there. No one else if using the DB. I just sent it to her to try it out. Eventually it will be put on a server. I do not know where she put it so I will ask her tomorrow. So I do not know if she has full permissions on the file. arep 'After adding it, it was not there' - umm records don't just disappear. This is not an issue with file location, or file permissions. Is it possible that the form this person is using is set to Data Entry i.e. it always opens to add a new record/existing records aren't shown? Can she open the table and actually verify that the record isn't there? Is the form she's using bound? SignatureJoan Wild Microsoft Access MVP Please visit www.atnas20@hotmail.com/blog I am starting up a business and need new customers. Any help that you could give me, I would really appreciate it. Im not spaming anyone, so please let me know if there are anyone you know who lives in the london area and would be interested in the purchase of medical uniforms. Im trying to get as many customers as i can. i need help tho. Please pass this email on to whom ever you know who would be interested. I would really appreciate it. Here is a little about it: We are a business that makes Medical Uniforms which are made for Nurse's, Doctors, and any Medical team that there is out there like PSW's. You can find more out about it at: www.atnas20@hotmail.com/blog We have flexible plans to accommodate growth. All size's, styles and colors that you can think of We are located in London, Ontario Thank you for your time. Margaret > It has been awhile since I did this. I have created an Access 2003 > program and have sent the DB to someone. She says she only has read [quoted text clipped - 10 lines] > > arep |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.