MDE works on my PC, but not on someone else's

[mbrown0717]

I created an access MDE file and put it in a directory that can be accessed by myself and others. Other people received messages that said Function isn't available in expressions in query expression Trim(lname + fname) which resulted in now options in a list box. Another problem was that the subforms were blank. From my computer, I open the same MDE and I am able to see options in the same list box and the subforms display information. What could be the problem? Thanks for any help.

 

[nfell]

Hi,

I think your problem may be due to missing references. Your PC will have some files registered that the mde file uses, and the others may not.

Every time I get the "Function isn't available ...." error or blank subforms it is down to references used.

You will have to run the mdb file on another PC and find out what references are missing then make sure you can create the mde on that PC.

Hope it helps.

 

[dhaveedh]

If your database was moved from one location to another and it is split into a backend and frontend.

Your problems may be arising because the links to the backend of the database are not refreshed. You have to check your links using the Linked Table Manager(Tools, Database Utilities).

It may be as simple as that.

Good luck

 

[dhaveedh]

If your database was moved from one location to another and it is split into a backend and frontend your problems may be arising because the links to the backend of the database have not been refreshed.

You have to check your links using the Linked Table Manager(Tools, Database Utilities) and make sure the frontend refers to the exact location where the backend is.

It may be as simple as that.

Hope it helps