0

I have created an application which reads ms access database file (test.accdb).

When i tested the application in my pc it worked fine.

But when i tried to run my application in different pc without installing ms office 2007 it does not read my database.

later when i installed ms office 2007 it worked for me.

Some people dont have ms office may be some people dont know about ms office. If they dont have ms office they need to download it from website which is more than 500 mb. Everyone Cant download it because its very big.they could have limited internet.

I want to read the database file without installing ms office 2007 in client pc.

Is there any code from which we can read it.

There would be great appreciation if someone could help me.

Thanks In Advance

Improve this question
9
  • msdn.microsoft.com/en-us/library/windows/desktop/… Commented Nov 23, 2011 at 17:04
  • 1
    It's also quite expensive to buy and distributing it like you're describing is illegal. Commented Nov 23, 2011 at 17:05
  • 3
    If you have users that don't have MS Office, maybe you shouldn't be using MS Access as a database format. Commented Nov 23, 2011 at 17:08
  • 2
    SQLite, SQL Server Express -- both better than Access, both free... Commented Nov 23, 2011 at 17:13
  • 1
    For the last 10+ years (and even win98SE) all versions of windows have shipped with the JET data engine. You NEVER needed Access installed to open and read mdb files. For Access 2007/2010 data formats there is a new data engine (including a 64 bit edition). For 2007/2010 accDB file then you need to install the ACE engine which is not part of windows install like JET was. This engine is free. Ignore the comments here from people who do not understand the difference between MS Access and what a database engine is. Commented Nov 24, 2011 at 19:03

1 Answer 1

Reset to default
1

How do you connect to the database? You should be able to ODBC into it. You will need to install the ODBC driver on the client machines though.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Just the connection string probably if you're not already using ODBC.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.