Recent content by eangles

  1. E

    Problem using Access .ADP to connect to SQL Server

    I did not note the "offenders", I was going to just add the comments back in. I'm sure the comments are fine because virtually all of my columns have them and the majority of the tables came into the .ADP without incident.
  2. E

    Problem using Access .ADP to connect to SQL Server

    I found the solution! The problem is with SQL's extended properties of the tables in question. There are some properties that Access does not recognize and therefore cannot open the table or produces an error. I started removing the extended properties until I found the offending culprits. I...
  3. E

    Problem using Access .ADP to connect to SQL Server

    I appreciate your reply. I honestly do not think it is a faulty install. In my case, the tables used to work just fine. I am not the only developer in the database, and I've been unable to determine when the symptoms started, but the point is that it used to work fine. There has to be something...
  4. E

    Problem using Access .ADP to connect to SQL Server

    I have recently run into the exact same problem using an Access 2003 .adp with sql server 2000. Have you been able to resolve the issue?
Back
Top