LittleSmudge
Programmer
I'm working with an Access 2000 database that has been split into a DataStore ( containing the tables ) and a FrontEnd ( containing the Forms, Reports etc )
Now the customer wants users on a remote site to be able to access this thing over a dial-up line so I'm doing some modifications to make the performance quicker - but what I'm doing doesn't seem to help as much as I'd expected.
Initially all the cpntrols on form frmCR were simply bound to fields in the table tblCR . When the Form was opened the entire contents of the tblCR had to go down the telecon before the Form opened properly ( and tblCR is a BIG table )
So I first made the frmCR.RecordSource = "SELECT TOP 1 * FROM tblCR" thinking that that would open quicker because the Form was only asking for the first one Record - It didn't improve things - Can anyone explain Why ?
I then tried frmCR.RecordSource = "SELECT * FROM tblCR WHERE CRId = 1" That didn't improve things either. - For the same reason I suspect.
So what do I do?
Unbind all of the controls, open an ADO recordset and then populate the controls with data from the recordset ? And then have to write to the recordset on every field's AfterUpdate ( or just when the Form changes record ).
That's almost making the remote form into a WebPage driven by ASP
Are there any other options that I've missed ?
G LS
Now the customer wants users on a remote site to be able to access this thing over a dial-up line so I'm doing some modifications to make the performance quicker - but what I'm doing doesn't seem to help as much as I'd expected.
Initially all the cpntrols on form frmCR were simply bound to fields in the table tblCR . When the Form was opened the entire contents of the tblCR had to go down the telecon before the Form opened properly ( and tblCR is a BIG table )
So I first made the frmCR.RecordSource = "SELECT TOP 1 * FROM tblCR" thinking that that would open quicker because the Form was only asking for the first one Record - It didn't improve things - Can anyone explain Why ?
I then tried frmCR.RecordSource = "SELECT * FROM tblCR WHERE CRId = 1" That didn't improve things either. - For the same reason I suspect.
So what do I do?
Unbind all of the controls, open an ADO recordset and then populate the controls with data from the recordset ? And then have to write to the recordset on every field's AfterUpdate ( or just when the Form changes record ).
That's almost making the remote form into a WebPage driven by ASP
Are there any other options that I've missed ?
G LS