Results 1 to 3 of 3
  1. #1
    shexe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    71

    Data Connection Issue

    Hello,
    I am having issues connecting an Excel workbook to a Query in my Access DB. The query does use a WHERE clause, I am wondering if this is the cause of my issues.



    Currently, the connection is live, but is not displaying the data that is in the query.

    Any ideas?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    What do you mean by connection? A LINK?

  3. #3
    shexe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    71
    By connection I mean I have a Connection String that pulls data from Access into Excel. See below.

    Connection string:
    Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=H:\Resource Planning\DSN\ResourcePlanning_DEV_Backup.accdb;Mod e=Read;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=6;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unable to enter data - security issue?
    By Huddle in forum Forms
    Replies: 2
    Last Post: 09-13-2010, 08:51 AM
  2. Report Data Field Issue
    By SilverSN95 in forum Access
    Replies: 3
    Last Post: 07-23-2010, 07:53 AM
  3. Web Connection to Access2007 issue?
    By springfield102 in forum Access
    Replies: 3
    Last Post: 06-24-2010, 05:07 AM
  4. Access data page connection to MySQL
    By dkperez in forum Access
    Replies: 1
    Last Post: 09-29-2009, 06:02 AM
  5. Subform Data Entry Issue
    By yuriyl in forum Forms
    Replies: 3
    Last Post: 05-14-2009, 08:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums