Access DB questions

2 Jul 2005 5:02 PM

james

Hi, I am working on a conversion project from an older Database system (Dataflex), that stored each datatable in seperate files.
I am trying to decide which is faster in Access. Continue to use the same
method of data access, putting each table in seperate Access db files, or put all the tables in a single
Access mdb file. As it is, I am doing like the original application did and opening each table with seperate connections. Since
the application has 63 different tables (some with 22,000 rows or more) I am not sure which method would be faster. I do think
that having to only make a single connection might be faster. But, I am not sure how much faster.
james

2 Jul 2005 5:28 PM

Armin Zingler

Show quote Hide quote

"james" <jjames700ReMoVeMe at earthlink dot net> schrieb
> Hi, I am working on a conversion project from an older Database
> system (Dataflex), that stored each datatable in seperate files. I
> am trying to decide which is faster in Access. Continue to use the
> same
> method of data access, putting each table in seperate Access db
> files, or put all the tables in a single
> Access mdb file. As it is, I am doing like the original application
> did and opening each table with seperate connections. Since the
> application has 63 different tables (some with 22,000 rows or more)
> I am not sure which method would be faster. I do think that having
> to only make a single connection might be faster. But, I am not sure
> how much faster.
> james
>
>

Use one single database accessed by one connection. That's how it's done
usually. 22,000 rows are no problem at all, and 63 tables aren't either.

FYI, there's a group for ADO.Net related and languageindependent questions:
microsoft.public.dotnet.framework.adonet

Armin

2 Jul 2005 5:58 PM

james

"Armin Zingler" <az.nospam@freenet.de> wrote in message news:%23ol%23zuyfFHA.3316@TK2MSFTNGP14.phx.gbl...
> Use one single database accessed by one connection. That's how it's done usually. 22,000 rows are no problem at all, and 63
> tables aren't either.
>
> FYI, there's a group for ADO.Net related and languageindependent questions:
> microsoft.public.dotnet.framework.adonet
>
> Armin

Thanks Armin. I kind of thought that it would be better that way. The reason I asked here is I use VB.NET. But, I didn't think
about stating that.
I appreciate your response.
james

3 Jul 2005 6:53 AM

Cor Ligthert

Armin,

That FYI is a nice shortcut, I will use that in future as well.

Cor