Results 1 to 2 of 2

Creating a local network Database

  1. #1
    blukit01 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    1

    Creating a local network Database

    Hello!

    At my work I recently created a database to organize our inventory of products. We work at 5 people and 5 PCs here.
    The database programming is ready, but I need to create a front-end (interface) for my coworkers use and update the database, and share on the local network. My computer was going to be used as the server for this database.

    I'm a beginner at access. Is it too dificult to do it by myself?

    Thank you!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,104
    Shouldn't be, no. I believe there is a splitter wizard, though I've never used it. You can also simply export the tables from your database into a new database, call it "DatabaseName_BE" or whatever. Delete the tables from the original database, then go to the External Data tab and click on the Access icon in the Import area. You will be given the choice to import or link, and you want link. Do all this on a copy of your database, in case it all goes horribly wrong.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating a table with local and external data
    By Accessnoooob in forum Access
    Replies: 8
    Last Post: 06-25-2011, 06:36 PM
  2. Pass Through Queries - Local and Network Tables
    By vinfurnier in forum Queries
    Replies: 1
    Last Post: 03-31-2011, 10:18 AM
  3. Unable to open Access on Local Area Network
    By MikeWaring in forum Security
    Replies: 1
    Last Post: 12-24-2010, 09:46 AM
  4. Putting a Finished Database up on the Network
    By Imgsolutions in forum Access
    Replies: 1
    Last Post: 07-14-2010, 02:56 AM
  5. Setting up a simple database on a network
    By crunch in forum Access
    Replies: 10
    Last Post: 07-12-2010, 12:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums