[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • 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.
0
9XqUwH3S
Asked:
9XqUwH3S
  • 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
0
 
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.
0
 
Glen KnightCommented:
Or MySQL which is completely free.
0
 
9XqUwH3SAuthor Commented:
Both accepted because they're both relevant for me. Thanks, guys!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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