Consulting

Results 1 to 2 of 2

Thread: split database with table import errors

  1. #1
    VBAX Tutor
    Joined
    Nov 2007
    Posts
    291
    Location

    split database with table import errors

    Hello,

    I have a database into which I import a series of files using saved imports.

    Some of the files give import errors which create and error table in Access. I dont care much about these as I dont use the the data in that field just yet (I could just not import that field but I may need some of the non violating data later).

    I split the database but when I run the saved imports it wont work for the tables that have the errors.

    Is this just the behaviour with a split database/linked tables.............wont it create the same error tables which you can handle.................or will it just not work at all

    Cheers

  2. #2
    VBAX Regular
    Joined
    Jun 2009
    Location
    Dorset
    Posts
    60
    Location
    I would try re-creating the saved import as Access doesn't like it if you when you change things.
    Regards
    JD
    ------------------------------------
    Software-Matters
    Dorset

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •