Microsoft Access was unable to create an ADE database

[Guest]

I have Access 2000 in the front end and SQL 2000 on the back end. I am trying to make an ade file from an adp file. I created a brand new adp file. Connected to my SQL Database. Everything works fine. if I create a new form in my adp file I can create an ade file. But the moment I import an existing form from another ADP file and try to create a new ADE file, I keep getting that error message "Microsoft Access was unable to create an ADE database". Please help

Thanks

 

[Dirk Goldgar]

I have Access 2000 in the front end and SQL 2000 on the back end. I
am trying to make an ade file from an adp file. I created a brand new
adp file. Connected to my SQL Database. Everything works fine. if I
create a new form in my adp file I can create an ade file. But the
moment I import an existing form from another ADP file and try to
create a new ADE file, I keep getting that error message "Microsoft
Access was unable to create an ADE database". Please help.

If you click Debug -> Compile in the VB Editor, does the project compile
without errors? If not, fix the errors first, then compile and try to
make the ADE.