Queries not working after compiling the DB

  • Thread starter Thread starter khashid via AccessMonster.com
  • Start date Start date
K

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.
 
khashid via AccessMonster.com said:
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.
Click to expand...

What do you mean by "everything else"?

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

Amy said:
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
Click to expand...
[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.
Click to expand...

What do you mean by "everything else"?

-Amy
Click to expand...
 
khashid via AccessMonster.com said:
I mean all other formsa, macros etc are working fine. only two forms that
are
based on queries for searching are not working.
Click to expand...

So have you checked to see that the tables those queries are based on have
relinked properly?
 
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.
 
Back
Top