在Access中捕获照片 [英] capture photo in Access

问题描述

我正在尝试建立一个数据库，可以从

数码相机或网络摄像头捕捉静止图像并导入到数据库通过一个Object或

之类的东西。

任何帮助都会非常感激。


Rattanak

解决方案

2003年11月27日星期四01:40:11 -0600 comp.databases.ms-access，

" Rattanak曲" <到******** @ comcast.net>写道：

我正在尝试建立一个可以从数码相机或网络摄像头捕捉静止图像的数据库并通过Object或类似的东西导入数据库。
任何帮助都将非常感激。

你最好的是存储磁盘上的图片为jpgs，并且有一个

文本字段指向它们的位置，因为在$ / b $ b数据库中存储图像非常耗费资源。您可以使用图像控件来显示屏幕上的jpgs
。下面是一个批处理文件，用于从我的相机中获取

图片，现在大多数相机会在连接到PC时创建USB质量

存储设备，因此看起来像

可移动磁盘。路径名称可能需要更改以适应。


---开始download.bat -

@echo off

echo寻找对于相机...

设置d =

rem接下来两行换新闻阅读器

for %% i in（cdefghijklmnopqrstuvw xyz）do if

存在%% i：\ DCIM \100_FUJI \ * .jpg设置d = %% i


if（％d％）== （）goto error

echo off


for %% i in（* .jpg）如果存在％d％：\ DCIM \100_FUJI \\ \\ %%我转到冲突


dir％d％：\ DCIM \100_FUJI \ * .jpg

copy％d％：\ DCIM \ 100_FUJI \ * .jpg。

echo。

echo尝试从相机中移除照片

rem接下来两行换行于新闻阅读器

for %% i in（* .jpg）如果存在％d％：\ DCIM \100_FUJI \ %% i del

％d％：\ DCIM \ 100_FUJI \ %% i

echo fin。

echo。

如果存在％d％：\ DCIM \100_FUJI \\ \\ * .jpg echo图片仍然存在于相机上。

如果存在％d％：\ DCIM \100_FUJI \ * .jpg暂停

设置d =

转到eoj


：冲突

echo ***错误***

echo名称冲突存在

rem接下来两行换新闻阅读器

for %% i in（* .jpg）如果存在％d％：\ DCIM \100_FUJI \ %% i echo %%我已经

存在于硬盘上

rem接下来两行换行于新闻阅读器

echo你必须在下载之前解决这些冲突

地方

暂停

goto eoj

：错误

echo无法找到相机。

暂停


：eoj

---结束download.bat ---


-

A）bort，R）etry，I）用大锤子影响。

谢谢，
< br $> b $ b Rattanak


" Trevor Best" <摇椅@本地>在消息中写道

news：fm ******************************** @ 4ax.com ...

2003年11月27日星期四01:40:11 -0600 comp.databases.ms-access，
Rattanak Song <到******** @ comcast.net>写道：

我正在尝试建立一个可以从数码相机或网络摄像头捕捉静止图像的数据库并通过Object或类似的东西导入数据库。
任何帮助都将非常感激。

最好的办法是将图片存储在磁盘上作为jpgs并且有一个
文本字段指向它们的位置，因为在
数据库中存储图像是非常耗费资源的。您可以使用图像控件在屏幕上显示jpgs。下面是我用来从相机中取出照片的批处理文件，现在大多数相机会在连接到PC时创建一个USB质量存储设备，因此看起来像一个可移动磁盘。路径名称可能需要更改以适应。

---开始download.bat -
@echo off
echo寻找相机......
设置d =
rem下两行换新闻阅读器
for %% i in（cdefghijklmnopqrstuvw xyz）如果
存在%% i：\ DCIM \100_FUJI \ * .jpg set d =％ ％i

如果（％d％）==（）转到错误
回复

对于%% i in（* .jpg）如果存在％ d％：\ DCIM \100_FUJI \ %%我转到了冲突

dir％d％：\ DCIM \100_FUJI \ * .jpg
复制％d％：\\ \\ DCM \ 100_FUJI \ * .jpg。
回声。
回声尝试从相机中移除照片
rem接下来的两行换行于新闻阅读器
for %% i in（*。 jpg）如果存在％d％：\ DCIM \ 100_FUJI \ %% i del
％d％：\ DCIM \100_FUJI \ %% i
echo fin。
echo。
如果存在％d％：\ DCIM \ 100_FUJI \ * .jpg echo图片仍然存在于相机上。
如果存在％d％：\ DCIM \100_FUJI \ * .jpg暂停
设置d =
g oto eoj
：冲突
echo ***错误***
echo名称冲突存在
rem下两行换行于新闻阅读器
for %%我在（* .jpg）如果存在％d％：\ DCIM \ 100_FUJI \ %%我回显%%我已经存在于HDD
rem下两行换行于新闻阅读器暂停


错误回复无法找到相机。暂停

：eoj
---结束download.bat ---

-
A）bort，R）etry，I用大锤敲击。

我找到了一个直接访问网络摄像头的示例数据库api和

你可以按下命令按钮拍摄照片并将其粘贴到

图像控件上。

我遇到了和你一样的问题这对我来说是一个很好的解决方案。


如果您有兴趣请告诉我，我会发给您一个

我ssage直接。


问候，


" Rattanak Song" <到******** @ comcast.net>在消息新闻中写道：< zM ******************** @ comcast.com> ...

谢谢，

Rattanak

Trevor Best <摇椅@本地>在消息中写道
新闻：fm ******************************** @ 4ax.com ... < blockquote class =post_quotes> 2003年11月27日星期四01:40:11 -0600 comp.databases.ms-access，
Rattanak Song <到******** @ comcast.net>写道：

我正在尝试建立一个可以从数码相机或网络摄像头捕捉静止图像的数据库并通过Object或类似的东西导入数据库。
任何帮助都将非常感激。

最好的办法是将图片存储在磁盘上作为jpgs并且有一个
文本字段指向它们的位置，因为在
数据库中存储图像是非常耗费资源的。您可以使用图像控件在屏幕上显示jpgs。下面是我用来从相机中取出照片的批处理文件，现在大多数相机会在连接到PC时创建一个USB质量存储设备，因此看起来像一个可移动磁盘。路径名称可能需要更改以适应。

---开始download.bat -
@echo off
echo寻找相机......
设置d =
rem下两行换新闻阅读器
for %% i in（cdefghijklmnopqrstuvw xyz）如果
存在%% i：\ DCIM \100_FUJI \ * .jpg set d =％ ％i

如果（％d％）==（）转到错误
回复

对于%% i in（* .jpg）如果存在％ d％：\ DCIM \100_FUJI \ %%我转到了冲突

dir％d％：\ DCIM \100_FUJI \ * .jpg
复制％d％：\\ \\ DCM \ 100_FUJI \ * .jpg。
回声。
回声尝试从相机中移除照片
rem接下来的两行换行于新闻阅读器
for %% i in（*。 jpg）如果存在％d％：\ DCIM \ 100_FUJI \ %% i del
％d％：\ DCIM \100_FUJI \ %% i
echo fin。
echo。
如果存在％d％：\ DCIM \ 100_FUJI \ * .jpg echo图片仍然存在于相机上。
如果存在％d％：\ DCIM \100_FUJI \ * .jpg暂停
设置d =
g oto eoj
：冲突
echo ***错误***
echo名称冲突存在
rem下两行换行于新闻阅读器
for %%我在（* .jpg）如果存在％d％：\ DCIM \ 100_FUJI \ %%我回显%%我已经存在于HDD
rem下两行换行于新闻阅读器暂停


错误回复无法找到相机。暂停

：eoj
---结束download.bat ---

-
A）bort，R）etry，I ）用大锤子冲击。

Hi,

I''m trying to build a database which can capture a still image from a
digital camera or web cam and import to the database via an Object or
something like that.
Any help would be very appreciated.

Rattanak

解决方案

On Thu, 27 Nov 2003 01:40:11 -0600 in comp.databases.ms-access,
"Rattanak Song" <to********@comcast.net> wrote:

Hi,

I''m trying to build a database which can capture a still image from a
digital camera or web cam and import to the database via an Object or
something like that.
Any help would be very appreciated.

Your best best is to store the pictures on disk as jpgs and have a
text field that points to their location as storing imagages in the
database is very resource hungry. You can use the image control to
display the jpgs on the screen. Below is a batch file I use to get
pictures off my camera, most cameras nowadays will create a USB mass
storage device when connected to the PC so will appear like a
removable disk. Path names might want changing to suit.

--- begin download.bat --
@echo off
echo Looking for camera...
set d=
rem next two lines wrap in newsreader
for %%i in (c d e f g h i j k l m n o p q r s t u v w x y z) do if
exist %%i:\DCIM\100_FUJI\*.jpg set d=%%i

if (%d%)==() goto error
echo off

for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i goto conflict

dir %d%:\DCIM\100_FUJI\*.jpg
copy %d%:\DCIM\100_FUJI\*.jpg .
echo.
echo Attempting Remove pics from camera
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i del
%d%:\DCIM\100_FUJI\%%i
echo Fin.
echo.
if exist %d%:\DCIM\100_FUJI\*.jpg echo Pictures still exist on camera.
if exist %d%:\DCIM\100_FUJI\*.jpg pause
set d=
goto eoj

:conflict
echo *** Error ***
echo Name conflicts exist
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i echo %%i already
exists on HDD
rem next two lines wrap in newsreader
echo You must resolve these conflicts before this download can take
place
pause
goto eoj

:error
echo Cannot find camera.
pause

:eoj
--- end download.bat ---

--
A)bort, R)etry, I)nfluence with large hammer.

Thanks,

Rattanak

"Trevor Best" <bouncer@localhost> wrote in message
news:fm********************************@4ax.com...

On Thu, 27 Nov 2003 01:40:11 -0600 in comp.databases.ms-access,
"Rattanak Song" <to********@comcast.net> wrote:

Hi,

I''m trying to build a database which can capture a still image from a
digital camera or web cam and import to the database via an Object or
something like that.
Any help would be very appreciated.

Your best best is to store the pictures on disk as jpgs and have a
text field that points to their location as storing imagages in the
database is very resource hungry. You can use the image control to
display the jpgs on the screen. Below is a batch file I use to get
pictures off my camera, most cameras nowadays will create a USB mass
storage device when connected to the PC so will appear like a
removable disk. Path names might want changing to suit.

--- begin download.bat --
@echo off
echo Looking for camera...
set d=
rem next two lines wrap in newsreader
for %%i in (c d e f g h i j k l m n o p q r s t u v w x y z) do if
exist %%i:\DCIM\100_FUJI\*.jpg set d=%%i

if (%d%)==() goto error
echo off

for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i goto conflict

dir %d%:\DCIM\100_FUJI\*.jpg
copy %d%:\DCIM\100_FUJI\*.jpg .
echo.
echo Attempting Remove pics from camera
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i del
%d%:\DCIM\100_FUJI\%%i
echo Fin.
echo.
if exist %d%:\DCIM\100_FUJI\*.jpg echo Pictures still exist on camera.
if exist %d%:\DCIM\100_FUJI\*.jpg pause
set d=
goto eoj

:conflict
echo *** Error ***
echo Name conflicts exist
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i echo %%i already
exists on HDD
rem next two lines wrap in newsreader
echo You must resolve these conflicts before this download can take
place
pause
goto eoj

:error
echo Cannot find camera.
pause

:eoj
--- end download.bat ---

--
A)bort, R)etry, I)nfluence with large hammer.

Hi,

I found a sample database that access directly to a webcams api and
you can capture a photo pushing a command button and paste it to an
image control.
I got the same problem as you and this was a great solution for me.

Please, let me know if you are interested on it and I will send you a
message directly.

Regards,

"Rattanak Song" <to********@comcast.net> wrote in message news:<zM********************@comcast.com>...

Thanks,

Rattanak

"Trevor Best" <bouncer@localhost> wrote in message
news:fm********************************@4ax.com...

On Thu, 27 Nov 2003 01:40:11 -0600 in comp.databases.ms-access,
"Rattanak Song" <to********@comcast.net> wrote:

Hi,

I''m trying to build a database which can capture a still image from a
digital camera or web cam and import to the database via an Object or
something like that.
Any help would be very appreciated.

Your best best is to store the pictures on disk as jpgs and have a
text field that points to their location as storing imagages in the
database is very resource hungry. You can use the image control to
display the jpgs on the screen. Below is a batch file I use to get
pictures off my camera, most cameras nowadays will create a USB mass
storage device when connected to the PC so will appear like a
removable disk. Path names might want changing to suit.

--- begin download.bat --
@echo off
echo Looking for camera...
set d=
rem next two lines wrap in newsreader
for %%i in (c d e f g h i j k l m n o p q r s t u v w x y z) do if
exist %%i:\DCIM\100_FUJI\*.jpg set d=%%i

if (%d%)==() goto error
echo off

for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i goto conflict

dir %d%:\DCIM\100_FUJI\*.jpg
copy %d%:\DCIM\100_FUJI\*.jpg .
echo.
echo Attempting Remove pics from camera
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i del
%d%:\DCIM\100_FUJI\%%i
echo Fin.
echo.
if exist %d%:\DCIM\100_FUJI\*.jpg echo Pictures still exist on camera.
if exist %d%:\DCIM\100_FUJI\*.jpg pause
set d=
goto eoj

:conflict
echo *** Error ***
echo Name conflicts exist
rem next two lines wrap in newsreader
for %%i in (*.jpg) do if exist %d%:\DCIM\100_FUJI\%%i echo %%i already
exists on HDD
rem next two lines wrap in newsreader
echo You must resolve these conflicts before this download can take
place
pause
goto eoj

:error
echo Cannot find camera.
pause

:eoj
--- end download.bat ---

--
A)bort, R)etry, I)nfluence with large hammer.

这篇关于在Access中捕获照片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！