access 2003 database, cannot open in access 2007

Posted on 2008-11-10
Last Modified: 2012-05-05
how can i access, access 2003 database, in access 2007
it give persmission error
attached error message
Question by:ammadeyy2020
    LVL 6

    Expert Comment

    by:Leon Teale
    silly question but do you have permissions?

    maybe the document is locked?

    try importing the data rather than opeing it to see if you can actually view the data?
    LVL 65

    Expert Comment

    Are you using mdw files?

    The folder that the database is on, do you have write permissions to that folder? I see its on the desktop for the administrator. Have you logged in as the administrator?

    Author Comment

    that folder there is mdw file also
    yes im on administrator account, and its on desktop folder,
    LVL 65

    Accepted Solution

    Did u try to convert this to 2007 format? I believe security is now redundant in that or open the mdb inside 2007. Maybe you need to specify the path of the mdw file then

    "msaccess path" "c:\mydb.mdb" /wrkgrp "c:\mydb.mdw"

    replace "msaccess path" with the full path of msaccess.exe (2007 version) eg c:\program files\microsoft office\...

    replace c:\mydb.mdb with your path c:\documents and settings\administrator etc

    and the same with c:\mydb.mdw

    Best to create a shortcut to do this


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now