Is there any function to extract the path and filename of embbeded image from MSAccess OLE field.
Any help will be highly appreciated.
Thanks in advance.

I everyday import data to my database from Excel files
using an append query. Everything worked fine till today.
Now I every time receive message as follows:
"Error 3349 Number field overfilled" (I receive this

I am not certain this is the right area to post these
questions, so if not let me know where I should post them.
I am using the Access 2002. The database is split into
frontend MDE and backend MDB.

I'm using the 2003 new function ExportXML and i've the following
problem. If i export the data of a table, for all fields that have no
entry (null) the XML-Tag doesn't appear in the xml-File.
e.g

Anyone know what run-time error 31519 means?  i get this
when importing data.
Thanks in advance

On a linked table:
Has anyone found a way to allow "/" entered as a user name
( leaving the password blank ) when promped from oracle
authentication. I am trying to allow authentication from

I am importing data from textfiles on a server. Because
these textfiles have an extention which is unknown by
Access )no extention at all) i first copy these files to
another directory using the VBA.FileSystem.FileCopy

I need help - I have been pulling my hair out over this
for days. We have recently upgraded our systems to windows
XP from 2000 and now the following VBA code does not work.
strSQL = "SELECT sales_invoice.invoice_id,invoice_no

I have a database with a table for Groups and one for Subscribers in those
groups (one to many). I need to create 2 ASCII files the merge them to email
to another location.
The first table is fixed width with my sender ID in it followed by a

I have an MS Access 2k front end connected to an MS SQL 2000 back end.
All of my tables are indexed appropirately and they link and are updateable.
I have a view that I need to link.
When I link it manually, I can select the field that makes the recrod unique

I am importing 111 field names from a raw data file.  The
file specs will not allow me to save over 30 field names.  Why?

I export an a2k table to a .txt file using Transfer Text in
a macro with a file spec.  All is well except I need the
amount fields (defined in the spec files as Double) to be
right justified.  They come out left justified.  I want the

We have an access 2000 database with with 20 or so tables to keep track of
our inventory.  Not long ago I was asked to put a copy on a laptop so the
database could be taken to several remote locations and the information
updated.  Ok, so I was in a hurry because it was just before ...

I have created a basic satellite feed logging database. A
report is extracted and posted on our local network
Outlook Public Folders.  This is achieved using a macro
and the SendObject command to send a report.  This works

I am trying to link to a table in oracle database from
access 2000. This linked table happens to have a CLOB
datatype as one of its field. Access converts this to a
Text field and when selected from this table, I get an