Access Import problem

From: GRayL (anonymous_at_discussions.microsoft.com)
Date: 02/07/04


Date: Sat, 7 Feb 2004 13:09:53 -0800

Theo: I've had several "weird" problems with Access and
have learned that often a database can become "broken"
and "repair and compact" under Tools does not fix it.
I've had to create a new db and import all tables,
queries, forms, reports, macros and modules. Similarly, a
compile error in any module can have far reaching effects.
Press Cntl-G to get to Visual Basic, Debug, and then
compile database. Any compile errors will show up here.
If that doesn't work, re-create the db. Good luck

Ray

>-----Original Message-----
>Up until wed feb 4 I was able to import files to access
>2000. As of then when I right click and select IMPORT
the
>window blinks open and closes immediately, not allowing
me
>to select the file to import. If I try to Link to a
file
>the Window stays open and allows the wizard to proceed.
>
>I've reinstalled office with no such luck.
>
>Any Ideas"
>
>.
>



Relevant Pages

  • Functions Not Working Anymore
    ... I have a database that we've been using for about a year and a half with no ... switchboard ("compile error") and a few of our reports ("function not ... fix this? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Run-time error 2450
    ... >* Microsoft Access may have encountered a compile error ... >> Does anyone know how to reference the value of a combo ... >> Dim dbMyDB As Database ...
    (microsoft.public.access.modulesdaovba)
  • RE: How to enter data into a table using a combobox
    ... I am having some issues with the NotInList function. ... > you don't need to mess with the database name. ... >> more luck. ...
    (microsoft.public.access.forms)
  • Re: search component using picture alternative text
    ... Its doesn't take luck. ... Here's a tidbit...put HTML comments into the fields of your database ... preventing their display. ...
    (microsoft.public.frontpage.programming)
  • Re: Compile error on common function, NOT REFERENCE PROBLEM
    ... Have tried to repair and compact the database? ... > but when using Mid in the query builder window in the criteria cell, ... > compile error on the 'net: Do the unchecking Missing References thing, ...
    (microsoft.public.access.modulesdaovba)