Good afternoon
I using the following function to get the login from Windows XP
ALTER FUNCTION dbo.iLogin ()
RETURNS varchar(30)

We have been building databases for replication and therefore using primary
keys of type uniqueidentifier. The GUI is developed in Microsoft Access 2003,
which doesn’t seem to allow us to insert NULL values into the foreign keys
(of type uniqueidentifier) that reference these ...

hey i'm trying to group by a doctor's last and first name is this possible
here is my sql i'm using...
SELECT DOC_FIRSTNAME, doctor_matrix.DOC_ID, DOC_PHOTO, DOC_LASTNAME,
VISIBLE_ID,  DOC_TITLE, doctor_matrix.DEPTCONTACT_ID

Can I link tables from SQL Server 2000 into Access 97???
Thanks!
Domac

is it possible with code to test the connection to sql and return some type
of prompt to choose the correct sql server or atleast prevent access from
trying to connect to a non-existant sql connection?

Hi. I have a client with an Access 2003 adp frontend to a SQL server
2000 backend.  They want to be able to print a record directly from the
form, however, every time on any computer that this is attempted,
Access crashes.  I have searched for this specific problem, but have

In adp's the forms Recordset and RecordsetClone do not reflect sorting and
filtering made by the user on the form. Thus, if you try to select records
based on the SelTop and SelHight properties of the form you might get the
wrong records.

Hi Experts,
I would like to use  the sp "sp_routeStat_CTY_Total_TestForm" as data
source for the form "Ufo_Test" with the input paramter "@LAND".
But after I did so, all controls of the form desappeared during run

I have a simple data base:
Date   Job #     Hours     Emp #
I need to be able to have a query that will give me a running total of job
hours per job even if I specify a date range.