Hi!
Does anybody know how I can use a table from a sql server back end database as rowsource for a list box in a Access2000 front end application? I do not want to use ODBC.
I´d also like to know if there is a simple and fast way to populate a local table with data from the back end data base. I´ve tried getting all the data from the server in a recordset, and then looping through it to insert it in the local table-type recordset with .AddNew. It works, but unfortunately it´s dead slow.
I´d appreciate any help. Many thanks!
/Linus
Does anybody know how I can use a table from a sql server back end database as rowsource for a list box in a Access2000 front end application? I do not want to use ODBC.
I´d also like to know if there is a simple and fast way to populate a local table with data from the back end data base. I´ve tried getting all the data from the server in a recordset, and then looping through it to insert it in the local table-type recordset with .AddNew. It works, but unfortunately it´s dead slow.
I´d appreciate any help. Many thanks!
/Linus