Solved

Error: Query cannot be executed because some files are either missing or not registered.

Posted on 2004-08-03
3
1,568 Views
Last Modified: 2012-06-21
When I select a table to query I receive the error " The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered." I am running XP Pro on the desktop. This is the path that I select: Enterprise Manager - SQL server to attach to - select the database - select the table - select to query all rows.  The odd thing about this is that it was working fine on Friday & on Monday it doesn't work. I have uninstalled & reinstalled the MDAC. Did not correct the problem.
Please help!

Thanks.
0
Comment
Question by:3wiadmin
3 Comments
 
LVL 1

Accepted Solution

by:
bobsterboy earned 500 total points
ID: 11708633
Hope this isn't too painful, but if you have a restore point prior to flameout, you can use the system restore app in XP to bring your system back to where it was.  You'll lose any programs you've installed since then, but if your restore point isn't too far back, it won't be too bad.

0
 

Author Comment

by:3wiadmin
ID: 11709775
Thanks for the info. the restore didn't work for some reason. We used the xp disk to restore the system files & didn't lose any programs. It worked out great & it corrected the problem. Thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
2 Select Distinct 8 35
T-SQL:  Embedding a CTE 5 31
Help with SQL Server Stoplist 2 16
What logic to build in order to get a weekly reminder 9 36
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now