Queries not working after compiling the DB

[khashid via AccessMonster.com]

I have built a Database and spilitted into FE & BE. in the FE i got 2 forms
that are based on queries and used for searching. I made MDE file and used
startup option to remove admin options so noone can change the DB. Now when i
copy the MDE file on different PCs on network to access the BE on server I
have noticed that Search option that are based on the queries is not working.
Any Idea? while the same file is working fine on my computer. I have made
sure everything else is fine.

 

[Amy Blankenship]

I have built a Database and spilitted into FE & BE. in the FE i got 2 forms
that are based on queries and used for searching. I made MDE file and used
startup option to remove admin options so noone can change the DB. Now
when i
copy the MDE file on different PCs on network to access the BE on server I
have noticed that Search option that are based on the queries is not
working.
Any Idea? while the same file is working fine on my computer. I have made
sure everything else is fine.

What do you mean by "everything else"?

-Amy

 

[khashid via AccessMonster.com]

I mean all other formsa, macros etc are working fine. only two forms that are
based on queries for searching are not working.

I have built a Database and spilitted into FE & BE. in the FE i got 2 forms
that are based on queries and used for searching. I made MDE file and used

[quoted text clipped - 5 lines]

Any Idea? while the same file is working fine on my computer. I have made
sure everything else is fine.

What do you mean by "everything else"?

-Amy

 

[Amy Blankenship]

I mean all other formsa, macros etc are working fine. only two forms that
are
based on queries for searching are not working.

So have you checked to see that the tables those queries are based on have
relinked properly?

 

[khashid via AccessMonster.com]

I kind of found the problem, when I installed the FE on a new PC for the
first time it asked me if I want to unblock the unsafe codes, If I click NO
then everything works fine. And it also advised me to update the MS Jet 4. I
did update the MS Jet 4 , but in the few systems still the codes are not
working.