While reading Access help I found the following, and was
wondering if I got it right:

Quote:
"
Caution You won't be able to open, convert, or run code
in a Microsoft Access 2000 ADE file in future versions of
Microsoft Access. The only way to convert a Microsoft
Access 2000 ADE file to a future version will be to open
the original Access project the ADE file was created from,
convert it, and then save the converted Access project as
an ADE file.
"

So if I've developed an ADE file in Access 2000, would my
clients who run Access XP be able to use it ?

It sounds like the wouldn't. But they would be able to use the ADP file, correct ?

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.



Sal

Hi Sal,

Good to know that I don't have to compile and distribute 2 version of the ADE file (one 2000 and one 2002/XP). That paragraph in MS help was poorly worded or I missed something.

The rights within within SQL Server for the users will be db_reader and db_writer so they cannot make schema changes.

The DB window will be hidden, and my custom menu won't allow them to unhide the regular toolbar.

I guess I should disallow the bypass key too, even though it's an ADE.

Hold that tought. I read wrong, but, I have distributed 2000 MDE files to users who only have XP and the files run properly. As far as ADP files, I have not had to re-distribute 2000 files to xp users. I do remember that Access 2000 ADP files have more functionalyty as far as the canned ability to manage SQL Server permissions, so it will leave room for trouble, also the views and stored procedures are shown differently. XP does have more capability for stored procedures.

I am not sure if the file would crash for sure. Try this site and you may find out more.

www.accessvba.com

They have a section for client server apps (adp). Since your users will not be changing design items, they may be ok, but that is only a guess.





Sal