0

Is it possible?

I've tried Google, but I must be searching the wrong key words and not getting an answer.

I have a small application only being used by 2-3 people that I want to store data in a database for. I can't install any SQL servers so I thought access would be the best option.

The computers it will be used on don't have Access installed either.

I'm using VS2012 Express .net4.0

Improve this question
8
  • can't install any SQL servers why exactly? Price? Commented Mar 19, 2013 at 23:38
  • They'll be run on computers that don't have admin privledges to install anything. The application is a standalone .exe Commented Mar 19, 2013 at 23:40
  • There's lots of help here: connectionstrings.com/access-2007. If I were doing this today personally, I would use SQLite or SQL Server Compact instead. Commented Mar 19, 2013 at 23:40
  • 1
    There are other options - try SQL Compact or Sqlite Commented Mar 19, 2013 at 23:42
  • Will I be able to use SQLite/SQL Server Compact without having to install anything though? Commented Mar 19, 2013 at 23:50

1 Answer 1

Reset to default
1

Basically all you need is the connection string pointing to the access db with the right provider. Here's one that might work for you, just change the DB location to a shared place that the 2-3 computers can access:

var connection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\BC207\test.accdb")
Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

You need more than just a Connection object.
@RobertHarvey of course! but he's just asking if is possible to connect to an access DB in the scenario he presents, he's not asking for the current implementation so I just gave him breadcrumbs so he can find its way home :-)
No, that's good thanks. If there is something better that will fit my situation I'll galdly take it. But this does answer my original question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.