Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Flexibility
- Thread starter Zbob
- Start date
The flexibility client needs to be installed on each machine that will run flex code. You can go to the visual menu builder and deny access to the flexibility icon to keep casual users from actually accessing the VBA code.
Kirk, aka vbajock frequents this forum and can probably tell you better than I can about flexibility. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Kirk, aka vbajock frequents this forum and can probably tell you better than I can about flexibility. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
'//The flexibility client needs to be installed on each machine that will run flex code. You can go to the visual menu builder and deny access to the flexibility icon to keep casual users from actually accessing the VBA code.///
This is not true...you can install the the Macola client and copy the vba code to the vbaprj/<user> on the macola box and you will be fine. There is no need to install the flex client on each machine.
This is not true...you can install the the Macola client and copy the vba code to the vbaprj/<user> on the macola box and you will be fine. There is no need to install the flex client on each machine.
What needs to installed on the clients is any dll's or active X objects you add to your project that is not part of the default Macola stuff. This is where it gets tricky. For example, if you need to access an Access 2000 database to get data, you will have to add DAO or ADO libraries to your code. If the client does not have Access installed or if it is a different version, you will have to supply the setup program to copy and register all the necessary components, and this can be a real pain.
Chadt-
You are incorrect. While it is remotely possible that some pieces of flex code could run without the flex client install on that workstation, it would be a coincidence in that every single .dll or .ocx or any other file required by that particular flex project to run is already present and registered on the client machine due to its use with another application.
Also, if you are going to use the ERS RecSet to read and write to Macola data files, which probably half or more of the flex code I have seen does, there is ZERO possibility that this code would run without the flex client installed on the machine.
I have confirmed this with 2 flexibility gurus and with the top Flexibillity expert at Macola tech support. If you have different information, please post it here as I would love to learn what you know.
in terms of the subdirectory under the vbaprj directory, this is there so that user A can have different flex code for the same screenset than user B. This has nothing to do with the ability of the workstation to run Flex code.
Please let me know if you have any questions. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
You are incorrect. While it is remotely possible that some pieces of flex code could run without the flex client install on that workstation, it would be a coincidence in that every single .dll or .ocx or any other file required by that particular flex project to run is already present and registered on the client machine due to its use with another application.
Also, if you are going to use the ERS RecSet to read and write to Macola data files, which probably half or more of the flex code I have seen does, there is ZERO possibility that this code would run without the flex client installed on the machine.
I have confirmed this with 2 flexibility gurus and with the top Flexibillity expert at Macola tech support. If you have different information, please post it here as I would love to learn what you know.
in terms of the subdirectory under the vbaprj directory, this is there so that user A can have different flex code for the same screenset than user B. This has nothing to do with the ability of the workstation to run Flex code.
Please let me know if you have any questions. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
dgillz:
I am far from being incorrect. Most VBA/VB developers would either use DAO or ADO to access macola data and not the ERSRecSet. ADO has so much more you can do with it and you only need to have the MS Data Access components loaded which 9 times out of 10 are already loaded because of something else on the computer or if the user has access loaded.....also 9 out of 10 times the VB runtime is also on the client machine. I have done about 40 projects in Flex at 10 client sites and have only once had to load the Data Access Components and almost have never had to load the flex client...except of course for anyone else developing for macola.
Trust me....I have been developing Flex code for about 3 years now after leaving macola in Ohio.
Also I am very aware of what the vbaprj/user folder is for....read my post more carefully.
SOrry to say but you don't know all about macola and macola is sometimes not always truthful as to what they tell resellers and customers.
my2cents
I am far from being incorrect. Most VBA/VB developers would either use DAO or ADO to access macola data and not the ERSRecSet. ADO has so much more you can do with it and you only need to have the MS Data Access components loaded which 9 times out of 10 are already loaded because of something else on the computer or if the user has access loaded.....also 9 out of 10 times the VB runtime is also on the client machine. I have done about 40 projects in Flex at 10 client sites and have only once had to load the Data Access Components and almost have never had to load the flex client...except of course for anyone else developing for macola.
Trust me....I have been developing Flex code for about 3 years now after leaving macola in Ohio.
Also I am very aware of what the vbaprj/user folder is for....read my post more carefully.
SOrry to say but you don't know all about macola and macola is sometimes not always truthful as to what they tell resellers and customers.
my2cents
Chadt, you have made me curious. I have a big implementation coming up where I have about 30 computers that will be getting a program I wrote installed over the next few weeks. Personally, I hope you are right, because installing the cleint on every machine is a drag, because you have to jack with the security issues that arise. I will test it both ways, and I will announce the result.
I will say that you must have a better client base than I do, as I run into lots of users running Office 97, or they only have Word or Outlook installed. I do a lot of manufacturing facilities, and if the user, who many times is a lowly factory floor clerk, can get the job done with whatever he has, the boss is not going to fork out 400 bucks for an upgrade. Heck, I had one that was still on Novell 3.11 a few months ago. I also have a bunch of machines that are dedicated to only one job, for example, a shipper scanning cartons is not going to be doing a lot of spreadsheet analysis, and on those I am lucky if the user is running Win 95. I end up spending a lot of time registering DLL's and OCX's. Personnally, I never use ERS RecSet stuff, I do everything in ADO, because most of the work I get in Flex is interfacing Macola to something else, and ADO is king of that.
I will say that you must have a better client base than I do, as I run into lots of users running Office 97, or they only have Word or Outlook installed. I do a lot of manufacturing facilities, and if the user, who many times is a lowly factory floor clerk, can get the job done with whatever he has, the boss is not going to fork out 400 bucks for an upgrade. Heck, I had one that was still on Novell 3.11 a few months ago. I also have a bunch of machines that are dedicated to only one job, for example, a shipper scanning cartons is not going to be doing a lot of spreadsheet analysis, and on those I am lucky if the user is running Win 95. I end up spending a lot of time registering DLL's and OCX's. Personnally, I never use ERS RecSet stuff, I do everything in ADO, because most of the work I get in Flex is interfacing Macola to something else, and ADO is king of that.
Chadt-
Who do you work for? What is your name? I work for Triangle Partners, a presidents council Macola reseller, and the 6th largest Macola reseller in the world. I have been working with macola for 6+ years. That may or may not impress you, but I figure that I have as good of an access to info on Macola as anyone else out there.
I may not know "all about Macola", in fact one one my life's rules is that is always more to learn. Having said that, I am Macola certified in every single certification that they offer, so I figure that I know more about Macola than 99.9% of the people out there. Macola may "hold back" info from their top resellers, as you alluded to, and here is your chance to prove it and teach me, Kirk (vbajock) and others out there the other .1% of the product.
I would love to hook up with you and see you prove me wrong. If you do I will be eternally grateful, and you will have my apologies.
Also, I would very much like to talk to you about hiring you. I know that recruiting is forbidden at but if you can do something that everyone I have ever met in regards to Macola says cannot be done, I am willing to ignore the rules.
I very much look forward to talking to you.
Best Regards,
Don Gilsdorf
Triangle Partners LLC
dgilsdorf@trianglepartners.com
251-621-8972 Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Who do you work for? What is your name? I work for Triangle Partners, a presidents council Macola reseller, and the 6th largest Macola reseller in the world. I have been working with macola for 6+ years. That may or may not impress you, but I figure that I have as good of an access to info on Macola as anyone else out there.
I may not know "all about Macola", in fact one one my life's rules is that is always more to learn. Having said that, I am Macola certified in every single certification that they offer, so I figure that I know more about Macola than 99.9% of the people out there. Macola may "hold back" info from their top resellers, as you alluded to, and here is your chance to prove it and teach me, Kirk (vbajock) and others out there the other .1% of the product.
I would love to hook up with you and see you prove me wrong. If you do I will be eternally grateful, and you will have my apologies.
Also, I would very much like to talk to you about hiring you. I know that recruiting is forbidden at but if you can do something that everyone I have ever met in regards to Macola says cannot be done, I am willing to ignore the rules.
I very much look forward to talking to you.
Best Regards,
Don Gilsdorf
Triangle Partners LLC
dgilsdorf@trianglepartners.com
251-621-8972 Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Don Gilsdorf
First let me make it clear I did not mean to degrade you on what you know about macola....im sure you are very trained on the product. I would also like to say that certification in macola doesn't hold very much...I have met plenty or certified macola people that are completly retarded when it come to macola....not saying you are because I have also met very smart ones too....kinda like MCSE's
All of what I have said about flex and not having to load the client it true....but you also have to remeber this all depends upon what your doing. For simple forms and data access there should be no reason to install the client (assuming the MDAC is on the machine or access)...but don't get me wrong some VB/VBA controls might make the client required.
As to holding information......ask macola what there server recomendations are for SQL and Ternimal Services.....go by those specs and then ask the SQL guys over there if it is correct....they will tell you know....this has costed one reseller I know lots of money in maintence and server upgrades...I would give a specific name but not on the board here....he can explain all the false info macola gives in regard to SQL and Terminal Services (Citrix).
This also brings me to another issue....ES....I have never been feed so much bs before in my life in regards to this...personally I think in 5 years Macola will not be what it is today because of the Exact/Macola joint venture.....Macola ES is buggy, bloated, slow, and...I could go on and on about ES but Ill stop here.....actually the only good thing about ES is that it uses windows authentication for login so basically you could create 1 login name and use it on every machine getting around the pricy license.
And finally....Im sure we could both teach other lots of things about macola. I am also very happy in my job right now....but am always looking.....I have really been pushing for more SysPro implementation then macola because honestly I don't see macola as a big player once ES is in General Release which probably wont be for another year or so.
Again I didn't mean to crash on your macola smarts as I am sure your well qualified.
First let me make it clear I did not mean to degrade you on what you know about macola....im sure you are very trained on the product. I would also like to say that certification in macola doesn't hold very much...I have met plenty or certified macola people that are completly retarded when it come to macola....not saying you are because I have also met very smart ones too....kinda like MCSE's
All of what I have said about flex and not having to load the client it true....but you also have to remeber this all depends upon what your doing. For simple forms and data access there should be no reason to install the client (assuming the MDAC is on the machine or access)...but don't get me wrong some VB/VBA controls might make the client required.
As to holding information......ask macola what there server recomendations are for SQL and Ternimal Services.....go by those specs and then ask the SQL guys over there if it is correct....they will tell you know....this has costed one reseller I know lots of money in maintence and server upgrades...I would give a specific name but not on the board here....he can explain all the false info macola gives in regard to SQL and Terminal Services (Citrix).
This also brings me to another issue....ES....I have never been feed so much bs before in my life in regards to this...personally I think in 5 years Macola will not be what it is today because of the Exact/Macola joint venture.....Macola ES is buggy, bloated, slow, and...I could go on and on about ES but Ill stop here.....actually the only good thing about ES is that it uses windows authentication for login so basically you could create 1 login name and use it on every machine getting around the pricy license.
And finally....Im sure we could both teach other lots of things about macola. I am also very happy in my job right now....but am always looking.....I have really been pushing for more SysPro implementation then macola because honestly I don't see macola as a big player once ES is in General Release which probably wont be for another year or so.
Again I didn't mean to crash on your macola smarts as I am sure your well qualified.
Chadt-
I have had time to do some more research on this and I am still convinced that no flexibility program will run without the flex client being installed.
If you can do this, please write me a small VBA porgram that you contend will run without the flex client and email it to me. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
I have had time to do some more research on this and I am still convinced that no flexibility program will run without the flex client being installed.
If you can do this, please write me a small VBA porgram that you contend will run without the flex client and email it to me. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
dgillz (Instructor)
"I have had time to do some more research on this and I am still convinced that no flexibility program will run without the flex client being installed."
I guess your always right and nobody else is.......funny to see how close minded people can be....especially when they are incorrect.
"I have had time to do some more research on this and I am still convinced that no flexibility program will run without the flex client being installed."
I guess your always right and nobody else is.......funny to see how close minded people can be....especially when they are incorrect.
Ok you two guys - let's be nice.
Like I said, I am going to test this myself within the next few days, but I suspect Chadt is right, but you might be right because you are a better programmer.
First, technically speaking, Chadt is correct. With any VB program, if the correct references and correct registry updates are made within the program code and the libraries are on the machine, it should work no matter what other programs are installed on the machine or no matter what system the VB program itself is called from. All the code has to go thru the VB runtime engine, period. The runtime engine cares nothing about Macola or Flexibilty. It only cares that the objects it needs exist. It is the programmer's job to see to it the objects are there, and a programmer who knows what he is doing is going to do this explicitly in his code.
However, running the install program of an application that uses the same libraries and registry settings will accomplish the same thing, such as installing the correct objects and updating the registery correctly, for a programmer who does not have a very high skill level. All's the newbee knows is that his code didn't work, he installed the client, and now it works.
I suspect this: Macola\ES may say that the client needs to be installed for ulterior motive reasons, for example, they don't want to go through the time and expense of providing the correct documentation, or they don't want to field a lot of support calls on the subject from novice in house guys, or they want to keep it secret for some supposed business necessity that has not been well thought out on their part. Since Macola has a history of this kind of stuff, I, as I said, suspect Chadt is right. My own experience with Macola is they never recognized the importance of making their systems and their distribution of development information as open as possible until too late, if at all.
Like I said, I am going to test this myself within the next few days, but I suspect Chadt is right, but you might be right because you are a better programmer.
First, technically speaking, Chadt is correct. With any VB program, if the correct references and correct registry updates are made within the program code and the libraries are on the machine, it should work no matter what other programs are installed on the machine or no matter what system the VB program itself is called from. All the code has to go thru the VB runtime engine, period. The runtime engine cares nothing about Macola or Flexibilty. It only cares that the objects it needs exist. It is the programmer's job to see to it the objects are there, and a programmer who knows what he is doing is going to do this explicitly in his code.
However, running the install program of an application that uses the same libraries and registry settings will accomplish the same thing, such as installing the correct objects and updating the registery correctly, for a programmer who does not have a very high skill level. All's the newbee knows is that his code didn't work, he installed the client, and now it works.
I suspect this: Macola\ES may say that the client needs to be installed for ulterior motive reasons, for example, they don't want to go through the time and expense of providing the correct documentation, or they don't want to field a lot of support calls on the subject from novice in house guys, or they want to keep it secret for some supposed business necessity that has not been well thought out on their part. Since Macola has a history of this kind of stuff, I, as I said, suspect Chadt is right. My own experience with Macola is they never recognized the importance of making their systems and their distribution of development information as open as possible until too late, if at all.
vbajock & chadt,
I would love to see this work, thats all I am asking and I think its a reasonable request.
What Macola has told me -- not that that means they are right -- is that the flex client has to be installed in order for flexibility to even recognize the VBA (not VB) project.
Chadt, I apologize if I came off as a know-it-all. All I really want to do is learn if what Macola has told me is correct or not. Since I cannot prove a negative, I am counting on you to show me how to do this.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
I would love to see this work, thats all I am asking and I think its a reasonable request.
What Macola has told me -- not that that means they are right -- is that the flex client has to be installed in order for flexibility to even recognize the VBA (not VB) project.
Chadt, I apologize if I came off as a know-it-all. All I really want to do is learn if what Macola has told me is correct or not. Since I cannot prove a negative, I am counting on you to show me how to do this.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Macola has not told you the correct info. When any module opens it looks for the username or group under the vbaprj folders and loads the projects at this point. The client has nothing to do with it.
Also when I have some time I will send you a little sample program....I am extreamly busy during the day and really dont have the time to prove you wrong.
Also when I have some time I will send you a little sample program....I am extreamly busy during the day and really dont have the time to prove you wrong.
Chadt and vbajock,
just curious if either of you have gotten this to work without the flex client. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
just curious if either of you have gotten this to work without the flex client. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
As I told you before you DO NOT NEED the flex client....but with everything it depends upon what your doing....and what controls you are using. Please read our previous posts above.
Sorry dgillz (Instructor) I lost allot of respect for you when you were asking what the Active Directory was.
Sorry dgillz (Instructor) I lost allot of respect for you when you were asking what the Active Directory was.
Chadt,
I know you told me this, I just want to see it work, which I have not been able to do yet. Also, I asked what AD was, not what active directory was. Not being a programmer I am not always familiar with the terminology. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
I know you told me this, I just want to see it work, which I have not been able to do yet. Also, I asked what AD was, not what active directory was. Not being a programmer I am not always familiar with the terminology. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
"Not being a programmer I am not always familiar with the terminology"
Whatever....but yet you can give people advice on Flex and VBA????? Is it just me or does this not make sense?
Also who is claiming to be a programmer? VB/VBA and Flex is not programming....No offense to all you VB guys.
Whatever....but yet you can give people advice on Flex and VBA????? Is it just me or does this not make sense?
Also who is claiming to be a programmer? VB/VBA and Flex is not programming.
...No offense to all you VB guys.- Status
Similar threads
- Locked
- Question