Never have sorted this out. For the moment it has lost priority, but I know that it is going to rear it's ugly head again. What has confused me the...

Sorry, Karira.

I know nothing about Sybase at all. My first outings were with SQL Server 6.5, after Microsoft and Sybase had parted company. If I understand you correctly, what you...

Karira,

Can you give us some details of what the error that you are getting is? Can you see the data if you just open the linked table as a datasheet?

Regards

David

I have never come across a way to do this - the SQL Server ODBC driver connects with an instance of SQL Server, not by reading the files.

Can you install...

Issue Resolved

I spoke to Microsoft Tech Support about this one - it is a problem with the Norton Anti Virus add-in for MS Office - turn off the addin and...

Ritesh,

I can't figure out why you would want this code in the After Update event. Why not just put it in the OnClick of the Cancel button itself?

Regards

David

Tobias,

Rewriting your query as a nested one would look like this:

SELECT tblInItem.ItemId, tblInItem.Descr, tblInItemAddlDescr.AddlDescr, [IN - On Hand Qty].onhand

FROM (tblInItem LEFT JOIN tblInItemAddlDescr ON tblInItem.ItemId =...

I get DOMAIN\Testuser

No, Testuser is not a member of any other group and TUsers is not a member of the Local Administrators group.

Thanks for your interest in this...

Here's what I know. The SQL Server is NT Authentication only. TestUser belongs to a group called TUsers. TUsers has no permissions on anything in...

The user is not dbo or sysadmin. But that question leaves me perplexed. My understanding of what BOL says is that a Deny overrides everything else. If you Deny permissions...

I can't see a way to do this, there is no character that 'turns off' the force upper or lower case within the mask specification.

Perhaps an alternative is to use...

Quite sure, I have tested this myself, opening one of the views in Enterprise Manager (logged in as a test user). The view has deny update, but I can change...

Steven,

The trigger is for updates as well, and BOL says that it is OK to reference DELETED in Insert triggers, but there will be no rows there.

Anyway, your post set my...

If your table is in SQL Server, then you need to set the data type of your primary key field to be an Identity. This will assign a new number...