[AccessD] Freelancing

Today, I typically use Access for only a handful of things.
 
--Custom little widgets/tools I need personally because I don't want to buy something or can't find exactly what I need(my own little task tracker).
 
--Many times I will get a batch of files (xls,txt) that need to be put into SQL server...each time different files, different data, different server...I'll open up a form, create a button and use vba to do the looping, importing, exporting etc...go to lunch and my 500 files are now 1 file ready for SQL server.
 
--I also use it to do a quick 'mock-up' of how an app will look and how the data will come out.
 
Pretty much anytime I need to do a 1 time automation type task...I use Access...(my boss uses Foxpro in the same fashion).
 
Not sure how I ended up here...but its where I am and Access helped pave the path. (and I can bring my dog to work!!!)
 
Just my 2c.
 
Mark A. Matte
 
 
P.S...Just remembered a cool one.  Need a little over 1000 html landing pages with pretty much same content, just different label name and different link...loaded all the variables in access...VBA loop to open template.html as text ...search and replace with variable...save as variable.html...10 minutes=1000 custom HTML pages...I thought it was kinda cool.
 

 

> From: ssharkins at gmail.com
> To: accessd at databaseadvisors.com
> Date: Fri, 26 Aug 2011 15:34:54 -0400
> Subject: Re: [AccessD] Freelancing
> 
> 
> It's Access -- the work for Access developers is disappearing. :( Consider 
> SQL Server. Don't forget apps for smartphones -- big business right now. I'm 
> not sure anyone's getting rich, but it's something to fill in empty hours!
> 
> Susan H.
> 
> 
> > Hey Susan
> > Your article was an eye opener.
> > I have been producing database applications for over 20 years. No ego 
> > being
> > inferred but I figure I have produced quality products that are 99.9%
> > bullet proof (many are still in use today). But I feel I am going the way 
> > of
> > the dinosaur. Since the 2008 recession I have found that most companies no
> > longer want to spend money to save money (no matter want you do to try and
> > convince them of such). To be honest, on my end, the market is drying up. 
> > I
> > am kind of looking at leaving ACCESS and starting to develop customized
> > iPad/iPod (whatever) "Apps" for clients. If that doesn't work then I will 
> > be
> > buying a "Weenie" wagon and hanging out at the beach. Not a boo hoo
> > scenario, just reality.
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com