Results 1 to 5 of 5

Remove ODBC Connection and all imported Data

  1. #1
    rameshantony2000 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2019
    Posts
    2

    Remove ODBC Connection and all imported Data

    Dear Team members,

    Very new member here. Hope i will learn MS Access with help of team members soon.



    I've attached a access database. Can some one remove the ODBC connection and to break USers table to create new user ?

    Since the file size is more than minimum allowance of forum rules . Kindly drop an email will forward it along with the username and password.

    Thank you

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,216
    Quote Originally Posted by rameshantony2000 View Post
    Kindly drop an email will forward it along with the username and password.
    I can pretty much guarantee no one will send you their email.

    Do a "Compact and Repair", then compress it and try to attach it here.
    Aonther option is to use a file share program, such as "DropBox" or "Box".
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    rameshantony2000 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2019
    Posts
    2
    Dear Ssanfu,

    Good Idea. As advised, PFA https://drive.google.com/open?id=1hE...c1v5WZsXqNSoBl

    UN : MRamadan
    PW: MRamadan1

    Please remove all linked ODBC and also let me know how to change User authorization Like User name and password. When i tried opening user page some error. THanks in advance

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    19,996
    Post 3 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,216
    Quote Originally Posted by rameshantony2000 View Post
    ....Please remove all linked ODBC .....
    You only sent a link to download a HUGE Access BE (442.5MB).


    Click image for larger version. 

Name:	Presentation1.png 
Views:	9 
Size:	49.2 KB 
ID:	38446

    Normally, you would use an ODBC connection to link to a non Access database engine (SQL Server, MySQL, Oracle, etc.)
    If you are using SQL Server authentication, you would change the UI/PW in (for example) SQL Server. You might also have to edit the ODBC source and change the UI/PW. (IIRC)


    But you appear to have a table "Users" with fields for UserName and Password.



    Now I'm really confused.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2018, 04:15 PM
  2. ODBC Connection is Changing My Data Type
    By Enrightt in forum Access
    Replies: 3
    Last Post: 02-08-2018, 06:03 PM
  3. Replies: 3
    Last Post: 07-28-2014, 06:03 PM
  4. Replies: 8
    Last Post: 09-27-2012, 08:23 AM
  5. Replies: 3
    Last Post: 01-06-2012, 04:17 PM

Tags for this Thread

Posting Permissions

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