|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Problem deleting records - Access XP and our intranetI created a split database in Access XP. I am trying to expand its
functionality by letting users enter warehouse orders through our intranet. To achieve this I added three linked tables to the database_be which link to tables in a database on our intranet server. I wrote queries that allow the warehouse clerk to view the on-line orders and to import them into the main database for processing. It works great, until the user tries to run a delete record query after she imports them. It works for me, but the user gets the read only message. I've worked with our web guy who has given the user full control of the folder and the database on the webserver. I copied the database to her desktop and its no longer read only. I haven't pass word protected either database. Any suggestions? Pat She doesn't trust your intranet like you do. :)
Tell her to open Internet Explorer. Tools > Internet options > Security. Click on Local Intranet, then click the Sites button. Check the 3 check boxes: [X] Include all local (intranet) sites not listed in other zones. [X] Include all sites that bypass the proxy server. [X] Include all network paths (UNCs). Chris pgruenke wrote: >I created a split database in Access XP. I am trying to expand its >functionality by letting users enter warehouse orders through our intranet. >To achieve this I added three linked tables to the database_be which link to >tables in a database on our intranet server. I wrote queries that allow the >warehouse clerk to view the on-line orders and to import them into the main >database for processing. It works great, until the user tries to run a >delete record query after she imports them. It works for me, but the user >gets the read only message. I've worked with our web guy who has given the >user full control of the folder and the database on the webserver. I copied >the database to her desktop and its no longer read only. I haven't pass word >protected either database. Any suggestions? Pat -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1 Unfortunately, she already has those boxes checked.
She doesn't have Internet Explorer open when she is running the queries. She is doing it totally through the database front end using working with the two linked tables that reside on our intranet. She has been given the same security I have for the website and for the database but its still read-only for her and I can delete records. Pat Show quoteHide quote "Chris O'C via AccessMonster.com" wrote: > She doesn't trust your intranet like you do. :) > > Tell her to open Internet Explorer. Tools > Internet options > Security. > Click on Local Intranet, then click the Sites button. Check the 3 check > boxes: > > [X] Include all local (intranet) sites not listed in other zones. > [X] Include all sites that bypass the proxy server. > [X] Include all network paths (UNCs). > > Chris > > > pgruenke wrote: > >I created a split database in Access XP. I am trying to expand its > >functionality by letting users enter warehouse orders through our intranet. > >To achieve this I added three linked tables to the database_be which link to > >tables in a database on our intranet server. I wrote queries that allow the > >warehouse clerk to view the on-line orders and to import them into the main > >database for processing. It works great, until the user tries to run a > >delete record query after she imports them. It works for me, but the user > >gets the read only message. I've worked with our web guy who has given the > >user full control of the folder and the database on the webserver. I copied > >the database to her desktop and its no longer read only. I haven't pass word > >protected either database. Any suggestions? Pat > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1 > > She doesn't need Internet Explorer open when she's working with Access across
the network. I only mentioned it because it's the easiest place to check and make the change if the network isn't trusted on that pc. Where is her front end? On her hard drive or on the network? Chris pgruenke wrote: >Unfortunately, she already has those boxes checked. > >She doesn't have Internet Explorer open when she is running the queries. >She is doing it totally through the database front end using working with the >two linked tables that reside on our intranet. She has been given the same >security I have for the website and for the database but its still read-only >for her and I can delete records. Check if her antivirus is set to do network scanning. That can put the mdb
file in a read only state. Also if her pc is Windows XP sp1 and the server has server message blocking turned on, that can give her a read only mdb on the network too. Chris Chris O'C wrote: >She doesn't need Internet Explorer open when she's working with Access across >the network. I only mentioned it because it's the easiest place to check and >make the change if the network isn't trusted on that pc. > >Where is her front end? On her hard drive or on the network? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1 Chris - the mystery is solved. The internet guy had security for all the
same except in one area. He changed it, and now she can delete records. It wasn't an Access issue. Thanks for your help. Pat Show quoteHide quote "Chris O'C via AccessMonster.com" wrote: > Check if her antivirus is set to do network scanning. That can put the mdb > file in a read only state. > > Also if her pc is Windows XP sp1 and the server has server message blocking > turned on, that can give her a read only mdb on the network too. > > Chris > > > Chris O'C wrote: > >She doesn't need Internet Explorer open when she's working with Access across > >the network. I only mentioned it because it's the easiest place to check and > >make the change if the network isn't trusted on that pc. > > > >Where is her front end? On her hard drive or on the network? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1 > >  
Other interesting topics
|
|||||||||||||||||||||||
