Can't Backup database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • fstenoughsnoopy@yahoo.com
    #1

    Can't Backup database

    I have a database on a server, not split into FE/BE and it has the user
    level security set up. I do have one problem. I need to back up the
    database. According to Microsoft and other books and links I've read,
    the should be a Back Up Database link under the File button at the top
    of Access. However, I dont see it anywhere. I tried backing it up using
    Windows back up and recovery, but would like something more accessible.
    Please let me know if you can help me.

    Tags: None
    • Fred Zuckerman
      #2
      Re: Can't Backup database

      You can just use the regular "copy" feature in windows, or a DOS batch file.
      You should copy the "mdb" file and the "mdw" file.
      Fred Zuckerman

      <fstenoughsnoop y@yahoo.comwrot e in message
      news:1156431742 .985617.116030@ 74g2000cwt.goog legroups.com...
      I have a database on a server, not split into FE/BE and it has the user
      level security set up. I do have one problem. I need to back up the
      database. According to Microsoft and other books and links I've read,
      the should be a Back Up Database link under the File button at the top
      of Access. However, I dont see it anywhere. I tried backing it up using
      Windows back up and recovery, but would like something more accessible.
      Please let me know if you can help me.
      >

        Comment

        • fstenoughsnoopy@yahoo.com
          #3
          Re: Can't Backup database

          I tried, however if the server goes down and i try running that backup,
          it says that it needs the server to access the file. i need the copy so
          that we can access the info when the server is down or for working on
          it at home.

          Fred Zuckerman wrote:
          You can just use the regular "copy" feature in windows, or a DOS batch file.
          You should copy the "mdb" file and the "mdw" file.
          Fred Zuckerman
          >
          <fstenoughsnoop y@yahoo.comwrot e in message
          news:1156431742 .985617.116030@ 74g2000cwt.goog legroups.com...
          I have a database on a server, not split into FE/BE and it has the user
          level security set up. I do have one problem. I need to back up the
          database. According to Microsoft and other books and links I've read,
          the should be a Back Up Database link under the File button at the top
          of Access. However, I dont see it anywhere. I tried backing it up using
          Windows back up and recovery, but would like something more accessible.
          Please let me know if you can help me.

            Comment

            • Fred Zuckerman
              #4
              Re: Can't Backup database

              I do it all the time. So there must be something else....
              What >exactly< does the error message say?

              1. Does your database have all its tables internal, or do you have external
              links to other data sources?
              2. Since you have user-level security, you are probably using a shortcut to
              open the database and the workgroup file. Be sure to review the CmdLine in
              the shortcut to confirm that it:
              a) references MSACCESS.exe on the local disk
              b) references the proper mdb
              c) references the proper mdw
              3. When you attempt to use your backup copy, then you need a different
              shortcut that points to the backup copies.
              Good Luck,
              Fred Zuckerman


              <fstenoughsnoop y@yahoo.comwrot e in message
              news:1156436420 .472769.82760@m 73g2000cwd.goog legroups.com...
              I tried, however if the server goes down and i try running that backup,
              it says that it needs the server to access the file. i need the copy so
              that we can access the info when the server is down or for working on
              it at home.
              >
              Fred Zuckerman wrote:
              You can just use the regular "copy" feature in windows, or a DOS batch
              file.
              You should copy the "mdb" file and the "mdw" file.
              Fred Zuckerman

              <fstenoughsnoop y@yahoo.comwrot e in message
              news:1156431742 .985617.116030@ 74g2000cwt.goog legroups.com...
              I have a database on a server, not split into FE/BE and it has the
              user
              level security set up. I do have one problem. I need to back up the
              database. According to Microsoft and other books and links I've read,
              the should be a Back Up Database link under the File button at the top
              of Access. However, I dont see it anywhere. I tried backing it up
              using
              Windows back up and recovery, but would like something more
              accessible.
              Please let me know if you can help me.
              >
              >

                Comment

                • Rick
                  #5
                  Re: Can't Backup database


                  The Backup database is under Tools - Database Utilities

                    Comment

                    Previous template Next
                    Working...