2002 .MDE running on 2000, 2002 and 2003

[Lynn]

Is there any chance that a .MDE file compiled in Access 2002 can run on a
computers that might Access 2000, Access 2002 or Access 2003 installed?

Thanks,
Lynn.

 

['69 Camaro]

Hi, Lynn.

The Access 2002 *.MDE file will run only on the computers with Access 2002
or 2003 installed, not on the computers with Access 2K installed, since
Access 2K is not forward compatible. Create the *.MDE file in Access 2K to
ensure compatibility with all of these computers.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Lynn]

I will stay with my 2000 .mde file.

But - the Access 2003 users get #NAme on some of the report fields.
The field names are not the same. Some have values like__(margin/sales)*100.

Any ideas on this?

Thanks. Lynn

 

['69 Camaro]

Hi, Lynn.

But - the Access 2003 users get #NAme on some of the report fields.
The field names are not the same. Some have values like__(margin/sales)*100.

Any ideas on this?

Someone has altered the RecordSource (usually field names in a query) of the
reports or the RecordSource of some of the controls on the reports. Table
names, field name, form names, control names on forms, modules, et cetera,
remain the same during conversion to another version of Access.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Lynn]

So i cannot do expressions in report fields?
I should do the expression in a query ?
Lynn.