Enable 'Create Query Design' in .accde

[chunchun]

I have developed an access application which contains lot of VBA for business users. In order to avoid the access database to get corrupt, I plan to create a .accde version and provide it to the business users.

The business users need to query the database to perform their other function, but when I convert to .accde the 'Create Query Design' object gets disabled. Can somebody help me so that I can give the compiled version of the database to the users and they should still be able to perform using 'query design'.

Is there any VBA code for this or any set up that is needed in the access database. I am using access 2007.

Thanks

 

[alvechurchdata]

I don't know of any way of selectively enabling components within an accde. Could you give these business users an accde with the core features and a small accdb that just holds the queries?

Geoff Franklin

http://www.alvechurchdata.co.uk