Data Access

[Raul]

I have an Application that accesses the data relatively fast when the data
sits on a local computer BUT very slow when the data sits on a network
drive.

Any ideas? Any INI, registry, etc suggestions?

Thanks,

Raul Rego
NJPIES

PS The data was accesed via Access 2003 MUCH fast than with Access 2007.

 

[Arvin Meyer [MVP]]

You may be not using the indexes and retrieving just the data you need, or
you may have a network problem. If all large files are slow on the network,
it is most likely the latter.

 

[Gina Whipp]

Raul,

You say 'the data', is the database split? And you might want to mention
what kind of network, might make a difference.

 

[Larry Linson]

I have an Application that accesses the data
relatively fast when the data sits on a local
computer BUT very slow when the data sits
on a network drive.

Two excellent sources of information on performance and avoiding corruption
in multiuser environments are MVP Tony Toew's site at
http://www.granite.ab.ca/accsmstr.htm and former MVP Jeff Conrad's site at
http://www.accessmvp.com/JConrad/accessjunkie.html.

As has already been noted, additional information would help us to help you.

Larry Linson
Microsoft Office Access MVP

 

[a a r o n . k e m p f]

Hey Arvin;

You can't get away with blaming everything on the network.

Jet doesnt' run over WAN, VPN, LAN or WIRELESS.

Maybe instead of blaming things on the network-- maybe, just maybe--
you'd all be much better off if you just moved to SQL Server.

 

[a a r o n . k e m p f]

WARNING!

TONY AND LARRY ARE KNOWN TROLLS AND ALWAYS RECCOMEND AN OBSOLETE
DATABASE (JET) EVEN WHEN THE REQUIREMENTS MEAN YOU SHOUDL BE USING SQL
SERVER.

Only someone who was too stupid to learn the 'worlds most popular
database (SQL Server)' would still be using Jet.

SQL Server is easier development than Jet.

-Aaron

 

[BruceM]

Raul,

A search of database threads will show you that the people other than Aaron
who posted in this thread have a long history of providing helpful advice,
while Aaron has a history of trashing Access and recommending SQL server no
matter the situation. Please note further that the others are invariably
courteous. Aaron, of course, is not.

message
WARNING!

TONY AND LARRY ARE KNOWN TROLLS AND ALWAYS RECCOMEND AN OBSOLETE
DATABASE (JET) EVEN WHEN THE REQUIREMENTS MEAN YOU SHOUDL BE USING SQL
SERVER.

Only someone who was too stupid to learn the 'worlds most popular
database (SQL Server)' would still be using Jet.

SQL Server is easier development than Jet.

-Aaron

 

[a a r o n . k e m p f]

BruceM has a history of trashing SQL Server and recommending Jet no
matter the situation.

Tony Toews has a history of trashing SQL Server and recommending Jet
no
matter the situation.

 

[BruceM]

Wrong. I have never trashed SQL server, and I have acknowledged that SQL
Server may be the better choice in some situations. However, Jet is also a
good choice in some situations for somebody who understands the basics of
database design.

message
BruceM has a history of trashing SQL Server and recommending Jet no
matter the situation.

Tony Toews has a history of trashing SQL Server and recommending Jet
no
matter the situation.

 

[a a r o n _ k e m p f]

you're wrong.

Jet is _NEVER_ a good choice, because SQL Server develoment is -
EASIER-.

-Aaron

 

[a a r o n _ k e m p f]

you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.
you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.
you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.

 

[Gina Whipp]

Someone sounds like they didn't get they wanted for Christmas! There is
still hope for next year so perhaps you should start by acting like the
adult you calim to be!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.
you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.
you sit there and say you don't trash SQL Server-- but any time that
anyone talks about SQL Server, you push them away from it.

 

[a a r o n _ k e m p f]

sounds to me like you should learn SQL Server

anyone using Jet in this day and age is just plain stupid.

It has proven that it is incapable of reliable, high performance
_SIMPLE_ database solutions for companies of any size.

Any company that gives a hoot has moved out from Access-- I can name a
handful of large companies in Seattle that have a strict _NO_JET_
policy.

-Aaron

 

[Gina Whipp]

Please DO name the Companies...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
sounds to me like you should learn SQL Server

anyone using Jet in this day and age is just plain stupid.

It has proven that it is incapable of reliable, high performance
_SIMPLE_ database solutions for companies of any size.

Any company that gives a hoot has moved out from Access-- I can name a
handful of large companies in Seattle that have a strict _NO_JET_
policy.

-Aaron

 

[a a r o n _ k e m p f]

well gosh, how about

MICROSOFT
WEYERHAUSER
AMAZON
STARBUCKS

 

[Gina Whipp]

As far as I KNOW they do not have a "strict _NO_JET_ policy". It has more
to do with their data handling/management.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

well gosh, how about

MICROSOFT
WEYERHAUSER
AMAZON
STARBUCKS

 

[Pete D.]

Hummmm, so MS dosn't allow anyone to use MS Access in thier organization. I
guess Santa Elves are working overtime to create the program this year.
Might this call into doubt the rest of the well gosh statement? Matter of
fact, with common sense limits due to security reasons you would be suprised
where and who it is being used and by!