VB.Net 2005 and Access 2003 mdb

[Chris]

Ok,

I have a vb.net application that connects to a network file share.
The vb.net application bases certain functions (whether or not the
user can or can't update for example) by polling the system.username
variable and checking that against a table in the database. When I or
any other domain admin is logged on and using the system we are
allowed to update and delete whatever we wish. My problem lies in
that when a normal domain user tries to update the database i get the
dreaded "Operation must use and updateable query" error. I know it is
a permissions problem i just don't know where. This is NOT ASP.
Everything i have found about this error is ASP related. The file
share is available to all domain users and Everyone has read, write,
access, and modify permissions to both the access database and the
file itself. Yet i still can't get a normal domain user to update. I
even created a new organizational unit for the users who are allowed
to update and gave them full control over the directory and the file
and still to no avail. Any help would be greatly appreciated. Thank
you

 

[Chris]

And just as a follow up because i know the question will probably get
asked. Why not just leave it in access. Which is in fact the way i
orginally wrote it. But it was decided by the powers that be that
since everyone didn't have access and those that do don't all have the
same version it should be rewritten into something that would be
generic for all. So i did as i was told. And there was no way my
boss was going to install (let alone pay for) sql server to do this
in. I really didn't want to delve into learning AS400. This is a
very simple app and this is the only snag i have hit. Again thank you
very much for anyhelp you can provide

 

[Paul Clement]

¤ Ok,
¤
¤ I have a vb.net application that connects to a network file share.
¤ The vb.net application bases certain functions (whether or not the
¤ user can or can't update for example) by polling the system.username
¤ variable and checking that against a table in the database. When I or
¤ any other domain admin is logged on and using the system we are
¤ allowed to update and delete whatever we wish. My problem lies in
¤ that when a normal domain user tries to update the database i get the
¤ dreaded "Operation must use and updateable query" error. I know it is
¤ a permissions problem i just don't know where. This is NOT ASP.
¤ Everything i have found about this error is ASP related. The file
¤ share is available to all domain users and Everyone has read, write,
¤ access, and modify permissions to both the access database and the
¤ file itself. Yet i still can't get a normal domain user to update. I
¤ even created a new organizational unit for the users who are allowed
¤ to update and gave them full control over the directory and the file
¤ and still to no avail. Any help would be greatly appreciated. Thank
¤ you

The bottom line is that your users will required full access to the folder where the Access database
file is located. You can remove Delete permissions on the database file (.MDB) but otherwise full
permissions are required to the folder in order to manage the corresponding .LDB file when the
database is opened and accessed.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Chris]

¤ Ok,
¤
¤ I have a vb.net application that connects to a network file share.
¤ The vb.net application bases certain functions (whether or not the
¤ user can or can't update for example) by polling the system.username
¤ variable and checking that against a table in the database. When I or
¤ any other domain admin is logged on and using the system we are
¤ allowed to update and delete whatever we wish. My problem lies in
¤ that when a normal domain user tries to update the database i get the
¤ dreaded "Operation must use and updateable query" error. I know it is
¤ a permissions problem i just don't know where. This is NOT ASP.
¤ Everything i have found about this error is ASP related. The file
¤ share is available to all domain users and Everyone has read, write,
¤ access, and modify permissions to both the access database and the
¤ file itself. Yet i still can't get a normal domain user to update. I
¤ even created a new organizational unit for the users who are allowed
¤ to update and gave them full control over the directory and the file
¤ and still to no avail. Any help would be greatly appreciated. Thank
¤ you

The bottom line is that your users will required full access to the folder where the Access database
file is located. You can remove Delete permissions on the database file (..MDB) but otherwise full
permissions are required to the folder in order to manage the corresponding .LDB file when the
database is opened and accessed.

Paul
~~~~
Microsoft MVP (Visual Basic)

Everyone has full permissions to the folder and the file

 

[Paul Clement]

¤ > ¤ I have a vb.net application that connects to a network file share.
¤ > ¤ The vb.net application bases certain functions (whether or not the
¤ > ¤ user can or can't update for example) by polling the system.username
¤ > ¤ variable and checking that against a table in the database. When I or
¤ > ¤ any other domain admin is logged on and using the system we are
¤ > ¤ allowed to update and delete whatever we wish. My problem lies in
¤ > ¤ that when a normal domain user tries to update the database i get the
¤ > ¤ dreaded "Operation must use and updateable query" error. I know it is
¤ > ¤ a permissions problem i just don't know where. This is NOT ASP.
¤ > ¤ Everything i have found about this error is ASP related. The file
¤ > ¤ share is available to all domain users and Everyone has read, write,
¤ > ¤ access, and modify permissions to both the access database and the
¤ > ¤ file itself. Yet i still can't get a normal domain user to update. I
¤ > ¤ even created a new organizational unit for the users who are allowed
¤ > ¤ to update and gave them full control over the directory and the file
¤ > ¤ and still to no avail. Any help would be greatly appreciated. Thank
¤ > ¤ you
¤ >
¤ > The bottom line is that your users will required full access to the folder where the Access database
¤ > file is located. You can remove Delete permissions on the database file (.MDB) but otherwise full
¤ > permissions are required to the folder in order to manage the corresponding .LDB file when the
¤ > database is opened and accessed.
¤ >
¤ > Paul
¤ > ~~~~
¤ > Microsoft MVP (Visual Basic)
¤
¤ Everyone has full permissions to the folder and the file

Can a normal user copy, modify and delete a different type of file, such as a text file, on this
network resource? If they cannot then the permissions are not set up correctly.

Also check to see if a corresponding .LDB file is created when the database is opened.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Chris]

¤ > ¤ I have a vb.net application that connects to a network file share.
¤ > ¤ The vb.net application bases certain functions (whether or not the
¤ > ¤ user can or can't update for example) by polling the system.username
¤ > ¤ variable and checking that against a table in the database. When I or
¤ > ¤ any other domain admin is logged on and using the system we are
¤ > ¤ allowed to update and delete whatever we wish. My problem liesin
¤ > ¤ that when a normal domain user tries to update the database i get the
¤ > ¤ dreaded "Operation must use and updateable query" error. I know it is
¤ > ¤ a permissions problem i just don't know where. This is NOT ASP.
¤ > ¤ Everything i have found about this error is ASP related. The file
¤ > ¤ share is available to all domain users and Everyone has read, write,
¤ > ¤ access, and modify permissions to both the access database and the
¤ > ¤ file itself. Yet i still can't get a normal domain user to update. I
¤ > ¤ even created a new organizational unit for the users who are allowed
¤ > ¤ to update and gave them full control over the directory and thefile
¤ > ¤ and still to no avail. Any help would be greatly appreciated. Thank
¤ > ¤ you
¤ >
¤ > The bottom line is that your users will required full access to thefolder where the Access database
¤ > file is located. You can remove Delete permissions on the database file (.MDB) but otherwise full
¤ > permissions are required to the folder in order to manage the corresponding .LDB file when the
¤ > database is opened and accessed.
¤ >
¤ > Paul
¤ > ~~~~
¤ > Microsoft MVP (Visual Basic)
¤
¤ Everyone has full permissions to the folder and the file

Can a normal user copy, modify and delete a different type of file, such as a text file, on this
network resource? If they cannot then the permissions are not set up correctly.

Also check to see if a corresponding .LDB file is created when the database is opened.

Paul
~~~~
Microsoft MVP (Visual Basic)

thank you for your help paul i got it fixed. If you know anything
about vb script programing with SNMP i would i have some more
questions for you or you could shoot me an email

 

[Paul Clement]

¤ thank you for your help paul i got it fixed. If you know anything
¤ about vb script programing with SNMP i would i have some more
¤ questions for you or you could shoot me an email

Unfortunately I can't help you there as I've never had any exposure to SNMP.


Paul
~~~~
Microsoft MVP (Visual Basic)