Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Move database to laptop (Access 2000)

    Hi,

    I have a customer database that normally resides on the company server. It is a protected database, to which I have admin privileges. I normally enter the database by clicking a link on my destop that points to an .MDW file on the server. Access opens with a logon window, I enter username and password and I'm done.

    I would like to move the database to a laptop so that I can use it when I am out of the office. I have copied both the .MDW file and the main .MDB database from the server to the laptop. But now when I click on the MDW file Access opens with a workgroup information database. If i click on the main MDB file, a window opens that says I do not have the necessary authorization to ope the object. I don't get a logon window at all.

    I am confused <img src=/S/confused.gif border=0 alt=confused width=15 height=20> . How can I enter my database on the laptop?

    Daniele

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Move database to laptop (Access 2000)

    Hello Daniele,

    Welcome to Woody's Lounge.

    You should create a shortcut on the desktop of your laptop that opens the database together with the .mdw file. The target of the shortcut should look like this, with the appropriate names and paths substituted:

    <code>"C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" "C:AccessMyDatabase.mdb" /wrkgrp "C:AccessSecured.mdw"</code>

    Always open the database using this shortcut instead of opening it (or the .mdw file) directly.

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Move database to laptop (Access 2000)

    That did it, Hans! Many thanks for your help!

    Ciao

    Daniele <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •