adp or mdb 1

[fule12]

Hi all,
I just have one small question. I just transfer my MSAccess(2000)back-end to sql server. But now i have question for access front-end. Which one to use access.mde or access.adp application to develop front-end application.

Thanks

Fule

 

[cmmrfrds]

When I have a choice, I prefer the ADP since it is designed to integrate very well with sql server. The adp is a client to sql server and each user must have there own copy of the adp. So, sharing an adp off a network drive is not an option, but this is not a good idea even with an mdb.

 

[BNPMike]

" each user must have there own copy of the adp. So, sharing an adp off a network drive is not an option, but this is not a good idea even with an mdb."

Can you say a bit more why this not a good idea?

 

[fule12]

Thanks , i will transfer my application to adp.
and becouse i dont have any expiriance with SQL Server, to reduce network trafic , where to create stored procedures : in sql server and than call from VBA or in to access adp application ?

Thanks

Fule

 

[cmmrfrds]

BNPMIKE, because with both the FE and BE apps on a server(s) the increase need for network traffic makes the FE app more vulnerable to corruption and typically it performs slower as opposed to the FE on the clients PC.

I use Access 2000 and the interface to create stored procedures is okay, but normally I create them in Query Analyzer which is a tool that comes with the sql server client, at least on the professional version and above. You can call a stored procedure from vba with the ADO Command Object or bind the SP to a Form/Report.

 

[fule12]

Thanks Cmmrfrsd & BNPMike

Fule