From experimentation it would seem that an Access ADP is a Microsoft Access front Ended Database (that can be) served from SQL Server, which is fine. Where as an MDB file is a true Access Database served and run by Access.
Now where I am having trouble is that I want to use the Access front end (because of the forms reports macros etc), but it would seem that each user of the Database needs their own version of the ADP file, is this correct? (If multiple users try to use the same ADP the second one in gets a 'Read-Only error'). If so what are the implications of this? Is there anything I need consider.
Can anyone also explain what exactly the ADP is, does it hold any actual data? Do I need to create a seperate one for each user, or can I give out multiple copies of the same file?
Thanks I know its a long question.