Search results for query: *

I'm using access 2003 as the front end, linked to SQL Server 2005 for the back end. I would like to store scanned photos (jpg's); I do not want to just store the path name in the record, as the scanned photos are confidential (I dont want residing in any network folder). Has anyone got a code...

I have a linked table and a non-linked table, both of which have the same structure. I want to copy all of the records from the non-linked table to the linked table. The non-linked table can not become a linked table, as the user has to browse to it (there are many databases in many...

Is it possible to store a Windows Server user account in access table and have an application call those credentials to authenticate against a protected system?

This query works, but is really slow. Is there a better way to write it? I have 2 tables, Card and Shipped. For all cards, I am trying to insert a record into the Shipped table if it they are not already there: INSERT INTO SHIPPED (CardID, ShippedFrom, ShipDate, QtyShipped) SELECT...

When trying to use a table which is linked to our Buffalo location's (their internet is down today) access db, I get an error on the rst.open sql statement. The on error is not trapping this...what code can be written to catch this? Private Function RetrieveLinkedCCCRST(ByVal strSQLString As...

How would I have the printer ask the user to "switch paper to label paper"? Is there a way to set a specific report to print on label paper?