cannot update table

I have an msde database connected to a microsoft project front end.
I am trying to update a table with values. When I use a stored procedure
everything works fine but when I try and edit the table directly I am warned
that the 'the recordset is not updatable'
Is this 'by design'? or are there permission issues?
I am logged into the database as a user almx who has database creation
rights.
I tried logging into the database as sa but I it makes no difference.
Are there any specific permissions I need to set to allow users to update
the table values directly or is this not possible in a MS Access Project?
June
Access won't allow you to update records unless there's a primary key
or unique index defined on the tables.
--Mary
On Wed, 16 Jun 2004 12:24:34 +0100, "June Macleod"
<junework@.hotmail.com> wrote:

>I have an msde database connected to a microsoft project front end.
>I am trying to update a table with values. When I use a stored procedure
>everything works fine but when I try and edit the table directly I am warned
>that the 'the recordset is not updatable'
>Is this 'by design'? or are there permission issues?
>I am logged into the database as a user almx who has database creation
>rights.
>I tried logging into the database as sa but I it makes no difference.
>Are there any specific permissions I need to set to allow users to update
>the table values directly or is this not possible in a MS Access Project?
>June
>

Cannot Sync the Email from home PC with ActiveSync 4.5 and WM6

I have a WM6 phone which got an Exchange server setting for my email. When I connected the device by USB, the activesync will show "Synchronization could not completed. Try again later. Support Code 80072f7d". When I search the result from this forum. The answer is not related to mobile phone issues.

Will anyone able to help?

Thanks, ppdog

This forum is SQL CE/Mobile related. Since your question is not related to SQL CE/Mobile, it's off topic here.

If you’re having a hardware issue, please contact hardware manufacturer or reseller. If you having an issue with 3rd party software, please contact respective software manufacturer or reseller. Otherwise please post to relevant forum or news group:

http://support.microsoft.com/newsgroups/default.aspx

Closing as off topic.

Cannot shrink log file more than 2GB in small database

Hi2all,
I have some trouble with shrinking log file. No more user is connected
on this database. According to dbcc loginfo command log file is just
made up with active log. Here is the result
FileId_FileSize_____ StartOffset FSeqNo Status
Parity CreateLSN
2 1186201600 8192 15 2 128 0
2 1186201600 1186209792 16
2 64 0
I don't know why it remains so much space in active log because no
transaction is applied.
Can someone help me ?
Mo
--
Mo
Posted via http://dbforums.comSee
http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
http://support.microsoft.com/default.aspx?scid=kb;en-
us;256650
(and the references at the botom)
Do you have the database in full recovery mode and are you
taking log backups
If yes and no then set it to simple and read about backup
strategies in bol.

cannot select from INFORMATION_SCHEMA views

On a SQL200 server, connected as sa, I am trying to select
from the INFORMATION_SCHEMA views, but I get an error
message indicating an invalid object. However, if I use
Enterprise Manager (registered as sa) to look at the views
in the master database, I can see the views and they show
they are owned by INFORMATION_SCHEMA. I've verified that
the public group has SELECT permissions to the views. Any
ideas, anyone?Sean Hokanson (shokanson@.sandlot.com) writes:
> On a SQL200 server, connected as sa, I am trying to select
> from the INFORMATION_SCHEMA views, but I get an error
> message indicating an invalid object. However, if I use
> Enterprise Manager (registered as sa) to look at the views
> in the master database, I can see the views and they show
> they are owned by INFORMATION_SCHEMA. I've verified that
> the public group has SELECT permissions to the views. Any
> ideas, anyone?
What exact statement are you using?
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Sean Hokanson (shokanson@.sandlot.com) writes:
>>What exact statement are you using?
> select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
That seems to work here. What exact error message do you get?
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Cannot See SAN Disk Drives

I've installed sql server 2005active/passive cluster on Win 2003 Ent Edition
boxes connected to 3 SAN drives L, M, S.
When setup asked me where to install datafiles i choose the S drive.
SP1 installed, everything looks good, failover succesfully both ways.
However in SQL Server Managment Studio i don't see L and M drives.
In cluster admin under resources I see all 3 drives which are owned by Sql
Server 2005 group.
But when i try to detach and move the tran log from S to M i don't see M.
When i go to attach db i only see the S drive.
How can i add the L and M drives to be visible to Sql Server?
Thank you
Stop the SQL Server service, add the M & L drives as dependencies to the
resource. Restart everything and use away!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Alex S" <alexsdba@.aol.com> wrote in message
news:OlJ46FZ6GHA.3288@.TK2MSFTNGP02.phx.gbl...
> I've installed sql server 2005active/passive cluster on Win 2003 Ent
> Edition boxes connected to 3 SAN drives L, M, S.
> When setup asked me where to install datafiles i choose the S drive.
> SP1 installed, everything looks good, failover succesfully both ways.
> However in SQL Server Managment Studio i don't see L and M drives.
> In cluster admin under resources I see all 3 drives which are owned by Sql
> Server 2005 group.
> But when i try to detach and move the tran log from S to M i don't see M.
> When i go to attach db i only see the S drive.
>
> How can i add the L and M drives to be visible to Sql Server?
>
> Thank you
>
>
|||Most likely your SQL Server resource does not depend on the drive L and M
disk resources. In Cluster Admin, bring the SQL Server resource offline, and
add those two disk resources as its dependencies. Bring the SQL Server
resource online, you should be ready to go.
Linchi
"Alex S" wrote:

> I've installed sql server 2005active/passive cluster on Win 2003 Ent Edition
> boxes connected to 3 SAN drives L, M, S.
> When setup asked me where to install datafiles i choose the S drive.
> SP1 installed, everything looks good, failover succesfully both ways.
> However in SQL Server Managment Studio i don't see L and M drives.
> In cluster admin under resources I see all 3 drives which are owned by Sql
> Server 2005 group.
> But when i try to detach and move the tran log from S to M i don't see M.
> When i go to attach db i only see the S drive.
>
> How can i add the L and M drives to be visible to Sql Server?
>
> Thank you
>
>
|||IT WORKED.
THANK YOU
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23JKiWNZ6GHA.4608@.TK2MSFTNGP05.phx.gbl...
> Stop the SQL Server service, add the M & L drives as dependencies to the
> resource. Restart everything and use away!
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Alex S" <alexsdba@.aol.com> wrote in message
> news:OlJ46FZ6GHA.3288@.TK2MSFTNGP02.phx.gbl...
>
|||IT WORKED.
THANK YOU
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:2E663D4D-3A0E-4F09-81D1-F348DA2F15AF@.microsoft.com...[vbcol=seagreen]
> Most likely your SQL Server resource does not depend on the drive L and M
> disk resources. In Cluster Admin, bring the SQL Server resource offline,
> and
> add those two disk resources as its dependencies. Bring the SQL Server
> resource online, you should be ready to go.
> Linchi
> "Alex S" wrote: