J
jk
Hello,
I am looking for suggestions on how to create an unbound continuous
form. I use an access databse project that is connected to a SQL
server 2005 back end.
I want to use an unbound form because:
-I can handle all errors and data integrity myself
-the form is complicated and reprsents data from many tables(meaning
there is no table or query to which it can be easily bound).
-To reduce server traffic and record locking
-Primarily, my client has requested it
From what I have found online, most people suggest to work with a
temporary table, binding it to the form, and then executing stored
procedures to move that data to the desired target tables.
I was just wondering if anyone had other suggestions before I dive
into this.
Thanks
JK
I am looking for suggestions on how to create an unbound continuous
form. I use an access databse project that is connected to a SQL
server 2005 back end.
I want to use an unbound form because:
-I can handle all errors and data integrity myself
-the form is complicated and reprsents data from many tables(meaning
there is no table or query to which it can be easily bound).
-To reduce server traffic and record locking
-Primarily, my client has requested it
From what I have found online, most people suggest to work with a
temporary table, binding it to the form, and then executing stored
procedures to move that data to the desired target tables.
I was just wondering if anyone had other suggestions before I dive
into this.
Thanks
JK