|
And we have a winner.
You are up on monday.
I thought it looked a bit like a slice of pizza
|
|
|
|
|
Nicholas Marty wrote: I thought it looked a bit like a slice of pizza
I thought that too, but dismissed the idea, I couldn't see the pineapple.
|
|
|
|
|
Pineapple on pizza is wrong.
Very, very wrong.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
|
|
|
|
|
Gosh he anticipated me! Doh!
chriselst wrote: Pineapple on pizza is wrong.
Very, very wrong.
A whole new level of wrong
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
"When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey
|
|
|
|
|
here. 'specially for you
<🍍@@)
|
|
|
|
|
Yep, I can see that now that I know the answer.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
|
|
|
|
|
Nicholas Marty wrote: I thought it looked a bit like a slice of pizza
Rally?? I mean I thought it looked a LLLOTTT like a mouse, but couldn't fit the world in the clue
|
|
|
|
|
What? I took one look, saw a racecar, thought SPEED, and it fitted, slapped myself on the back and .. it's PIZZA?
|
|
|
|
|
Duuude you got it, how didn't i come up with that!
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Just updated office 365 and along with it Access 2016.
I've never used it. Does anyone use it? What for? and should I?
|
|
|
|
|
It is poison, don't use it, we have so many application written by a lousy programmer in MS Access that i just can tell you STAHP, don't even think about it. Although for home DB stuff where you like to do things clicky shiny fast you might peek into it
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Professionally I use SQL Express, LocalDB and MySQL and couldn't think of any reason to use Access. Just though it was a hang over from another era, and looking at the comments, looks like it is.
So why is it still shipped? MS has dropped other technologies over the years? I guess it still has a large user base
|
|
|
|
|
SPoss wrote: Just though it was a hang over
Given the case, hangover would be more appropriate.
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
"When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey
|
|
|
|
|
As i said, it is easy to set up stuff, so non programmers and hobby IT people can use it. That's the result of big "fanbase" i'd say.
But if you start coding and doing stuff in it you'll get sick...
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
I use MS-Access.
There is no other choice if you need a multi-user database shared over a network, and you can not install SQL Server or any other database server. You cannot achieve this with SQLite or SqlServer Compact Edition.
|
|
|
|
|
I believe even Microsoft has said to NOT use Access for multi-user database shared over a network.
|
|
|
|
|
where? i'd like to see that.
|
|
|
|
|
Unfortunately, it was a LONG time ago when I read that. I think it was around the time Sql Server Express came out.
Google or Bing will reveal many non-Microsoft people who have had trouble with corrupted Access database files when trying to share on a network.
In fact, that was what caused me to first try Sql Server Express. I was brought in to help fix an Access application that was getting corrupt access network files. So I switched the whole Access application to using Sql Server Express instead and they never had another problem.
At that time Sql Server Express was limited to 5 simultaneous usage, but I think they have taken that and other limits off in the more recent versions.
|
|
|
|
|
|
I think that about all I use Access for anymore is the "documenter". I use SQL Server but access has a neat and concise way to print off details of the tables that I haven't found anywhere in the stock SQL Management utility.
|
|
|
|
|
Access is part of about 90% of my development projects. Usually as a RAD front end to MySQL, PostgresSQL, Oracle, SQL Server, and sometimes more than one at the same time. How many dev tools do you know that can connect to SQL Server, MySQL and Oracle at the same time?
The ACE DB Engine is really only good for apps with tables less than 100K records, or so, but Access makes a great desktop front-end. Access != ACE (Access <> ACE for the VB fans).
Yes, it's best use is for desktop apps connected to shared data for 20 or less people (up to 50 with a RDBMS back-end). The Sharepoint/web integration is basically hell, since you can only use macros (no VBA). Using macros is like trying to build a house when the only tool you have is a bag of sporks. Although, the new JavaScript integration in 2016 may help change that.
As I've grown as a coder, it took me a while to understand certain concepts that are now must have features in modern languages/ide's: Managed Code, VBA in Access has always been managed. Lambda Expressions, oh, you mean you can just create a function and call it from anywhere? You know, like a function in an Access module rather than class.
Binding fields in a table to controls on a form is ridiculously easy (built-in sanitizing, character limits that match the field, data-types, a plethora of events to add validations, etc.). Don't worry if this frightens you, its lack of layers scares many.
But, then again, you may not want to listen to me as I am a wildling coder. After some excellent instruction in high school, I did not go the the ivory towers and have spent most of my career on the other side of the wall between IT and everyone else... solving problems as quickly and efficiently as I can, with only the tools I have available to me.
"But then, something happened that the ring did not intend." - Fellowship of the Ring
|
|
|
|
|
Though I wouldn't want to try to support a commercial multi customer app in Access (did that), it's a very useful companion tool to any development and great, especially due to integration with excel, as a tool in data conversions.
I use .NET, node and other modern tools, and cram until my head aches to try to stay up to date, but I also use Access as a flexible utility, data monitor, checker, builder, relater. i can whip up a form to watch or query certain data that i need to look at on the fly when developing.
plus i have a few customers that still use and like access. if it ain't broke, don't fix it.
|
|
|
|
|
MS Access is for the quick and dirty applications involving less than 100k records. I find it useful keeping track of my CD collection. (Now, which cabinet has that Sonny and Cher album?)
The difficult may take time, the impossible a little longer.
|
|
|
|
|
Paradox (ex-Borland, now Corel) is a much better database manager: faster, better user interface. Access drives me clicky-crazy! Sadly, that's probably not a choice you have at this point.
|
|
|
|
|
Programming a large application in Access is really difficult. But MS lets people get started with Access with no programming knowledge threshold. Access works if you know how to make it work - but people with the skills to do that are programming something else.
|
|
|
|