Immediate Attention Required

jerry8989

New Member
Joined
Nov 19, 2003
Messages
43
I have an access front and back end databases. All the tables reside on the back end and are linked through the front end. When I try and edit a specific query it does not show the correct toolbar. There is now way to switch from Design view to sql view or to data view. When I try and click on "File", "View" or "Tools" nothing happens. It seems locked. Other queries within this front end database work fine. When I copy it to a different machine the query works fine. I did do a compact and repair and I did restart the computer. I don't think it's courrpt because I have an older version of the front end that I know worked fine and that is doing the same thing. Any help would be great.

Thank You
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Can you recreate the offending query and if so, does the same happen with the new query?
 

jerry8989

New Member
Joined
Nov 19, 2003
Messages
43
I can't get to that queries sql statement. It's a pretty big query. It works on 1 computer but not the other 1. It's weird how it just locks down the toolbar and doesn't allow me to edit the query in any way. The run button doesn't even show up when I go into design view. I was going to reinstall but other big queries work and that query works in an older version of the front end.
 

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
If it works on another computer, can't you see the SQL View there? I know this is extra work, but if you cut and paste to a file from the other computer, you could create a new query on the offending computer, open the file on that computer and cut and paste into the SQL View of the new query. Might get you going.
 

jerry8989

New Member
Joined
Nov 19, 2003
Messages
43
Figured it out

Thanks for your help what you suggested is what I ended up doing. This machine sucks. I reinstalled Access 2003 and everything worked but there is another problem. I will start a new thread for that.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,331
Messages
5,528,052
Members
409,800
Latest member
camronmartin

This Week's Hot Topics

Top