MS-SQL use a MDB file or a ADP file

[Lynn]

Hi.
I am using SQL 2000 as my back-end and Access 2000 as my
front-end.
What does anyone suggest I use MDB or ADP?
Thanks,
Lynn.

 

[Kevin3NF]

an MDB with linked tables is easier, but in my limited experience an ADP
runs faster. For ADP, you need to know how to write stored procedurs for
all but the simplest of queries.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Guest]

Thanks for the advise. Lynn.

-----Original Message-----
an MDB with linked tables is easier, but in my limited experience an ADP
runs faster. For ADP, you need to know how to write stored procedurs for
all but the simplest of queries.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm




.

 

[Kevin3NF]

you may also want to check out microsoft.public.access.adp.sqlserver NG.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm