I'm trying to move the back end of an Access database that I set up over to SQL server, but keep the front end in Access.
On one of the forms I've got a list box that is populated by a table. In Access I had it as a bound control.
When I copy the table to SQL Server, link the table and then put the SQL table as the Row Source, it makes the form very slow to load.
After a bit of reading I'm starting to think I should be populating the list box via code, rather than binding the control to a linked table. (or would a simple index speed things up more than I imagine?)
Is there a better way of doing it? Can anyone please help with the code?
If anyone knows of good sites where I can get info on VBA code for SQL server that'd be a real help. I've considered switching it all to VB (for which I can find literature) but I need the crosstab query function of Access ... in addition to extra developement work.
Thanks
On one of the forms I've got a list box that is populated by a table. In Access I had it as a bound control.
When I copy the table to SQL Server, link the table and then put the SQL table as the Row Source, it makes the form very slow to load.
After a bit of reading I'm starting to think I should be populating the list box via code, rather than binding the control to a linked table. (or would a simple index speed things up more than I imagine?)
Is there a better way of doing it? Can anyone please help with the code?
If anyone knows of good sites where I can get info on VBA code for SQL server that'd be a real help. I've considered switching it all to VB (for which I can find literature) but I need the crosstab query function of Access ... in addition to extra developement work.
Thanks
