Forum Replies Created

Viewing 15 posts - 16 through 30 (of 274 total)

  • RE: Export memo field to Excel truncates values

    Just noting that this is a thread where the last previous post was 7 years ago, so chances are his problem was solved a LONG time ago.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: The Android Car

    Having had a few months experience driving a Tesla, and another Tesla  and Ac Chevy Bolt driven by a other family members, I suspect the OS is a variant of...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Convert .adp to .accdb

    Here's another link at FMS that is more general and is also a well-balanced perspective on the various back-end approaches:
    When and How to Upsize Microsoft Access Databases...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Convert .adp to .accdb

    Yes, that is the approach we've used in nearly all the applications we've developed - use ODBC linked tables.  DAO is actually a method you can use to manipulate table...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Convert .adp to .accdb

    Well, as they say in some parts of the world, that a bit of a sticky wicket.  An upgrade to the latest version of Access forces a redesign - bummer.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Remove duplicates Access

    Well, it depends on your situation.  We started with SQL Server 4.7 and Access 2.0, and at that point the query tools in Access were much more friendly than the...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Remove duplicates Access

    Eirikur Eiriksson - Sunday, August 5, 2018 9:27 AM

    Access has always been a different thing/language from the SQL Server, just looking...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Remove duplicates Access

    It's quite easy to create a query that will identify duplicate records in Access, but deleting them is a more complicated process.

    Take a look at How...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: How do you have an append query run automatically based on a new record in table?

    DarthBurrito - Thursday, March 8, 2018 7:30 AM

    Here's a bit of a backstory of what's going on.
    We have AppX that uses Databasics...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: How do you have an append query run automatically based on a new record in table?

    DarthBurrito - Wednesday, March 7, 2018 12:19 PM

    Thanks all! Yeah, so all this is happening is in Access with Access tables.

    I seen...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: How do you have an append query run automatically based on a new record in table?

    DarthBurrito - Wednesday, March 7, 2018 9:39 AM

    Hope I explain it clear enough for people to understand what I'm trying to accomplish.

    I...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Migrated DB to 2016, having ODBC Access problem

    It appears that that user is a SQL Server user, not a network user.  Your linked tables show Integrated Security, so the user would be trying to connect with their...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Migrated DB to 2016, having ODBC Access problem

    briancampbellmcad - Tuesday, February 13, 2018 1:02 PM

    Here's what's in the MSysObjects Connect field: DSN=CPCE_Copy;Description=CPCE_Copy;Trusted_Connection=Yes;APP=Microsoft Office 2010;DATABASE=CPCE_DB;

    OK, I think Sue may have...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: Migrated DB to 2016, having ODBC Access problem

    briancampbellmcad - Monday, February 5, 2018 6:41 AM

    I was able to get it working by correcting what I was naming in as...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • RE: best practices for Access to SQl conversion

    fizzleme - Thursday, September 21, 2017 3:14 PM

    You folks have been incredibly helpful.    Is there a URL describing how to create pass...

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

Viewing 15 posts - 16 through 30 (of 274 total)