1. I have an application which contains a report based on a crosstab query. Because the data in the underlying tables can change I had to built the report dynamically (programatically). But when I later created and mde file this would not work since the mde refuses to go into design mode.(silly) My solution is not very elegant, but it works. I split the database into a back end mdb file and a front end mde file and put the report and the query in the mdb file. Is there a better way?
2. The jumping between applications (mde and mdb) above requires the creation of a temporary application object. I have read somewhere that the runtime version does not allow the CreateObject method. Am I going to have further problems when I migrate into the runtime version?