Results 1 to 4 of 4

Thread: Help with Ms Access

  1. Aug 24th, 2004, 05:32 AM #1
    sinha
    sinha is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Malaysia
    Posts
    345

    Help with Ms Access

    I am facing a typical problem. I have made a clinical application on VB 6.0 and MS access as backend. Now, at one of the client places, I am not able to open the database(cannot see the table structure). This client was using it for 1.3 years and the databse size exceeded up to 34 MB. Suddenly they were not able to log in to the application. When I wanted to see the data in the table by opening the database, I was not able to do so. MS Access application is opened but I am not able to see any of the tables. Whats the problem? Has it been corrupted. Whats the way out? Pls help.
    Thanks.
    Reply With Quote Reply With Quote
  2. Aug 24th, 2004, 08:06 AM #2
    DaveBo
    DaveBo is offline
    Hyperactive Member
    Join Date
    Apr 2001
    Location
    N42 29.340 W71 53.215
    Posts
    422

    Compact & Repair?

    Have you tried ensuring nobody's using it then doing a compact & repair?

    Also, "The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x."

    Have you tried importing the table into another DB?
    Last edited by DaveBo; Aug 24th, 2004 at 08:09 AM.
    "The wise man doesn't know all the answers, but he knows where to find them."
    VBForums is one place, but for the really important stuff ... here's a clue 1Tim3:15
    Reply With Quote Reply With Quote
  3. Aug 24th, 2004, 11:32 AM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    If you don't already have a backup of the db, then make one
    BEFORE you do anything!!! Then like DaveBo said do a compact
    and repair and if you can see the tables after that try exporting
    all objects to a new blank db.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Aug 27th, 2004, 12:06 AM #4
    sinha
    sinha is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Malaysia
    Posts
    345
    Compact of Repair of MS access is not giving any result. I tried some demo versions of Access Repaiir tools. They are able to repair but comes with a cost. Is there any free tool for this.
    Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width