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)