Cannot share an Access 2003 mdb file

Similar Threads:

1.Cannot import send/receive dates for emails stored in Access (.mdb) file

I have some mdb (Access format) database files with thousands of emails
extracted from couple of Yahoo groups forums.  I'd like to import these
into my Outlook 2003 PST so that I can search and read them offline.

The mdb files contain all the fields necessary for a proper email
import, including

from_name
from_email
subject
receive_date
receive_time
message (HTML format)

When I use the Outlook "Import and Export Wizard", selecting Access
file type, etc., all appears fine.  However, after the import
completes, in Outlook there is no date information populated under
either sent or received date.

If I use the "map custom fields" button on the import wizard, all of
the import file fields are shown correctly on the left hand "from" side
(as listed above) but on the right hand "to" side I only see the
following Outlook fields to map to:

subject
body
from/to/cc/bcc (name)
from/to/cc/bcc (address)
from/to/cc/bcc (type)
billing information
categories
importance
mileage
sensitivity

For whatever reason, THERE IS NO DATE FIELD to map to.

I can map date to something like "billing information" but that doesn't
help much

I appreciate any help or advice you can provide!

Thanks,

John

2.Error on starting: Excel cannot open Access MDB files directly

On Thu, 17 Jul 2003 08:29:11 -0700, "scott sampson"
< XXXX@XXXXX.COM > wrote:

>This error messsage occurs on starting Excel 2000: "Excel 
>cannot open Access MDB files directly". I have created 
>some queries in Excel to get external data from from a 
>database. But those queries shouldn't run when Excel 
>starts. 

Find a folder called xlStart. (The path to the folder will vary; just
use Find or Search (depending on your version of Windows) from your
Start menu to locate it.) Files in that folder are automatically
loaded when Excel starts, and if you've accidentally stored an Access
database file (an .mdb) in there Excel will try to load it resulting
in the error that you describe. Just move the database file out of
there. (If you don't find it in the xlstart folder, also look in
Excel's Tools -> Options menu item, and check any folder which is
designated as an "Alternate startup location"; the .mdb file could be
in there.)

However in Excel 200*2*, doing that will result in something funky;
Excel will ask you to select a table from the database and it will
automatically create an external data link for you. (That's just
by-the-by, since you don't HAVE 2002... I just thought it was kinda
neat.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

3.cannot open Excel(*.xls) or Access(*.mdb) files in XPE, but OK in

Hello, everyone,

I have a problem in xpe need help. (maybe two).

I developed a win32 program with VC and MFC, in the application, I used 
CDatabase of MFC to open a Excel file (myfile.xls ) to read my prepreserved 
data, In the same application, I also used ADO (ActiveX Database Object) to 
open a Microsoft Access file (myfile2.mdb).

In My windows xp pro, my application runs just fine.  There is No Microsoft 
Office installed, my application do  open and read/write correct data from/to 
the Excel and Access files


Now when I move the application into XPE (xp embedded) platform, there are 
troubles..
The application shown errors when I€try to open and read/write Excel.

I imported the following component into xpe already:

Microsoft Data Access Componet DAC
Jet Database ODBC support  

Still, when trying to open the excel file (myfile.xls)
It said:

Could not find installable ISAM
Invalid connection string attribute FIRSTROWHASNAMES
Invalid connection string attribute CREATE_DB.

I checked, in my source code, my DSN related Excel is:

m_sDsn.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", m_sExcelDriver, m_sFile, m_sFile);




As for trying to open the Access fileyfile2.mdb

My code:
_ConnectionPtr	m_pConnection;
AfxOleInit();
	try                 
	{	
		m_pConnecti>n->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=d:\\dir\\myfile2.mdb","","",adModeUnknown);
		
	}
	catch(_com_error e)
	{
		CString str;
		str.Format("Error Message is %s",e.ErrorMessage());
		AfxMessageBox(str);
		return FALSE;
	}

I get error message:

Unknown Error 0x800A0E7A


But in XP pro, my whole application is just ok,,

Please tell me, what components I should import further.

I don believe I have to install Microsoft office or there is license 
problem, because on the xp pro platform, I did not install Microsoft office, 
it OK..

I don't know how to run FileMon in xpe as many poster mentioned,since my xpe 
system has no startup, no start screen alltogether, besides, i think Excel 
and Access files should be common files. the related component should be 
quite easy to locate, but I just don't know how. please help me.

Thank you very much!

Winston.

4.Sharing .MDB between Access 2.0 and Access 2003

I have a .MDB back-end database that is created with Access 2.0.
And multiple front-end mdb's, some are created by Access 2.0, and the
rest are created by Access 2003.
The fron-ends had table attachments to the back-end database.
The problem is I'm unable to access any table by both versions of
Access in the same time!

Here are the steps to replicate the problem

1- Open one Access 2.0 front-end mdb, then open the attached table T1
2- Open another Access 2003 front-end mdb, try to open the same
attached table, you will get the error "Could not use .mdb; file
already in use."
3- I can only open the table from Access 2.0 front-end.

It seems Access 2.0 locks the table against 2003 version only.

I'm trying to find a patch/service pack, workaround.
Your feed back is greatly appreciated.

Thanks,
Moor

5.I cannot create office 2003 files to win98 share folder

I cannot save as all excel and word file using office 2003 to share folder

Share folder using Win98 with Full Access

6. Excel cannot open Access MDB

7. Accessing .mdb file from Shared Drive by multiple Users

8. Cannot access My Documents share - Office 2003