Need Access 2003 to edit SQL tables that have BigInt
Need Access 2003 to edit SQL tables that have BigInt
(OP)
I am kind of in a pickle here. I really only know Access to do my update queries however the developer of one of our software packages updated a lot of the tables to include a BigInt column in a lot of the key tables. This is not something that I can change.
I know I can do views easy enough to see the info I want, but I need to be able to add and change records. Is there any way I can do this?
(The bigint on the tables is just being used as an auto counter so I do not need to see it at all)
I know I can do views easy enough to see the info I want, but I need to be able to add and change records. Is there any way I can do this?
(The bigint on the tables is just being used as an auto counter so I do not need to see it at all)
RE: Need Access 2003 to edit SQL tables that have BigInt
If it's not the id field, just don't use it in your queries and updates.
Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
RE: Need Access 2003 to edit SQL tables that have BigInt
RE: Need Access 2003 to edit SQL tables that have BigInt
(If that doesn't solve it, go kick some developer butt.)
Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard