Recent content by mondo3a

Thank...that seemed to work. I appreciate all of your help!!

ok...I changed the field type to Image, and it seemed to save it. Hate to ask, but what would be the code to retrieve it and place it into an image box?

I just realized that we're using sql server standard edition (2000?) and not 2005 like I said above. discovered this when i unsuccessfully tried to change field from 8000 to varbinary(max). Is there a different field type I can/should be using?

Thanks for the help. I tried the code (modified a bit), but i get an error. Here's the code: Dim strSQL As String Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim mstream As ADODB.Stream Set cn = CurrentProject.Connection strSQL = "SELECT testid, photo, notes FROM tbltest...

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...

The TransferDatabase command worked perfectly and solved the problem. Thanks!

I had tried that, and it comes up with an error like "unknown database". I think that's because the 2 databases are in different locations and connected to with two different ADODB.Connections. now if there's a way to write that query to use a full path name, then it might work, but i dont...

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...

I want to authenticate against local credentials. I have two domains in which there is no trust between them. Basically a local domain and DMZ webserver. I want to store the credentials of a local user from the webserver in the database located in the local domain so that the database would...

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?

Thanks everyone. The query now runs in seconds instead of minutes!

I used the Left because I wanted all the Cards that were in the Shipped table in that part of the query, but it should have been an inner join.

Is this close to what you mean? Doesn't seem to do anything: INSERT into SHIPPED (CardID, ShippedFrom, ShipDate, QtyShipped) SELECT A.CardID,'Wpg',#1/1/2007#,0 FROM Card A INNER JOIN Shipped B on A.CardID = B.CardID WHERE B.ShippedFrom='Wpg' AND B.ShipDate=#1/1/2007# AND A.SystemID = 45...

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...

That seems to work...thanks for all of your help!