Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Backing up Linked Databases (2k)

    I was wondering how to properly back up a linked database file. Edit: (specifically, the front-end part)

    I almost lost my database completely because a linked file was not exactly the same as the one it was looking for (although i don't know why it wasn't working). I was recieved errors saying that the name 'Drawing Table$.xls' could not be found and the database wouldn't load at all so i couldn't even try to fix it (why would access not atleast let me open the DB to fix this problem??). i tried to recreate the excel file to be exactly how it was when it was last working, and that seemed to get it back to the point where it atleast opened.

    So what i have is a server w/ 4 files on it. It has a copy of the front end that i will be giving out to everyone to function as the client (its only on the server until i give it out), a back end file, a security file, and an excel spreadsheet that is acting as a table (Drawing Table.xls). What messed it up was: I wanted to add one more description column to the spreadsheet, and a control on one of my forms to display it, but when i did that, thats when everything went wrong and i couldn't open it. I made a new control bounded to the new column on the spreadsheet, and it just wouldn't work. Note: the column i added was inserted between other existing columns, should i have just made a new column away from the others?

    so my questions are, why did this error occur? and how can i back up a front-end file so it will open even if someone screws up the backend file or something of that sort?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Backing up Linked Databases (2k)

    It must have been an unfortunate accident. Access should dynamically update a linked Excel table, even if its structure has been changed, for example by inserting a new column. If the error occurs again, there may be some kind of corruption in your database. It may help to import all database objects into a blank new database; don't forget to set startup options and references (if necessary) in the new database.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backing up Linked Databases (2k)

    Hans, slight question about that new database idea. I created a blank database, and access decided to take my security settings from one database... into every database. it seems as though security features in access for a database doesn't just affect the 1 database you set it for, it affects all DB's you create in access? slightly confused over this since my new blank DB asked me for an account/password...
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Backing up Linked Databases (2k)

    Security settings are stored in two places:
    - Users and groups, group memberships and user passwords are stored in a workgroup information file with extension .mdw. The default one is System.mdw.
    - Permissions on database objects are stored in the database itself.

    If you created and joined a new workgroup information file when setting up security the first time, you open all databases with that workgroup file, so you will be prompted for a user name and password. You can restore things to normal by re-joining the original unsecured System.mdw.

    If you set up security without creating a new workgroup information file, you have secured System.mdw itself. Use Windows Explorer to rename it or move it to another folder. Then start Access, it will automatically create a new unsecured System.mdw in the default location.

    You can open a database with a specific workgroup information file without actually joining it. See my replies in your thread <post#=387043>post 387043</post#>.

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backing up Linked Databases (2k)

    thanks for the help hans
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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