Results 1 to 4 of 4
  1. 05-17-2017, 11:14 PM #1
    stephenaa5
    stephenaa5 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    72

    importing data requires open/close?

    Hi, all. I have an outside program, a JAR program, that inserts data into an access table. The oddity is that it is not visible in the table until one of two things happens. Either the program is opened and closed, OR a compact and repair is performed. This makes no sense to me. Does anyone have any insight? Obviously, this is a fundamentally untenable situation.



    Thanks!


    Thanks!
    Reply With Quote Reply With Quote
  2. 05-18-2017, 07:24 AM #2
    aytee111
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Did you try refresh?
    Reply With Quote Reply With Quote
  3. 05-18-2017, 08:04 AM #3
    Missinglinq's Avatar
    Missinglinq
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Or Requery?
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007
    Reply With Quote Reply With Quote
  4. 05-20-2017, 11:22 PM #4
    stephenaa5
    stephenaa5 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    72
    Yes, tried both. Finally gave up and moved the table to mysqL.. Problem went away. Odd.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Clearing filters on close or open
    By Kevin Ensign in forum Forms
    Replies: 14
    Last Post: 12-22-2016, 06:38 AM
  2. How can I get a form to open for final data entry after initiating database close?
    By bcmarshall in forum Access
    Replies: 7
    Last Post: 02-19-2016, 11:14 PM
  3. Close an open PDF file
    By StaceyE in forum Programming
    Replies: 2
    Last Post: 12-01-2015, 06:28 AM
  4. Code to open form, open a new record, input data, then close form
    By meissnerb in forum Programming
    Replies: 1
    Last Post: 05-03-2012, 02:25 PM
  5. DAO.Recordsets - When to close and open
    By jgelpi16 in forum Programming
    Replies: 11
    Last Post: 02-08-2011, 09:16 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums