C
cil
I have an Office XP Access db that I maintain @work that has some select
queries that pull from LAN based DB2 tables. While the Access queries work
fine, I've been told that a need to add the "WITH UR" statement to each DB2
query to avoid any table locking issues. In attempting to do this, I've gone
to design mode, SQL specific, then typed WITH UR after the FROM {table}
statement. The problem is that I keep getting a syntax error from Access
saying improper use of the WITH OWNERACCESS OPTION. I know I'm over my head
at this point so any help would be greatly appreciated. I've done some
research and found that UR stands for uncommitted read and seems to be more
of a DB2 option and not Access but I'm unsure how to proceed at this point
tia,
cil
queries that pull from LAN based DB2 tables. While the Access queries work
fine, I've been told that a need to add the "WITH UR" statement to each DB2
query to avoid any table locking issues. In attempting to do this, I've gone
to design mode, SQL specific, then typed WITH UR after the FROM {table}
statement. The problem is that I keep getting a syntax error from Access
saying improper use of the WITH OWNERACCESS OPTION. I know I'm over my head
at this point so any help would be greatly appreciated. I've done some
research and found that UR stands for uncommitted read and seems to be more
of a DB2 option and not Access but I'm unsure how to proceed at this point
tia,
cil