Sharing .adp?

[7777]

Hello, I believe there's a sharing issue when trying to have multiple users
open the same .mdb file so it appears it was good practice to separate out
the data and the front end objects into 2 separate files (or multiple
individual front ends for each user)...are there the same sharing issues
with .adp files and is the recommended deployment practice the same? Thanks
in advance.

 

[Tony Toews [MVP]]

Hello, I believe there's a sharing issue when trying to have multiple users
open the same .mdb file so it appears it was good practice to separate out
the data and the front end objects into 2 separate files (or multiple
individual front ends for each user)...are there the same sharing issues
with .adp files and is the recommended deployment practice the same?

Yes, each ADP user should get thier own copy of the ADP file. Note
that the Auto FE Updater now supports ADPs.

For more info on the free Auto FE Updater utility see
http://www.autofeupdater.com to keep the FE on each PC up to date.

Tony

 

[7777]

Thanks for the speedy informative reply Tony, much appreciate it. Cheers

 

[7777]

In further research of .adp files, is it true that you can't separate out
the data from the front end like you can with .mdb files?...are .adp files
just stand alone client files in which each user gets their own .adp file as
the only implementation? Thanks again.

 

[charlie]

roy

 

[Sylvain Lafontaine]

Not sure what you mean with "separate out the data". In ADP file never
contains any data, it's only a client interface to a SQL-Server database;
the place where your data always is always stored.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)