Must I own a copy of MS SQL Server to employ a 2- user split database over a network for personal use?

Posted on 2009-12-20
Last Modified: 2013-11-29
I want my girlfriend and I to be able to access my database (kinky). I want the table/tables on a logical drive on my partition on my laptop (kinkier still). Access 2007 is not a database server I am made to understand.

Do I need some version of MS SQL Server on my laptop? We both have Access 2007. I have a Verizon Wireless air card connection which I suspect will be a problem, and she uses a home wifi network through the phone company, which might also be a problem.

I want her to be able to update a record and it all reside on my laptop where the tables reside. This presumes that we are both connected to the net. I'm suspecting that this is the kind of scenario that Sharepoint was designed for.

I'm a newbie here so go easy on the techno-talk if you can. Thanks

What kind of software/hardware is necessary to do this. I should say the biggest reason for doing this is bragging rights, okay. The database in question will be very simple.

Some men brag about this, some men brag about that. I brag about stuff I figure out. However, I'll be sure to list you-all in the credits.
Question by:9XqUwH3S
    LVL 74

    Accepted Solution

    No Access can create multi user databases using the Split Database Wizard, see here:
    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    If you're going to be working via a wireless network, then using Access as a data store would NOT be the best method. Access is a file-server type database engine, which doesn't work well over sporadic connections like a wireless.

    You would be much better off, in my opinion, to use SQL Server Express, which is free and much more robust in this scenario. It's easy to setup and can be run on a workstation.
    LVL 74

    Expert Comment

    by:Glen Knight
    Or MySQL which is completely free.

    Author Closing Comment

    Both accepted because they're both relevant for me. Thanks, guys!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now