Split Access database with c#?

Question

0.00/5 (No votes)

See more:

C#

MS-Access

Hi,
I need split my Access db(size is near 2Gb),
is this possible with c#?
if it is true,How?

Posted 28-Jan-11 6:53am

MehranMsba

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2011-01-28T09:21:00

Solution 3

If after you compact the database and it's still too big...

If you're expecting an Access database to work as a set of multiple files, it won't. You cannot have a database span multiple files. You have simply outgrown the capacity of Access and need to upsize to some edition of SQL Server.

Posted 28-Jan-11 9:21am

Dave Kreskowiak

Comments

William Winner 28-Jan-11 18:19pm

Well, wouldn't that depend on the structure of the database? Realistically, since a database can have multiple tables, as long as the tables are stand-alone and don't have any joins, they could be in any number of files that you wanted them to be in.

But, yeah, he's outgrown Access if he's over 2 gigs.

Dave Kreskowiak 28-Jan-11 20:11pm

Do you really want to explain to him how to manage that nightmare? I sure don't.

It's a lot easier to migrate to a database engine that can handle his data requirements with a minimum of fuss.

William Winner 29-Jan-11 6:34am

I completely agree with you...which is why I didn't try to explain to him how to do it. But you made a blanket statement that said it couldn't be done, when in actuality, it can be. That was all I was saying.

Dave Kreskowiak 29-Jan-11 9:30am

I guess I meant something more like it should never BE done. I know you can link tables to tables in other files. It's just, UGH, too mind numbing to consider and mantain.

Espen Harlinn · Answer 2 · 2011-01-28T11:02:00

Solution 4

Here is a nice solution: Move the data to SQL Server Express[^] - Handles up to 10 GB, and when that becomes a problem you can upgrade the server.

Here is some more information:
Migrating to SQL Server 2008[^]

Regards
Espen Harlinn

Posted 28-Jan-11 11:02am

Espen Harlinn

William Winner · Answer 3 · 2011-01-28T06:59:00

Solution 1

Are you sure you need to split it? Have you tried compacting it first?

But, yes, it's possible...but a complete change in structure like that changes everything and takes a lot of thinking through the implications and the new structure.

Posted 28-Jan-11 6:59am

William Winner

Comments

fjdiewornncalwe 28-Jan-11 16:21pm

Comment from OP moved from answer:
ok,I will compact it but the db will be full finally.
Is any simple way to split or auto split a Access db ?
I never use ms access Mad !