Is there a basic SQL command to insert an image using Jet SQL.
I tried the following in Access 2007:
----
CREATE TABLE Experiment
(
Field1 COUNTER (40),
Field2 IMAGE
);
-----
INSERT INTO Experiment (Field2)
Values ('C:\Users\Cecelia Allison\Desktop\Addy.bmp');
----
The field comes up as Long binary data and the image will not show up in a form.
Thanks!
Chillay
I tried the following in Access 2007:
----
CREATE TABLE Experiment
(
Field1 COUNTER (40),
Field2 IMAGE
);
-----
INSERT INTO Experiment (Field2)
Values ('C:\Users\Cecelia Allison\Desktop\Addy.bmp');
----
The field comes up as Long binary data and the image will not show up in a form.
Thanks!
Chillay