bentan30

My access frontend connects to a SQL server. This file also connects to local tables. This means that as the user is manipulating the data, it is stored on a local table. Only when he clicks on the save button, then is the data from the local table transferred to the SQL server.

Using the codes below, I've managed to open the recordset in the SQL server.

Dim rst1 As New ADODB.Recordset

'open connection
cnn.Open xDataSource

rst1.Open "Select * From " & xRecordset2 & " Order by ID", cnn, adOpenStatic, adLockBatchOptimistic, adCmdText

However, I'm not sure how to open the recordset in the local table. As such, data cannot be transferred. Pls advise...

Thank you.

big_k105

just to make sure im understanding you correctly. you are connecting to a sql server and getting info and putting it into an access database on your local system and then after your done editing from access you move it back to the sql server and you want to know how to open the recordset for the access database? if this is correct let me know. i was wondering tho wouldnt it be easier to just create a form that you can pull the data into in vb and then edit it there and then save it back? i cant remember how to get the recordset for access but it shouldnt take me to long to find out how again

__________________
BIG K aka Kyle
Programming Forums
Kyle K Online

Please do not PM or email me programming questions. Post them in the forums instead.

big_k105

ok i found a good website that should help explain how to do this
http://www.devdos.com/vb/lesson4.shtml

good luck and welcome to the forums

__________________
BIG K aka Kyle
Programming Forums
Kyle K Online

Please do not PM or email me programming questions. Post them in the forums instead.