Data Access

FAQ

Profile

Data Access
Goto page 1, 2

Database Forums (Home) -> MS Access

Next: AutoComplete function

Author

Message

Raul

External

Since: Nov 19, 2008
Posts: 2

(Msg. 1) Posted: Thu Dec 18, 2008 2:19 pm Post subject: Data Access Archived from groups: microsoft>public>access (more info?)

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. >> Stay informed about: Data Access

Arvin Meyer [MVP]

External

Since: Oct 02, 2008
Posts: 66

(Msg. 2) Posted: Thu Dec 18, 2008 3:34 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Raul" wrote in message >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. > > >> Stay informed about: Data Access

Gina Whipp

External

Since: Oct 02, 2003
Posts: 28

(Msg. 3) Posted: Thu Dec 18, 2008 8:42 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Raul, You say 'the data', is the database split? And you might want to mention what kind of network, might make a difference. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "Raul" wrote in message >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. > > >> Stay informed about: Data Access

Larry Linson5

External

Since: Jun 24, 2004
Posts: 164

(Msg. 4) Posted: Fri Dec 19, 2008 4:08 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

"Raul" wrote > 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 >> Stay informed about: Data Access

aaron.kempf

External

Since: Apr 11, 2008
Posts: 135

(Msg. 5) Posted: Sun Dec 21, 2008 10:22 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. On Dec 18, 12:34 pm, "Arvin Meyer [MVP]" wrote: > 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. > -- > Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com > > "Raul" wrote in message > > > > > > >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.- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

aaron.kempf

External

Since: Apr 11, 2008
Posts: 135

(Msg. 6) Posted: Sun Dec 21, 2008 10:23 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 On Dec 19, 2:08 pm, "Larry Linson" wrote: > "Raul" wrote > > > 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 avoidingcorruption > in multiuser environments are MVP Tony Toew's site athttp://www.granite.ab.ca/accsmstr.htmand former MVP Jeff Conrad's site athttp://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 >> Stay informed about: Data Access

BruceM

External

Since: May 25, 2007
Posts: 123

(Msg. 7) Posted: Mon Dec 22, 2008 7:23 am Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. "a a r o n . k e m p f @ g m a i l . c o m" wrote in 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 On Dec 19, 2:08 pm, "Larry Linson" wrote: > "Raul" wrote > > > 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 avoidingcorruption > in multiuser environments are MVP Tony Toew's site > athttp://www.granite.ab.ca/accsmstr.htmand former MVP Jeff Conrad's site > athttp://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 >> Stay informed about: Data Access

Linq Adams via AccessMons

External

Since: Nov 17, 2007
Posts: 20

(Msg. 8) Posted: Mon Dec 22, 2008 10:26 am Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Aaron, please close your eyes and go play in traffic! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com >> Stay informed about: Data Access

aaron.kempf

External

Since: Apr 11, 2008
Posts: 135

(Msg. 9) Posted: Wed Dec 24, 2008 9:18 am Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. On Dec 22, 4:23 am, "BruceM" wrote: > 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. > > "a a r o n . k e m p f @ g m a i l . c o m" wrote in > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups..com... > 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 > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > > > > "Raul" wrote > > > > 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 avoidingcorruption > > in multiuser environments are MVP Tony Toew's site > > athttp://www.granite.ab.ca/accsmstr.htmandformer MVP Jeff Conrad's site > > athttp://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 >> Stay informed about: Data Access

BruceM

External

Since: May 25, 2007
Posts: 123

(Msg. 10) Posted: Wed Dec 24, 2008 12:38 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. "a a r o n . k e m p f @ g m a i l . c o m" wrote in 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. On Dec 22, 4:23 am, "BruceM" wrote: > 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. > > "a a r o n . k e m p f @ g m a i l . c o m" wrote > in > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > 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 > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > > > > "Raul" wrote > > > > 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 > > avoidingcorruption > > in multiuser environments are MVP Tony Toew's site > > athttp://www.granite.ab.ca/accsmstr.htmandformer MVP Jeff Conrad's site > > athttp://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 >> Stay informed about: Data Access

a a r o n _ k e m p f

External

Since: Jul 01, 2008
Posts: 57

(Msg. 11) Posted: Fri Dec 26, 2008 10:33 am Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

you're wrong. Jet is _NEVER_ a good choice, because SQL Server develoment is - EASIER-. -Aaron On Dec 24, 9:38 am, "BruceM" wrote: > 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. > > "a a r o n . k e m p f @ g m a i l . c o m" wrote in > messagenews:2b87b0e4-8431-425f-a9c8-87662897d9da@i24g2000prf.googlegroups..com... > 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. > > On Dec 22, 4:23 am, "BruceM" wrote: > > > > > 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. > > > "a a r o n . k e m p f @ g m a i l . c o m" wrote > > in > > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > > 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 > > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > "Raul" wrote > > > > > 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 onperformanceand > > > avoidingcorruption > > > in multiuser environments are MVP Tony Toew's site > > > athttp://www.granite.ab.ca/accsmstr.htmandformerMVP Jeff Conrad's site > > > athttp://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- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

a a r o n _ k e m p f

External

Since: Jul 01, 2008
Posts: 57

(Msg. 12) Posted: Fri Dec 26, 2008 10:40 am Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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. On Dec 24, 9:38 am, "BruceM" wrote: > 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. > > "a a r o n . k e m p f @ g m a i l . c o m" wrote in > messagenews:2b87b0e4-8431-425f-a9c8-87662897d9da@i24g2000prf.googlegroups..com... > 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. > > On Dec 22, 4:23 am, "BruceM" wrote: > > > > > 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. > > > "a a r o n . k e m p f @ g m a i l . c o m" wrote > > in > > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > > 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 > > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > "Raul" wrote > > > > > 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 onperformanceand > > > avoidingcorruption > > > in multiuser environments are MVP Tony Toew's site > > > athttp://www.granite.ab.ca/accsmstr.htmandformerMVP Jeff Conrad's site > > > athttp://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- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

a a r o n _ k e m p f

External

Since: Jul 01, 2008
Posts: 57

(Msg. 13) Posted: Fri Dec 26, 2008 5:05 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 On Dec 26, 2:44 pm, "Gina Whipp" wrote: > 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 > "a a r o n _ k e m p f" wrote in messagenews:b4d18df0-178a-4c98-b25e-c82db7ad6571@c36g2000prc.googlegroups.com... > 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. > > On Dec 24, 9:38 am, "BruceM" wrote: > > > > > 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. > > > "a a r o n . k e m p f @ g m a i l . c o m" wrote > > in > > messagenews:2b87b0e4-8431-425f-a9c8-87662897d9da@i24g2000prf.googlegroups.com... > > 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. > > > On Dec 22, 4:23 am, "BruceM" wrote: > > > > 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. > > > > "a a r o n . k e m p f @ g m a i l . c o m" > > > wrote > > > in > > > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > > > 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 > > > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > > "Raul" wrote > > > > > > 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 onperformanceand > > > > avoidingcorruption > > > > in multiuser environments are MVP Tony Toew's site > > > > athttp://www.granite.ab.ca/accsmstr.htmandformerMVPJeff Conrad's site > > > > athttp://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- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

Gina Whipp

External

Since: Oct 02, 2003
Posts: 28

(Msg. 14) Posted: Fri Dec 26, 2008 5:44 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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 "a a r o n _ k e m p f" wrote in message 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. On Dec 24, 9:38 am, "BruceM" wrote: > 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. > > "a a r o n . k e m p f @ g m a i l . c o m" wrote > in > messagenews:2b87b0e4-8431-425f-a9c8-87662897d9da@i24g2000prf.googlegroups.com... > 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. > > On Dec 22, 4:23 am, "BruceM" wrote: > > > > > 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. > > > "a a r o n . k e m p f @ g m a i l . c o m" > > wrote > > in > > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > > 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 > > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > "Raul" wrote > > > > > 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 onperformanceand > > > avoidingcorruption > > > in multiuser environments are MVP Tony Toew's site > > > athttp://www.granite.ab.ca/accsmstr.htmandformerMVP Jeff Conrad's site > > > athttp://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- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

Gina Whipp

External

Since: Oct 02, 2003
Posts: 28

(Msg. 15) Posted: Fri Dec 26, 2008 8:50 pm Post subject: Re: Data Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

Please DO name the Companies... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "a a r o n _ k e m p f" wrote in message 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 On Dec 26, 2:44 pm, "Gina Whipp" wrote: > 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 > "a a r o n _ k e m p f" wrote in > messagenews:b4d18df0-178a-4c98-b25e-c82db7ad6571@c36g2000prc.googlegroups.com... > 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. > > On Dec 24, 9:38 am, "BruceM" wrote: > > > > > 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. > > > "a a r o n . k e m p f @ g m a i l . c o m" > > wrote > > in > > messagenews:2b87b0e4-8431-425f-a9c8-87662897d9da@i24g2000prf.googlegroups.com... > > 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. > > > On Dec 22, 4:23 am, "BruceM" wrote: > > > > 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. > > > > "a a r o n . k e m p f @ g m a i l . c o m" > > > wrote > > > in > > > messagenews:9ef05cf3-7c9e-493e-bfdd-60ea102c7f04@o40g2000prn.googlegroups.com... > > > 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 > > > > On Dec 19, 2:08 pm, "Larry Linson" wrote: > > > > > "Raul" wrote > > > > > > 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 onperformanceand > > > > avoidingcorruption > > > > in multiuser environments are MVP Tony Toew's site > > > > athttp://www.granite.ab.ca/accsmstr.htmandformerMVPJeff Conrad's > > > > site > > > > athttp://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- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - >> Stay informed about: Data Access

Display posts from previous:

Related Topics:

Comparing Data In Access - I have 5,000 customers separated by class of trade in a simple database. Lets take Bakery as a class of trade as an example. I want to come up with a list of items a Bakery should buy from us. I then want to compare that list of products against all of....

Data Access Page - Good Morning Community, Is there any way to include a search function on a Data access Page? I have a file that I want to put on a Data access page that will be published on a shared drive, the problem is that the file has about 1000 records and ...

Access data to Infopath - I would like to select data from a access record and make it available to use in a infopath form. Can I do this and how?

Data Access Page Help - I posted this in the queries forum a week ago and had no response. Can anyone help me here? I looked through previous posts and was too confused to know what to do. I want to turn a parameter query (which returns records which have certain text that i...

How do I randomly divide data in Access? - In Access 2003 I need to randomly divide the data in a table.

	Database Forums (Home) -> MS Access	All times are: Pacific Time (US & Canada) Goto page 1, 2
Page 1 of 2

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum