Rezult is currently seeking an Expert Delphi Developer to fulfill a 6+ month
contract positon in Nashville, TN.
This individual will be responsible for working to update, improve and
stabilize the performance of a legacy point-of-sale application written in

I am trying to add a row w/i the subform and get the following error, "Cannot
insert the value NULL into column 'ExhibitorShowID'table ExhibitorShowBooths
column does not allow nulls, INSERT fails"
Below is my main form recordsource:

As you may know, the Access 2007 runtime was supposed to be released this
week.
Well, it was, but only for a few hours. A bug was found, so the runtime was
pulled and won't be released for a few weeks.

I get the following error w/ the below select statement:
ADO error: ORDER BY items must appear in the select list if SELECT DISTINCT
is specified
I am trying to select the first booth number for an exhibitor to print on a

I am trying to create table relationships in SQL server 2005 Express with
out success. I am using Microsoft Management Sudio Express. The problem is I
can see the toolbar that points to relationship, Query, Table creation but
they are all greyed out. The tables I have were ...

I have an ADP project which I have distributed to 30 clients. The backend
database is SQL Server 2000. The clients are running Office 2003. On some
clients most of the Inline functions (called User defined functions in SQL
Server) do not run. I can open them in design mode but ...

Does anybody know if it's possible to test for the existance of a table
index?  I am looking to write VB code that will try and find corrupted
indexes for several tables and automaticaly fix them.  I have most of it
written except for the part that actually tests it.  I am using ...

I am using sqlserver 2005 express edition and have downloaded the
AdventureWorksDB.msi. I have installed it and it created 3 files:
AdventureWorks.mdf (~ 2MB), AdventureWorks_Data.mdf (~ 164MB) and
AdventureWorks_log.idf (~1MB). When I added the database to the sqlserver,

Using VBA code is there a way to execute a stored procedure asynchronously?
I don't need a record count, I just need to let the user know that the SP is
still running and possibly allow them to stop it.
Kyle Jedrusiak

In Acces 2007 (and SQL server 2005) i can normally create .adp project
from database on server, i can also create tables or add fields in it,
but i can't add or change any data in the table. Does anyone knows
what are the common reasons, that cause this?

I have an Access Data Project (adp) that is running against an SQL Server
2000 database using the OLEDB provider.  I am currently developing it so I
frequently change the code and recompile.  After some undetermined amount of
time passes I get the "Access has encountered and ...

I have a client who has a simple Access database, which he now requires to
be accessible to up to 50 concurrent users remotely over the internet, as
well as a small number of local LAN users.
I am looking at a solution whereby the data is stored in a SQL server

I have this function in SQL server , i enter a number ( Brazilian Citizen
ID) and answer me if this number is valid or not with a char
ALTER FUNCTION CPF_VALIDO
(@CPF VARCHAR(11))

I have some huge problem in one of my store procedures
when i run it on sql it returns rowset fine
but when i run it from adp first it brings an error "Store procedure made
successfult but did not return any records"

I need to upload a .txt semicolon separated file (table) to sql server 2000.
Currently this is done via DTS and it works very well, but it would be more
convenient to do upload from the client if acceptable speed can be obtained.
The configuration is based on SQL Server 2000 and ...