Printable View
Hi,
A stupid beginner's question.
A very small question- When we use the 'BeginTrans...CommitTrans' for database entry it does not always update the Access records. We are using the Jet Database Engine. There is no consistency in updating the records. It works when there is no 'BeginTrans...CommitTrans'.
Please help...
Thanx in advance
Regards
BSTL
:confused:
Like you i'm only a beginner but I have had more success with opening the table / dataset using DAO it's quick easy and doesn't take a lot of brain to suss (ideal for me)
If you want a hand with DAO let me know
Thanx for the sugestion, but can u help in starting off with DAO?
Regards
BSTL
Heres a bit of code i did earlier
declarations:
Dim dB As Database
Dim qd As QueryDef
Public LATESTBATCH As String
'in module
Function GetLatestBatch()
Set dB = DBEngine.OpenDatabase("data.mdb")
Set qd = dB.QueryDefs("latestbatchnumber")
'connect dataset to data control
Set frmMain.Data1.Recordset = qd.OpenRecordset()
frmMain.Data1.Recordset.MoveFirst 'select first rec
LATESTBATCH = frmMain.Data1.Recordset!Filename
'frmMain.dtaLatestFile = LATESTBATCH
End Function
this opens the database and attaches the data to data1 datacontrol on the form 'main'
I only retrieve the first record of one field called 'Filename' but you can use the same thing with multiple records and move through the dataset using .movenext and .moveprevious
don't forget if you change any record value to use .update to commit the changes