unbound continusous form?

[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

 

[Sylvain Lafontaine]

You could use a disconnected recordset, see:
http://www.devguru.com/features/tutorials/DisconnectedRecordsets/tutDisconnRS.asp

If you want to create your own disconnected recordset, the easiest way would
be to take a real recordset, disconnect it and stream it to a string in
order to have all the required attributes. From this stream, you can easily
recreate all the disconnected that you want; see:

http://groups.google.com/group/comp...ugroup=*.*access.*&lr=&hl=en#f20d79536029060e

http://usenet.p2preactor.com/index-t-1476552.html
http://databaseadvisors.com/pipermail/accessd/2006-March/042722.html

Please note that I neved tried these methods myself. Another possibility
would be to mix MDB forms with your ADP application in order to have local
storage. See the thread "How to load Report from ADP Project from another
ACCDB or MDB" on 2007-12-08 for an example.

Finally, in my opinion, if you plan to work in a disconnected way from your
database(s), then you should use .NET instead of Access.

 

[jk]

You could use a disconnected recordset, see:http://www.devguru.com/features/tutorials/DisconnectedRecordsets/tutD...

If you want to create your own disconnected recordset, the easiest way would
be to take a real recordset, disconnect it and stream it to a string in
order to have all the required attributes. From this stream, you can easily
recreate all the disconnected that you want; see:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/th...

http://usenet.p2preactor.com/index-....com/pipermail/accessd/2006-March/042722.html

Please note that I neved tried these methods myself. Another possibility
would be to mix MDB forms with your ADP application in order to have local
storage. See the thread "How to load Report from ADP Project from another
ACCDB or MDB" on 2007-12-08 for an example.

Finally, in my opinion, if you plan to work in a disconnected way from your
database(s), then you should use .NET instead of Access.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)










- Show quoted text -

thanks, great info

 

[Arletha Fenwick]

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