Access DB questions

[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

 

[Armin Zingler]

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

 

[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

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

 

[Cor Ligthert]

Armin,

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

Cor