Hi Pat,
Do the following:
- Install the latest version of the Microsoft JET Database Engine, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
- Re-register the file "DAO360.dll" as follows
+ Open windows explorer and locate the above file in the folder
C:\program files\common files\microsoft shared\dao
+ Click Start > Run
+ In the open run command line type regsvr32 followed by a space
+ Left click, drag, and drop the above file and place next to
the above typed so that it reads something like
regsvr32 "C:\program files\common files\microsoft
shared\dao\dao360.dll"
+ Click OK. Should receive message "...succeeded..."
- If still unable to import/export then use solution in the following
article to register the ISAMs
ACC2000: Error Message: Could Not Find Installable ISAM
http://support.microsoft.com/default.aspx?scid=kb;en-us;209805
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Pat H" <
[email protected]>
| Sender: "Pat H" <
[email protected]>
| Subject: Access 2002 will not open or import data from external source
| Date: Wed, 7 Apr 2004 00:13:28 -0700
| Lines: 17
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQcb9OQ4FVFZMTfRwOan7KNzQbQyQ==
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:29728
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| Hi all, any assistance would be greatly appreciated.
| I have a number of tests/queries I wish to run in MS
| Access 2002 to determine if the data I am using is
| correct - the data includes geographic reference
| information that I use with a mapping software. However,
| I cannot open, nor can I import data from any other
| external source without getting a 'type mismatch' error.
| The data does not import at all and upon 'ok ING' this
| error a table window,without data, opens
| titled 'mx_FrmMain:Form'. I have created a new .mdb with
| no tables/data and I have attempted to import .xls, .txt
| and other db file to no avail. I have even stripped off
| all field headings and changed all column attributes
| to 'general'. I have removed Access and reinstalled, but
| the error persists.
|
| Thanx Pat
|
