Problem deleting records - Access XP and our intranet

[pgruenke]

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

 

[pgruenke]

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

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

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

 

[pgruenke]

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

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

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

 

[pgruenke]

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

 

[pgruenke]

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