MS-SQL use a MDB file or a ADP file

  • Thread starter Thread starter Lynn
  • Start date Start date
L

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.
 
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
 
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




.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and SQL 4
.mdb or .adp which is best to use with SQL 2K 10
ADP reports using SQL views unavailable to users 6
Future of ADP - new article 12
Call stored procedure in SSMS from Access 2016 doesn't work. 0
CurrentDb() in adp file 3
Access 2003 adp file in Access 2007 3
Is adp or mdb better SQL Server 2005 front end? 6

Back
Top