Update Tables

[ryan1]

Need Help! Here's whats happening. I have a front end with forms, queries, etc... and a back end with my tables. There is now link between my databases. There about six hundred people that could be in my front end at one time. Every user only has one checkbox to click. Now i know access will not allow over 30 plus uesrs at one time. What i was thinking was to Write some VB that would open my table database set my recordset and change my one field and close the recordset. That way each user is only accessing the tables for a view seconds at a time. Need some help getting started if anybody can help??

 

[rewdee]

I'm not sure if this is what you are looking for but to open another mdb file and change a boolean record would go something like this using DAO:

dim db as Database
set db=openDatabase("C:\SomePath\SomeFile.mdb")
With db.OpenRecordset("SomeTable",dbOpenDynaset)
  .Edit
  !SomeBooleanField=True
  .Update
end With
set db=Nothing

I only use ADO in Delphi so use this ADO code cautiously as I have not used ADO in Access but I think it goes like this:

dim cnn as new Connection
dim rs  as new Recordset
cnn.Open "Provider=OLE DB 4.0;C:\SomePath\SomeFile.mdb"
rs.Open "SomeTable", cnn, , , adCmdTable
rs.Edit
rs!SomeBooleanField=True
rs.Update
rs.Close
cnn.Close
set rs=nothing
set cnn=nothing

Hope this helps,
Rewdee