RE: ASP.NET web site
Sounds like one of the old Pre-VS Wizard web sites. I'd be happy to have a look at it and offer suggestions. Myself - web developer since pre-Denali (first release of ASP) so I know my way around some of the early technologies. Let me know if I can help Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Peter Maddin Sent: Wednesday, 21 December 2011 2:32 PM To: 'ozDotNet' Subject: RE: ASP.NET web site I have got a response back from the author of the web site I am trying to investigate In short no it was NOT written in ASP and converted. This was however one of the first .Net Projects I undertook so it looks very similar to ASP style of programming. The code has never been compiled but placed AS IS on a web server. Again a habit from writing ASP for years before It targets .net framework 2.0. The aspx pages are a mixture of VB, Javascript and HTML. I have managed to get it registered in IIS 5.1 (old XP Pro desktop) and get the default.aspx page open. I can open it with vs2005 (installed specially for this purpose) as a web site. I can debug to a limited extent after attaching to aspnet_wp.exe. However many of my breakpoints cannot be hit (although some are?!). For most I get a circle with an exclamation mark and the message breakpoint will not currently be hit no symbols loaded for this document If I get an exception or if application logic is directed to a web page, breakpoints are ignored, so I just get the standard asp.net error page. If I try and build the web site (there is no project or solution files) I get build errors. Without being able to build in debug mode I would guess that there are no PDB files so no symbol information. I have never tried to work with anything quite this old. That this is even possible (no compilation) has surprised me. I am not sure how the author managed to debug this web site. Any ideas short of scrapping it and rewriting to try in order to debug it would be most welcome. Regards Peter Maddin Applications Development Officer PathWest Laboratory Medicine WA Phone : +618 6396 4285 (Monday, Wednesday,Friday) Phone : +618 9346 4372 (Tuesday, Thursday) Mobile: 0423 540 825 E-Mail : petermad...@iinet.net.au; peter.mad...@health.wa.gov.au The contents of this e-mail transmission outside of the WAGHS network are intended solely for the named recipient's), may be confidential, and may be privileged or otherwise protected from disclosure in the public interest. The use, reproduction, disclosure or distribution of the contents of this e-mail transmission by any person other than the named recipient(s) is prohibited. If you are not a named recipient please notify the sender immediately. -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ken Schaefer Sent: Wednesday, 14 December 2011 3:58 PM To: ozDotNet Subject: RE: ASP.NET web site Definitely a converted ASP application (plenty of articles touting how easy it as to convert ASP to ASP.NET by tweaking a bit of syntax back around 2001/2002). This type of page is the result. The use of ADODB and adovbs.inc is a give-away Cheers Ken -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Peter Maddin Sent: Wednesday, 14 December 2011 3:55 PM To: djones...@gmail.com; 'ozDotNet' Subject: RE: ASP.NET web site Thanks Yeah that is a 1.1 vb web page I suspected as much. looks like it was either a wizard conversion from asp to asp.net, It does look like a converted asp application. I actually checked out some asp examples in order to compare asp code with what I was looking at. Try turning option explicit off and option strict off in the project properties. I'll give that a try. My first reaction, is scrap it and rewrite I could not agree more but the powers that be would prefer one to maintain what's there and avoid a rewrite if possible. Which is the reason I decided not to do vb.net and do c# instead. I also decided not to use vb.net and go with C#. Have not regretted that decision until I was landed with this.
Name of process
Hi there I am trying to find the name of a process so I can then look for coding example on google to do it. Unfortunately it will be in VB6. Imagine. You have an irregular shaped circle with 400 points on the circumference. Each point is represented numerically as the radius from the center to that point. Now - you need to give this to a system that requires 1000 point, so you need to 'generate' additional points that would lie on the circumference if the original circle was plotted with 1000 instead of 400. I think the term is interpolating with bsplines but I am not sure. The company I work for manufactures lenses for specticles and some of the equipment will trace the shape of a lens using 400, 100, or 1000 points. And other machines that cut the lenses want 1000 points. So I need to convert the 400 point traces to 1000 ones. Many thanks for any advice Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems
RE: Govt .net jobs?
Plus the stigma of being 'just a contractor' and 'wasting Gov Money' from the permanents. Of course they never consider that contractors don't get the roster day off, public holidays, extra leave for anything, unions, leave loading, extended holidays, super perks etc. You are just seen as someone who is getting more per hour than them and that's it. This is from someone who was working as a contractor in a Gov Department. Dave -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of DotNet Dude Sent: Friday, 13 May 2011 4:52 PM To: ozDotNet Subject: Re: Govt .net jobs? No perks as contractor other than the pay in my experience On Fri, May 13, 2011 at 4:47 PM, Winston Pang winstonp...@gmail.com wrote: H, so you're saying it's pretty crap to work for govt? lol What about all the perks? On Fri, May 13, 2011 at 4:16 PM, Rob von Nesselrode rob...@austarnet.com.au wrote: I've met about 2 full time govt Employees. The whole floor in Bris at DET is full of contractors. Here today, take the money, gone tomorrow. Or in my case, gone yesterday to a fulltime job in the other world :-) R
RE: Smart sheet - how do they do it?
Sometime just doing a view source will give little snippets of information re what JS files are downloaded as well. As most AJAX controls need JS files on the client you can usually grab those as well and see if there is any copyright info in them ID'ing the company and the controls that are used. Reverse Engineering can be fun. Dave From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Kirsten Greed Sent: Thursday, 12 May 2011 2:15 PM To: 'ozDotNet' Subject: Smart sheet - how do they do it? Hi All I recently started playing with a web based project management solution www.smartsheet.com http://www.smartsheet.com/ The user interface is very smooth for something running on the web Can anyone tell me what it could be written in? Thanks Kirsten
Need Advice re Fibre Optic Network
Hi folks Ok.. I am in the process of setting up a small FC private network that will be used between 3 PC's (VM Hosts) and a SANs box. I have purchased 2 x 4 port and 6 x 1 port FC HBA's I have also purchased second hand a Brocade 3200 hub. Unfortunately it looks like I will need to purchase additional licensing for the Brocade for it to do 'Trunking' and this is an obsolete hub. With standard CAT-5 it is possible to use a crossover cable to connect PC to PC without the need of a hub, and if one has multiple NIC's then one can pair them together to increase the bandwidth. But with FC I cannot find much reference to this but I am sure it can be done. If I cannot get the Hub to Trunk can I then just drop in the 2 x 4 port HBA's into the SAN PC which will give me 8 ports.. And then pair them together to give me 4 dual speed ports. Then put 2 HBA's into each VM Host and pair those back to the SANs box. Any suggestion how to do this?, do I need to take part cables or are their adapters that will do it. Many thanks Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems
Help with Filesystem
Hi folks I have a NETMF project I am trying to work on - but the code from C# Framework 4.1 should work. My target is an SD card and I do not have any database capabilities like SQL.. In the old VB6 days you could create random files, and by defining the record length you could easily move from one record to the next. But I am at loss to find a similar type of functionality in C#. I can understand that to do this I will need to create a class, and serialise that class before storing the object on the disk.. But moving to a particular record has gotten me stuck. The only way I can see at the moment is to use the RecordLength * RecordNum and then SEEK to that byte location on the disk file. My memory space is also small so I cannot load the file into memory and move through it as a collection. Any suggestions/advice. Many thanks Dave cid:image002.jpg@01CAF8CB.4090A030 cid:image003.jpg@01CAF8CB.4090A030 David Boccabella IT Manager Shamir Australia Pty Ltd. | 1/23 Luke St. Lytton, QLD, 4178 P.O. Box 3346, Tingalpa DC 4173 P: 1300-553-465 | M: 0433-808-525 | F: 1300-554-075 http://www.shamir.co.il/ www.shamirlens.com.au image001.jpgimage002.jpg
RE: Help with Filesystem
Ok. So it’s a calculate and SEEK I just remember the old (and simple) VB6 system of defining a record and then just using GET and PUT to handle it, and was hoping that there was a ‘modern’ way to do it. Take Care Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith Sent: Wednesday, 17 November 2010 12:33 PM To: ozDotNet Subject: Re: Help with Filesystem You're a man of multiple hats, I see :) Looks easy them. Why don't you just go with the seek(recno * recsize) you proposed? (I'd still pad it to the natural blocksize though) Mike On 17 November 2010 13:21, David Boccabella davidboccabe...@anubis-systems.com wrote: I am using the SD card with a FAT file system. Many thanks Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith Sent: Wednesday, 17 November 2010 12:06 PM To: ozDotNet Subject: Re: Help with Filesystem On 17 November 2010 11:13, David Boccabella dav...@shamirlens.com.au wrote: Hi folks I have a NETMF project I am trying to work on – but the code from C# Framework 4.1 should work. My target is an SD card and I do not have any database capabilities like SQL.. In the old VB6 days you could create random files, and by defining the record length you could easily move from one record to the next. But I am at loss to find a similar type of functionality in C#. I can understand that to do this I will need to create a class, and serialise that class before storing the object on the disk.. But moving to a particular record has gotten me stuck. The only way I can see at the moment is to use the RecordLength * RecordNum and then SEEK to that byte location on the disk file. What level are you working at with the SD card? low-level SPI, secure or FAT file system? It's a 512 byte block, so you probably want your record to use a multiple of that, or pad it up. (memory's cheap) My memory space is also small so I cannot load the file into memory and move through it as a collection. Any suggestions/advice. Many thanks Dave cid:image002.jpg@01CAF8CB.4090A030 cid:image003.jpg@01CAF8CB.4090A030 David Boccabella IT Manager Shamir Australia Pty Ltd. | 1/23 Luke St. Lytton, QLD, 4178 P.O. Box 3346, Tingalpa DC 4173 P: 1300-553-465 | M: 0433-808-525 | F: 1300-554-075 http://www.shamir.co.il/ www.shamirlens.com.au -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough - Adam Hills -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough - Adam Hills image001.jpgimage002.jpg
RE: Help with Filesystem
Thanks guys. I'll have a look but my target is the NETMF and I'm not sure how much space I will have spare after the other code is developed. Currently I'm reading up on BinaryReaders and putting a byte array into a structure. If my structure is all numerics (ints) or char[] then there should not be too much issue. It's strings that seem to be the sticking points with structures due to the overhead's or lengths and padding.. Again thanks for all of your input. Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Ian Thomas Sent: Wednesday, 17 November 2010 1:54 PM To: 'ozDotNet' Subject: RE: Help with Filesystem Yes, as Mark points out, a lot of the VB6 stuff was migrated to .NET (long ago). There is quite a bit of helpful info in the language help, on MSDN (plus the VB6 to VB.NET Wizard, etc). _ Ian Thomas Victoria Park, Western Australia _ From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Mark Hurd Sent: Wednesday, November 17, 2010 11:48 AM To: ozDotNet Subject: Re: Help with Filesystem If you don't mind using the Microsoft.VisualBasic namespace (and assembly, but not Microsoft.VisualBasic.Compatibility), the FileSystem module is still available to you in C#, with FileOpen, FileClose, FileGet and FilePut, with RecordLength and RecordNumber parameters. -- Regards, Mark Hurd, B.Sc.(Ma.)(Hons.)
[no subject]
Does anyone here do anything with the MicroFramework? Many thanks Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems
Question re Formatting ASP.NET
Hi Folks I have a strange question and was wondering if someone can advise me in VS2010 (and others). Many years ago when I was doing ASP coding there was a lot of talk re embedded code in the web page, and the concept of mixing code with formatting was frowned upon. I am now doing some programming in ASP.NET and when I add a control like a DataSource it puts all of its properties within the ASPX page, not the code behind page. Is there a way to tell VS2010 to do this automatically, or some way to select a block and say 'to code page' Many thanks for any advice Dave cid:image002.jpg@01CAF8CB.4090A030 cid:image003.jpg@01CAF8CB.4090A030 David Boccabella IT Manager Shamir Australia Pty Ltd. | 1/23 Luke St. Lytton, QLD, 4178 P.O. Box 3346, Tingalpa DC 4173 P: 1300-553-465 | M: 0433-808-525 | F: 1300-554-075 http://www.shamir.co.il/ www.shamirlens.com.au image001.jpgimage002.jpg
Need some CMS Advice
Hi Folks I am currenly working on an application website for our company. Our marketing group want to beable to add pages and other stuff to the website on the fly. So - I am looking recommendations fo a CMS system that non-web literate folks can use easily. I have had a look at Umbraco and have had troubles getting it to work as it wants to take over the WHOLE website.. Not just say a Content Placeholder Does anyone have any suggestions. Many thanks Dave
RE: OT - Magic Mushroom song from the 1980s
I remember one time - before sound cards - you could very cleverly tell a PC to play sounds and music from its speaker. Only downside was that it suspended the interupts until the sound was finished. Anyway - I was at an office and someone (NOT ME!!) send an email with the attachment from When Harry met Sally, the famous fake orgasm scene. You can imagine the events when 20 PC all decided to almost simultaniously play that, and you could not stop it until it finished. Ah, the days before political correctness. Take Care Dave -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]on Behalf Of David Connors Sent: Tuesday, 8 June 2010 08:52 To: ozDotNet Subject: Re: OT - Magic Mushroom song from the 1980s On 8 June 2010 08:37, Dylan Tusler dylan.tus...@sunshinecoast.qld.gov.au wrote: Does anyone remember a clever little app that allowed IBM XT computers to play a song via the primitive PC Speaker that was installed in them? I think it was an ad jingle for some kind of room deodorizer called a Magic Mushroom? (I remember being blown away by it in about 1987. This was on green-screen XT computers, that normally only went beep.) I'm trying to find out about it for a nostalgic presentation. Not what you're asking for but this runs on an original 5150 apparently: http://www.youtube.com/watch?v=BrwGxwLuo5I I recall reading some time ago that you have to defrag the HDD well to get that ASCII streaming that smooth. lol -- David Connors (da...@codify.com) Software Engineer Codify Pty Ltd - www.codify.com Phone: +61 (7) 3210 6268 | Facsimile: +61 (7) 3210 6269 | Mobile: +61 417 189 363 V-Card: https://www.codify.com/cards/davidconnors Address Info: https://www.codify.com/contact
RE: [OT] Odd Question/Situation
We actually grind the lenses. Have a chat to your Optometrist. They are Shamir Autograph Office David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith Sent: Friday, 14 May 2010 10:07 AM To: ozDotNet Subject: Re: [OT] Odd Question/Situation On 12 May 2010 17:08, David Boccabella davidboccabe...@anubis-systems.com wrote: Working in an optical lens grinding company there are many ways to grind lenses to suit programmers. One of the main ones we do is call Autograph Office for that purpose. When grinding we not only take into account the direct vision i.e. – what the eye is looking at when looking ahead, but also when the eye needs to move side to side as in reading or looking at a computer screen. Does it work over 3 screens? As I said, my glasses are (for) long-distance, but the astigmatism exists still. For example – with the glasses I am wearing now - the centre of the screen is in focus, and the edges of the screen are also in focus and not distorted. That's neat. With non Office lenses you will find that the centre of the screen is perfect however the edges are blurred until you move your head to read the edges (by directing your vision). You cannot move your eyes because you will be looking at the lens through an angle. Trouble with 3 screens, is if I sit back far enough to look at the 3 screens without moving my head, the system's out of focus for me. Do you distribute in Canberra, and who is it? The same with the up/down vision as the lower section of the lens is ground to give better results when looking slightly down at a screen, and when you look up the upper part of the lens is ground for longer vision. So hopefully that will help. Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Stephen Price Sent: Wednesday, 12 May 2010 4:55 PM To: ozDotNet Subject: Re: [OT] Odd Question/Situation I had this cool idea of applying a distortion or blur over the top of your monitor so that it corrects for astigmatism. It would mean you could sit and look at your screen all day without needing to use glasses, and without getting tired eyes. The thing with astigmatism is that you have different focal lengths for vertical vs horizontal lines. Text is made up of both vertical and horizontal lines so your eyes continually refocusing (when I was younger my eyes could do it for a long time before getting exhausted so I didn't know I had it until I got older and started getting blurry vision after reading for half hour). It would be so cool to turn on an app and take off your glasses. :) On Wed, May 12, 2010 at 2:42 PM, mike smith meski...@gmail.com wrote: On 12 May 2010 15:04, Arjang Assadi arjang.ass...@gmail.com wrote: Got eye exam, got reading gleasses, But when there is zoom do we need gleasses? If we can change the size of what we read do we really need to use reading glasses (and keep the font the same size)? It just doesn't make sense , guess this is a question for Dr Carl! Glasses don't just fix magnification, they fix things like astigmatism http://en.wikipedia.org/wiki/Astigmatism_(eye) And probably other stuff - that's a lot of what my long distance glasses are fixing though. I know it is not Friday It must be Thursday, I never could get the hang of Thursdays. Regards Arjang -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough - Adam Hills -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough - Adam Hills
RE: [OT] Toner hell
A lot of places can sell the toner and a replacement 'chip' for the cartridge. I refill my Dell 1320c for about $45 a go. Ok - a look at this fellow http://www.inkman.com.au/search-results.asp Has cartridges for the C524 High Yield for about $164 inc Or this http://cgi.ebay.com.au/1x-Lexmark-C522-C524-C532-C534-C532N-C534N-Toner-Refi ll-/180421790447 An you can fill your own for $59 per colour. This fellow is really good and I get my refills from him. You get the toner, chip, instructions.. and you cartridge is as good as new Hope this helps Dave David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Friday, 14 May 2010 10:29 AM To: 'ozDotNet' Subject: [OT] Toner hell Friday fun ... our Lexmark C524DN printer beeps this morning and tells us that the Magenta toner is low. These are colour starter cartridges in a 6 month old printer, so I expect the other two to go soon. Web searches show the average cost of high-yield colour cartridges to be about $260-$330. The bloke in my local printer shop has confirmed that he can't get much cheaper than that. He said his previous attempts to refill these brands were not successful and he's abandoned working on them. He thinks there might be other shops who have refilled them successfully and suggests I ring around. So, thanks to the evil international conspiracy of printer manufacturer cartels, the cost of replacing the colours will be more than the original price of the printer. Do I dump this 40kg monster in the bay and buy a new one, or is there are way of getting the colours refilled or replaced for a reasonable price? I'm in the Melbourne south east suburbs if anyone has suggestions about where to look, or perhaps where the best AU online bargains are. I continue to ring shops and web search... Greg Ps. Imagine buying a $40,000 car with half a tank of petrol. You have fun driving it for a few weeks before the fuel light flashes. Then you find a full tank of petrol costs $55,000. What do you do?
RE: [OT] MSAccess developer wanted
I rarely link to a JET engine when using MSAccess. If I use local tables then it is for temporary storage only. However where I find MS Access most useful is for joining together different DB Engines For example (and if I am contracting I rarely have a say over the environments) A customer wants to create some stats using the sales system, stock system, and MYOB financial package. However the Sales system is MSSQL, the Stock system is Oracle, and MyOB is.. well MyOB, plus throw in MySQL and a few others then you can be looking at a technical nightmare. Yes I can do dumps and export/import into a standard format however with MS Access I can LINK to the separate databases and then do the necessary joins/summations etc within MS Access. Its slower however it does give a level DB playing field when one needs to join together a lot of data. Another good thing about MS Access is that it can be easy to teach a non DBA or programmer to use. For example I can create a low level DB user who only has read access. Link to the DB using MS Access and this user, and I can give this to a manager who can have HOURS of fun crunching stats... leaving the programmer to do more productive tasks. Likewise doing reports. With the built in wizards MS Access makes it easy for a non programmer to whip up a batch of reports If MS Access good for large scale development - maybe not, and yes - there can be issues re recrd locking.. But as a tool for data crunching for the inexperienced or non developers it can be invaluable. Just my thoughts on the subject. David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems
RE: [OT] MSAccess developer wanted
Hi Tiang Yes - that is a good scenario where MS Access can be of benefit. For example - you run the report wizard. It asks the user the following 1. Table/Query to use 2. Fields on the report 3. Sorting or grouping 4. Totaling And it can then churn out a report that can be used immediately or expanded on. You can build quick apps in MMS Access as well like simple data entry. Or build queries that link together a lot of tables. I look on it as a sort of Database Glue - where you can merge all sorts of info together quickly for a test run, and then proceed to developed something more permanent later. One of the great confusions re MS Access is that people mix the name for both the Database and the Application. Technically the database layer is the JET engine, and MS Access is the application. JET has a number of issues, 64 bit compatibility, speed, size of the database, and locking/corruption issues as well. Also because it is so easy for managers to build small applications (hence my recommending R/O access) you can get a lot of terrible code out there from learners and beginners. Or some major DB corruption However the MS Application still works very well re chatting to other databases. One downside (unavoidable) is that if you wish to join tables from different databases then MS Access will do the join in memory so speed will be a factor. But the simple fact that you CAN join between different databases makes it a very powerful little helper. I hope this helps settle the confusion Dave -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Tiang Cheng Sent: Wednesday, 14 April 2010 12:30 PM To: ozDotNet Subject: RE: [OT] MSAccess developer wanted Another good thing about MS Access is that it can be easy to teach a non DBA or programmer to use. For example I can create a low level DB user who only has read access. Link to the DB using MS Access and this user, and I can give this to a manager who can have HOURS of fun crunching stats... leaving the programmer to do more productive tasks. That sounds pretty awesome. Is this a scenario where we can give non-technical users access to generate their own query reports based on data in MSSQL? Tiang
RE: [OT] MSAccess developer wanted
Hey – I use MS Access to make code generators for dotNET : Its fast, easy, and can glue a lot of different data sources together. Also great for doing fast reports too. If your looking for a RAD tool to get something simple up and going so you can take your time to get the main app just right then MSAccess is a good stepping stone. Dave (who even remembers VB v1 and has emails from Alan Cooper) David J. Boccabella Proprietor Anubis Systems Phone: 0433 808 525 Fax: 3200 0085 Email: mailto:boo...@cvsol.com davidboccabe...@anubis-systems.com This e-mail and it's contents is confidential to Anubis Systems. This e-mail, any attachments, or any part of can not be reproduced without the express written permission of Anubis Systems From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of mike smith Sent: Tuesday, 13 April 2010 10:20 AM To: ozDotNet Subject: Re: [OT] MSAccess developer wanted On 13 April 2010 10:02, Greg Shaw g...@decisionware.com.au wrote: A friend asked me if I knew any MSAccess developers and I figured there might be 1 or 2 lurking on here. I'd have hoped they'd have seen the writing on the wall from Microsoft about programming MSAccess. He has a client who is seeking an MSAccess developer to work on his booking and resource allocation system. The guy who originally developed the system is no longer available. The work will probably be on-going. Based in Sydney's south west. Anyone interested please email me off list and I'll put you in touch. Cheers, Greg. -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure, you'll get it, but it's going to be rough - Adam Hills