Search results for query: *

I am having trouble with the code for an SQL Server Insert Into Query. The result gives an error message that there has been a "violation of primary key restraint". I have researched here and found that I need an If Not Exists statement within the code, but I haven't been able to get that code...

I’ve searched everywhere and can’t figure out how to create a query that adds up employee overtime hours and keeps a running total. I found a Dsum example, that works great for a single employee, but adds all employee hours when multiple employees are queried. The table I use is called...

I have a Microsoft Access database that I would like to place on a Pocket PC. Is it possible to do this without rewriting the program? Is there a conversion utility available?

I want to update a field with a sequence of numbers. For example, there are two fields in a table with 100 records. The first field is an autonumber with #'s 1 to 100. The second field is a number field named Shift. I want to start numbering the Shift field so that it starts with 1 and fills...

I've been told that Access is not a good program for a WAN. Is this based on the size of the network or the distance of phone lines? I'm working with a program that has a back end residing on a server at a remote location. The back end holds five tables with approximately 3-4 mb of data. There...