• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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

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.
  • 2
2 Solutions
Glen KnightCommented:
No Access can create multi user databases using the Split Database Wizard, see here: http://www.databasedev.co.uk/split_a_database.html
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Glen KnightCommented:
Or MySQL which is completely free.
9XqUwH3SAuthor Commented:
Both accepted because they're both relevant for me. Thanks, guys!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now