Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Imported data (2003)

    Good morning,
    I am new to this forum and access as well. I am having a problem. I imported an excel file into access and created a form. I am now trying to save the table and form to a network server. Could someone please help?

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

    Re: Imported data (2003)

    Welcome to Woody's Lounge!

    Access stores all objects that logically belong together in a single file called a "database". An Access 2003 database has extension .mdb, for example MyFile.mdb.
    A database can contain tables, queries, forms, reports, macros and VBA code modules. So you can copy your database (.mdb) to a shared folder on the network.
    In other words, you don't save the table and form in separate files, they are stored in the single database file.

    (Later on, you may want to split your database into two databases, a backend database with only tables, and a frontend that is linked to the backend and that contains queries, forms, reports etc. You can read about this in Why Split a Database? by our moderator <!profile=WendellB>WendellB<!/profile>. But for the moment, I'd concentrate on getting the database to work the way you want.)

  3. #3
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    Thank you. I was trying to save the whole access page but, I was going about it the wrong way. I even tried to email it but, I was getting an error message. The attachment was considered potentially harmful and was deleted.

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

    Re: Imported data (2003)

    You generally can't attach .mdb files to an e-mail (and to a post here in Woody's Lounge). The workaround is to create a zip file (compressed folder) containing the .mdb file. You can always attach a zip file, and as an added bonus, the zip file will be considerably smaller than the .mdb file itself.

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

    Re: Imported data (2003)

    Where exactly did you get the error "not a valid path"?

  6. #6
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    I tried saving the whole thing, copying it and pasting it on the server, didn't work. Getting error message not a valid path.

  7. #7
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    On the server when someone tried to open it.

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

    Re: Imported data (2003)

    Does the user have sufficient permissions? Users need to have modify permissions (read/write/create/delete) on the folder that contains the database.

  9. #9
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    Permissions? I put a password on the database but, that is all. Only one other person has the password and he is the one who can not open the file.

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

    Re: Imported data (2003)

    Are you sure that you placed the database itself on the server, and not a shortcut that refers to your own copy?

  11. #11
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    Maybe, that is what happened. I had the database open and selected save as, named the fila and saved it on the server. Do you have any suggestions on a different way to save the file?

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

    Re: Imported data (2003)

    You shouldn't save from within the database. That will only save one of the database objects, not the entire database.

    Do the following instead:
    - Quit Access.
    - Open Windows Explorer.
    - Navigate to the folder where you created your database. By default, it'll be in your "My documents" folder.
    - Select the .mdb file, and press Ctrl+C to copy it to the clipboard.
    - Navigate to the network folder.
    - Press Ctrl+V to paste the database.

  13. #13
    New Lounger
    Join Date
    Dec 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Imported data (2003)

    Sorry, been out of work. Let me see if that fixes the problem.Thank you

Posting Permissions

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