• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 688
  • Last Modified:

Drop Table Error

I am trying to drop a table in SQL Server Mobile Edition.
I get the following error.
"No Key matching the described characteristics could be found within the current range"

Any idea how I get past this??
0
RickJ
Asked:
RickJ
  • 4
  • 2
1 Solution
 
QPRCommented:
sounds like oledb telling you it can't find the table or the db referenced.
try running a select in the same context from the table you are trying to drop.
0
 
RickJAuthor Commented:
I tried a select and it works fine.
0
 
RickJAuthor Commented:
I have also tried to modify field properties (changing type, deleting) and it comes up with the same error.
If I add a field it works fine and doesnt complain. If I delete the new field it doesnt complain.
Also the table has no data if that makes a difference.

Any more ideas??
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
QPRCommented:
is this table involved in some sort of replication scenario?
0
 
RickJAuthor Commented:
No, replication is not being used.
0
 
RickJAuthor Commented:
I found a solution.
It seems the database was corrupt in some way.
I downloaded and used the "compact" in this tool,
"SQLCE Database Viewer" from www.pocketpctoolkit.com and it worked fine from then on.

Thanks for your help QPR.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now