View Single Post
Old April 14th, 2004, 08:17 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

Yes, your users will be able to use the ADE file. An ADE file is a compiled ADP just as a MDE file is a compiled MDB. Compiling the file removes the code from the original file,so if you need to make changes to your file you will need the original file that you used to create the ADE file.

Make sure to keep copies of your adp/mdb files before you compile them to make wure that you can make changes.

Security with ADP/ADE files is more important because users will have access to the SQL Server tables, view and stored procedures. You have to make sure that when you distribute this files, your users can not access the database window.

Your users can use either an adp or ade file and reach the database as long as they have rights within SQL Server.