Results 1 to 11 of 11

Thread: [RESOLVED] Can't Open Access Database (2000) Using Office 2003

  1. Jun 7th, 2006, 01:50 PM #1
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Resolved [RESOLVED] Can't Open Access Database (2000) Using Office 2003

    For some reason, ever since I switched computers here at work from Windows 2000/Office 2000 to Windows Xp/Office 2003, I can't view one of my old databases.

    The old database is Access 2000 and seems to be the only one I'm having issues with when I try to open it using Access 2003. When I click on the database to open the file I get the following message.

    You do not have the necessary permissions to use <database name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

    Well, I have spoken with my system administrator (ME!), and I have "FULL CONTROL" on that file and the folder in which it resides.

    I need into this file, so any advice would be appreciated.

    Thanks!
    Reply With Quote Reply With Quote
  2. Jun 7th, 2006, 03:12 PM #2
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Can't Open Access Database (2000) Using Office 2003

    try starting a new database and import EVERYTHING into the new one from the old one.
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  3. Jun 7th, 2006, 05:07 PM #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

    Re: Can't Open Access Database (2000) Using Office 2003

    Did you set any user permissions inside Access? Are you running Access Workgroup Security?
    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. Jun 8th, 2006, 01:13 PM #4
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Re: Can't Open Access Database (2000) Using Office 2003

    Yes, I think my SYSTEM.MDW file is out of whack.

    I tried joining new workgroups but to no ovail.
    Reply With Quote Reply With Quote
  6. Jun 8th, 2006, 01:43 PM #5
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Can't Open Access Database (2000) Using Office 2003

    did u try the import trick?
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  7. Jun 9th, 2006, 01:38 PM #6
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Re: Can't Open Access Database (2000) Using Office 2003

    I tried to import it but I just get the same error, that I don't have the access.
    Reply With Quote Reply With Quote
  8. Jun 9th, 2006, 02:13 PM #7
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Can't Open Access Database (2000) Using Office 2003

    ?? really!? we used to do that all the time.. hmmm

    jetcomp it?

    is it a big DB? can u zip it and post it? (I have office 2k3 as well)
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  9. Jun 12th, 2006, 07:31 AM #8
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Re: Can't Open Access Database (2000) Using Office 2003

    Thanks for the help static.
    I can't post in on the forum because I work in a hospital and it contains patient names and a lot more. I'd PROBABLY get fired LOL.

    What's this JET trick you speak of?
    Reply With Quote Reply With Quote
  11. Jun 12th, 2006, 08:55 AM #9
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Can't Open Access Database (2000) Using Office 2003

    Have all computers in the company switched over to Office 2003?
    Reply With Quote Reply With Quote
  12. Jun 12th, 2006, 10:25 AM #10
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Re: Can't Open Access Database (2000) Using Office 2003

    No.
    I'm one of the first ones to switch. Actually, I think I am the first one.

    UPDATE:
    I got this working this morning, for those of you that care.
    The problem was the SYSTEM.MDW file on my machine. Earlier this morning I went to a co-workers computer (that COULD access the database) and copied her system.mdw file to my PC. Then I went in through Access and added myself to that workgroup. Bang-oh. Worked.

    Friggin' finnicky *******. Can you say ******* on the forums? LOL
    Last edited by The_Grudge; Jun 28th, 2006 at 08:12 AM.
    Reply With Quote Reply With Quote
  13. Jun 28th, 2006, 08:13 AM #11
    The_Grudge
    The_Grudge is offline

    Thread Starter
    Fanatic Member The_Grudge's Avatar
    Join Date
    Jan 2005
    Location
    Canada
    Posts
    836

    Re: [RESOLVED] Can't Open Access Database (2000) Using Office 2003

    Guess not. LOL.
    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