If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
AK is pointless and the only thing that he is good for with his existence is
to provide CO2 for plants. Other than that he is basically a self-centered daddy's boy who wants and craves attention and tries to impart that he is an expert in SQL Server but there is no evidence to follow that up as he posts crappy suggestions and one-liners without backing any of it up with actual data or valid arguments. So, anyway - both SQL Server and Access have their place and neither one is mutually exclusive. It is like saying that you should never buy a car but instead always use a pickup truck because it can carry more stuff in the back. Each has its uses and each performs similar tasks including getting you from one place to another. But you would not buy a car if you needed to haul dirt and gravel in it. You might not buy a pickup truck if you are just interested in getting from point a to point b in the most economical terms (less gas to run it). Same goes for SQL Server and Access. They aren't necessarily the best for doing all jobs. Bob L. wrote in message ... At the end of the day have you made any positive progress in this Forum? I think not. a a r o n _ k e m p f wrote: if you've been using Access for that long-- you'd be using SQL Server by now. I guarantee it. Access is just a speed bump on the path towards SQL Server. A pothole. A driveway to the information super highway that is 'SQL Server'. You're kidding yourself. It is inconcievable that you have this much experience with Access and yet you cannot spell SQL Server On Jul 27, 5:45 pm, "Arvin Meyer [MVP]" wrote: That's odd. I've been on these newsgroups since they started over 12 years ago, and before that on the CompuServe Forums. This is my 8th year as an Access MVP. Additionally, I operate the 3 Access websites in my sig. In all that time, I thought I was providing exactly the kind of help that you seem to be asking for. I usually don't answer questions that I see have been answered by another MVP, nor to I give the man a fish when he wants to learn how to fish. When I point to a book, it's precisely because I know that the copyrighted code is in there or because a book was the question. I point to a website when I or someone else has written the code or an example, or when Microsoft has written a KB article. Because Access is a database, and a database is generally not a simple thing, there is often no simple answer, or the answer may not be what you want to hear. I usually won't give you code to do something that I know is wrong. So specifically, what is it that you are having a problem with? -- Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com wrote in message ... Over the years I have noted a significant difference between the XL and the Access NG's MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self research coupled with real substantive immediate help. i.e. if I ask: Would someone supply a textfile import macro that I could edit? Or let me know how to "get to" the saved import steps on 2007 for use in 2003? or I need the VBA code to delete the first three records (headers from a text import). DoCmd.RunSQL "DELETE ??????? These answers are simple to Access professionals. Sure links to additional sources are great. But let us be real. If you went to a more knowledgable person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you really feel? Sometimes a simple answer to a simple question works. Access needs new business and for others to catch the creativity-motivation curve to solve immediate issues. In short, answer questions with solutions not just additional projects which distinguishes motivation to use Access. I realize that I may never get help again in Access NG's because of the hissy-fits which will follow. Stimulate! Encourage! Create! Help! EagleOne |
#22
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
This is not rocket science. Thank you so much for your time and knowledge. Wow, way to go in trying to insult anyone who might consider trying to help. If you are really trying to alienate everyone so they don't answer your questions you are off to a good start. Why the attitude? I think you should just go pay Microsoft for support so that you get the answers you want and you feel like you got your money's worth. At least if you don't get what you want you can ask for your money back. |
#23
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
wrote in message
... Folks, What I learned today in this forum is that I spent good money for Access when I should have purchased SQL server. This is an Access NG correct? SQL-Server would not have answered the particular problem you asked to solve. SQL-Server may indeed be required if you have lots of records, but you will still need a front-end capable of running code. By far, the best solution for database front-ends is Access, that is assuming that you don't require a large amount of WAN users. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#24
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
Eagle,
In addition to Bob's input, I recommend that you avoid using abbreviation. In your previous post, you wrote: "Have need to import massive 2MM plus record files from MF." What is 2MM? Did you mean 2MB? What is "MF"? Okay, the only thing that comes to mind when I see MF is our resident troll, Aaron. So, if you want your questions answered, try to avoid using abbreviations. Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/ex...tributors.html __________________________________________ "Bob Larson" wrote: I think you need to take a bit of context into account when comparing the Excel Newsgroups and Access Newsgroups. Excel is not concerned with normalization and correct keys, etc. These are way more complex issues that tend to permeate everything that gets posted around Access. So, many times the explanation of these related items can take forever to write each time so posting links to information is the only way to reasonably help someone with those things. If they do have an immediate need, and that need would be complicated by normalization issues, we don't necessarily give them the quick, direct response because we are attempting to TEACH (albeit using other resources than our own writing) as compared to giving them a band-aid solution. In fact, reusability is the reason why I created my website with "quick tutorials" (tutorials basically from screenshots) so that I can communicate with users around commonly asked questions without having to write the answer over and over and over again. Now, I know that there are those who just supply answers and never explain them. I am guilty of that at times as well. That can also come from the fact that we are volunteers who are trying to help but also have other things in life to deal with. We can't always write a book of our own for each post. I'm sorry that you feel that we don't seem to fit into your ideal support model. -- Thanks, Bob Larson Access MVP Administrator, Access World Forums Utter Access VIP Free Access Tutorials and Resources: http://www.btabdevelopment.com wrote in message ... Over the years I have noted a significant difference between the XL and the Access NG's MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self research coupled with real substantive immediate help. i.e. if I ask: Would someone supply a textfile import macro that I could edit? Or let me know how to "get to" the saved import steps on 2007 for use in 2003? or I need the VBA code to delete the first three records (headers from a text import). DoCmd.RunSQL "DELETE ??????? These answers are simple to Access professionals. Sure links to additional sources are great. But let us be real. If you went to a more knowledgable person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you really feel? Sometimes a simple answer to a simple question works. Access needs new business and for others to catch the creativity-motivation curve to solve immediate issues. In short, answer questions with solutions not just additional projects which distinguishes motivation to use Access. I realize that I may never get help again in Access NG's because of the hissy-fits which will follow. Stimulate! Encourage! Create! Help! EagleOne |
#25
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
I look back and see you've had lots of good answers to your many questions in
this group. This morning a troll bit you when you posted another one. Instead of ignoring the troll, you go on a rant about the inadequacies of the volunteers in these groups who help you and hundreds of others every day at no cost to you. Your reward for fueling the troll is that he'll consider you to be his pal. (He loves Excel users, especially ones who complain about Access and the people who answer questions in these groups). Now that he knows how much he can irk you, he's going to keep doing it. Over and over. Not sure which MS employee you're telling your organization is badmouthing MS products, but you'd better check your facts first before you get caught making false claims. Chris Microsoft MVP wrote: Folks, What I learned today in this forum is that I spent good money for Access when I should have purchased SQL server. This is an Access NG correct? More, I am sure that the 10,000+ Access users in my organization would not be happy campers if they knew that MS was badmouthing there own product on their own forum - not real encouraging. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200807/1 |
#26
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
If all Gods have returned from Access heaven and have cooled off, let us try
this another time. The questions were/are simple. Real simple. All that was asked was a VBA code line to remove from report headers from a text import. Simple stuff? Next was can anyone share a macro that contains the VBA to name headings and set data types which I could modify for my use. Any response that initially came back was overbroad, assumed the worst, assumed that some Access wacko was intentially screwing with the Access Gods. In reality, I am just user who asked simple question(s). But the Access Gods are so used to intimidating (browbeating, holyer-than-thouing) the user with imagined abuses never substatuated or in play. All but one walked right passed and never came back to the mission of this Forum. Never have I seen a "professional group" so threat sensitive. There were those in the group who stated that SQL Server was the only answer - essentially Access is junk. The software I have is Access and I therefore I must use it. This would have gone much smother if Access Guru's were willing to share their knowledge. Just look at the number of Excel postings which contain actual VBA code or real formulas that work! How amazing. Compare that to Access NG! What one can see is more questions than answers. What results in User's minds is "Access is to difficult to understand, I'll just limp with Excel limits". Which of course smacks at self-serving their consulting businesses. In Access, a question is asked and the third-degree interigrators jump in you face with more questions than answers. To be sure, some of that is needed. But in reality it is much more like "I paid my dues; I could not get help; I did it on my own; I am going to make you (the user) bleed first then I might consider giving you something that you could to solve an issue at hand and make Access-use a blessing. This news group should be more about empowerment than about hazing and self-service that it is in reality. "Bob Larson" wrote: This is not rocket science. Thank you so much for your time and knowledge. Wow, way to go in trying to insult anyone who might consider trying to help. If you are really trying to alienate everyone so they don't answer your questions you are off to a good start. Why the attitude? I think you should just go pay Microsoft for support so that you get the answers you want and you feel like you got your money's worth. At least if you don't get what you want you can ask for your money back. |
#27
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
you just choose to listen to the snake oil salesman.
Is that my fault? I choose a real database engine-- paired with Access forms and reports-- for the same cost as JET ADP forever, baby. On Jul 27, 6:22*pm, wrote: At the end of the day have you made any positive progress in this Forum? *I think not. a a r o n _ k e m p f wrote: if you've been using Access for that long-- you'd be using SQL Server by now. *I guarantee it. Access is just a speed bump on the path towards SQL Server. A pothole. A driveway to the information super highway that is 'SQL Server'. You're kidding yourself. It is inconcievable that you have this much experience with Access and yet you cannot spell SQL Server On Jul 27, 5:45*pm, "Arvin Meyer [MVP]" wrote: That's odd. I've been on these newsgroups since they started over 12 years ago, and before that on the CompuServe Forums. This is my 8th year as an Access MVP. Additionally, I operate the 3 Access websites in my sig. In all that time, I thought I was providing exactly the kind of help that you seem to be asking for. I usually don't answer questions that I see have been answered by another MVP, nor to I give the man a fish when he wants to learn how to fish. When I point to a book, it's precisely because I know that the copyrighted code is in there or because a book was the question. I point to a website when I or someone else has written the code or an example, or when Microsoft has written a KB article. Because Access is a database, and a database is generally not a simple thing, there is often no simple answer, or the answer may not be what you want to hear. I usually won't give you code to do something that I know is wrong. So specifically, what is it that you are having a problem with? -- Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv... wrote in message . .. Over the years I have noted a significant difference between the XL and the Access NG's MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self research coupled with real substantive immediate help. i.e. if I ask: Would someone supply a textfile import macro that I could edit? *Or let me know how to "get to" the saved import steps on 2007 for use in 2003? or I need the VBA code to delete the first three records (headers from a text import). * * * DoCmd.RunSQL "DELETE ??????? These answers are simple to Access professionals. Sure links to additional sources are great. *But let us be real. *If you went to a more knowledgable person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you really feel? Sometimes a simple answer to a simple question works. *Access needs new business and for others to catch the creativity-motivation curve to solve immediate issues. In short, answer questions with solutions not just additional projects which distinguishes motivation to use Access. I realize that I may never get help again in Access NG's because of the hissy-fits which will follow. Stimulate! Encourage! Create! Help! EagleOne |
#28
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
Access rocks.
but SQL Server is about 100 times better in every direction. SQL Server is free. www.microsoft.com/sql if you've got Access 2007; use SQL 2005. if you've got Access 2007; use SQL 2000 either way, use SQL Server Management Studio Express in order to manage the db server (as it has more power than ADP). But for most developkment-- just use ADP On Jul 27, 7:56*pm, wrote: Folks, What I learned today in this forum is that I spent good money for Access when I should have purchased SQL server. *This is an Access NG correct? I am obviously not a significant Access user. *That said, what I am now working on is an idea which will cause a significant improvement in information and decrease time in account reconciliation's. I do not have the time right now to become an Access guru. *My questions were very simple and answers were needed before tomorrow I had hoped. The mission of this forum s/b to encourage Access use and proliferation. I do not have PC-level access in my organization to SQL Server. *More, I am sure that the 10,000+ Access users in my organization would not be happy campers if they knew that MS was badmouthing there own product on their own forum - not real encouraging. Access is what we have and must use. *I was just looking for some real help. Someone above has given answers "Rick Brandt" wrote: wrote: Arvin, You have helped and are one of the "good ones." Where, pray tell, was an answer? *There is too much smoke. Actually, my comments were to challenge not to provoke. 1) What is the VBA command to delete record #1, or #2 etc There is no such thing as record #1, or record #2 in a database unless you define what you mean by those descriptions. *The very question highly suggests someone that doesn't know what they are doing. *You are then surprised if you get requests for clarification rather than explicit instructions? 2) Can anyone share a VBA macro to import a text file where there is code examples to rename or name Field1 to "Whatever" and to set the data type? I for one have no idea about anything in this question. *"VBA Macro" does not compute. *Most MVPs have little or no experience with macros (I certainly don't). *Renaming fields via code is not something that would often be done. *Neither is setting the data type. *Again the question highly suggests that questionable actions are being performed so inquiring "why?" is a perfectly natural thing to do. I cannot believe that I cannot get useable answers *I get long self aggrandizements which take far more time than the question. I guess I am a bit frustrated. Despite the level of expertise in here, not every answer is a matter of pounding the keyboard. *Some (like yours) would require opening a test file and actually working out an example. *At least if the one posting the answer wanted to be sure it would be correct. *You expect someone to do that much work when the desired action is questionable in the first place? You get less of this in other types of groups because other software areas do not have these types of issues. *Try spending some time in the HTML or javascript groups. *The heavy responders in those groups make a regular habit of tearing to shreds any post that even remotely suggests that the poster is a rookie or hasn't done their homework prior to posting. *I have never seen more considerate and helpful responders (as a group) than what is found in the Access groups. |
#29
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
bull****; Jet is not reliable enough for more than a single user and a
single record On Jul 27, 8:18*pm, "Bob Larson" wrote: AK is pointless and the only thing that he is good for with his existence is to provide CO2 for plants. *Other than that he is basically a self-centered daddy's boy who wants and craves attention and tries to impart that he is an expert in SQL Server but there is no evidence to follow that up as he posts crappy suggestions and one-liners without backing any of it up with actual data or valid arguments. So, anyway - both SQL Server and Access have their place and neither one is mutually exclusive. *It is like saying that you should never buy a car but instead always use a pickup truck because it can carry more stuff in the back. *Each has its uses and each performs similar tasks including getting you from one place to another. *But you would not buy a car if you needed to haul dirt and gravel in it. *You might not buy a pickup truck if you are just interested in getting from point a to point b in the most economical terms (less gas to run it). *Same goes for SQL Server and Access. *They aren't necessarily the best for doing all jobs. Bob L. wrote in message ... At the end of the day have you made any positive progress in this Forum? I think not. a a r o n _ k e m p f wrote: if you've been using Access for that long-- you'd be using SQL Server by now. *I guarantee it. Access is just a speed bump on the path towards SQL Server. A pothole. A driveway to the information super highway that is 'SQL Server'. You're kidding yourself. It is inconcievable that you have this much experience with Access and yet you cannot spell SQL Server On Jul 27, 5:45 pm, "Arvin Meyer [MVP]" wrote: That's odd. I've been on these newsgroups since they started over 12 years ago, and before that on the CompuServe Forums. This is my 8th year as an Access MVP. Additionally, I operate the 3 Access websites in my sig. In all that time, I thought I was providing exactly the kind of help that you seem to be asking for. I usually don't answer questions that I see have been answered by another MVP, nor to I give the man a fish when he wants to learn how to fish. When I point to a book, it's precisely because I know that the copyrighted code is in there or because a book was the question. I point to a website when I or someone else has written the code or an example, or when Microsoft has written a KB article. Because Access is a database, and a database is generally not a simple thing, there is often no simple answer, or the answer may not be what you want to hear. I usually won't give you code to do something that I know is wrong. So specifically, what is it that you are having a problem with? -- Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv... wrote in message ... Over the years I have noted a significant difference between the XL and the Access NG's MS would be smart to suggest to its Access MVP's to teach both by encouraging additional self research coupled with real substantive immediate help. i.e. if I ask: Would someone supply a textfile import macro that I could edit? Or let me know how to "get to" the saved import steps on 2007 for use in 2003? or I need the VBA code to delete the first three records (headers from a text import). DoCmd.RunSQL "DELETE ??????? These answers are simple to Access professionals. Sure links to additional sources are great. But let us be real. If you went to a more knowledgable person and asked a question that you knew he knew and he pointed to 5 1000 page books how would you really feel? Sometimes a simple answer to a simple question works. Access needs new business and for others to catch the creativity-motivation curve to solve immediate issues. In short, answer questions with solutions not just additional projects which distinguishes motivation to use Access. I realize that I may never get help again in Access NG's because of the hissy-fits which will follow. Stimulate! Encourage! Create! Help! EagleOne |
#30
|
|||
|
|||
MS Access Newsgroups lack real synergistic help
ADP is a great front end.
It looks just like MS Access-- same forms and reports-- but the query engine is much faster and superior. It supports 'code reuse' for starters On Jul 27, 8:39*pm, "Arvin Meyer [MVP]" wrote: wrote in message ... Folks, What I learned today in this forum is that I spent good money for Access when I should have purchased SQL server. *This is an Access NG correct? SQL-Server would not have answered the particular problem you asked to solve. SQL-Server may indeed be required if you have lots of records, but you will still need a front-end capable of running code. By far, the best solution for database front-ends is Access, that is assuming that you don't require a large amount of WAN users. -- Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|