"The specified table does not exist" - for the administrator it does! Vista only issue
Posted
by Simon Nunn
on Stack Overflow
See other posts from Stack Overflow
or by Simon Nunn
Published on 2009-10-28T14:55:12Z
Indexed on
2010/05/16
0:50 UTC
Read the original article
Hit count: 440
sql-server-ce
|windows-vista
Hello,
I've got a weird bug occurring in a compact database on a Vista deployment machine. Basically the sdf file seem to be schizophrenic.
The client application get the entitled error when running as a user but not when I use run as administrator. I don't see this problem on my XP development machine.
I installed management studio onto the deployment machine and opened two versions of the application, one as user and one as administrator. When I query:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
I see 21 tables on the one and 26 on the other, and the administrator is seeing less tables. It turns out that the user version, with 26 rows, is a previous incarnation of this database.
Any ideas on why this is happening?
© Stack Overflow or respective owner