Error in mde file

[sgoswami]

I wrote this code that lets the users change the printer for a report using API calls. The code works fine when the database is in mdb format but fails to work when in mde. The error I get is -

7802 this command does not work in mde.
Is there any where that I can go to get a list of commands that don't work in mde? or does anyone know of any commnands that may not work in the mde format?

 

[MHM]

Sorry sgoswami,

I don't know any list as you need.

In general:
mde-databases are compiled (and not only pre-compiled like mdb) and therefore do not support any re-compilation. All functions (normally) forcing re-compilation are excluded.
Also changing forms, reports and modules is not possible. Printer-settings sometimes affects those.

Hope you get any further with this.

Mic

 

[sgoswami]

Mic,

I got the issue resolved and you are right, it was an issue with opening the report in design mode to change the prtdevmode setting. The only workaround is to use an mdb and use microsoft access security to prevent changes to the reports.

Here is the link if anyone wants to get more info http://support.microsoft.com/support/kb/articles/Q180/2/81.ASP