Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gagan
Starting Member
5 Posts |
 Posted - 2003-08-17 : 21:29:06
|
| Hi!,I created a database with 5 tables and do updation on some of them through the code.when i send this database mdb file to another person,The select works fine, single update works fine, but I am using a cursor in one update query where it update multiple rows, It works fine on my computer, but does not work fine on the computer where i send the mdb file.I think something is wrong with permissions, Please help me.Thanx!,Gagan |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-08-17 : 21:41:43
|
| Check that table names are surrounded by [ and ]Where are you calling the update from? If it's another Access mdb, is the user re-linking? Or are you hoping everything will work by just pasting the new .mdb into the same location with the same name? You should probably do an "auto-relink" on startup of the application...Can you post the update command?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
Update not working when i send the .mdb file