R
Ricter
I'm watching my grow little by little and got to wondering what monsters the
pros have created...
pros have created...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
aaron.kempf
I've built a half-dozen over the years with more than a couple hundred
reports
I just don't think that MDB is stable enough to warrant the effort. I
use Access Data Projects.
-Aaron
reports
I just don't think that MDB is stable enough to warrant the effort. I
use Access Data Projects.
-Aaron
J
Jeff Boyce
Ask Tony Towes ... he's described a pipeline management system that sounds
like it qualifies!
By the way, by monster, do you mean?:
* many many records
* many many objects (forms, queries, reports, lines-o-code)
* many many hours required to keep it running, or
* ???
Regards
Jeff Boyce
Microsoft Office/Access MVP
like it qualifies!
By the way, by monster, do you mean?:
* many many records
* many many objects (forms, queries, reports, lines-o-code)
* many many hours required to keep it running, or
* ???
Regards
Jeff Boyce
Microsoft Office/Access MVP
A
aaron.kempf
I was thinking 'pipelines' who needs to keep track of pipeline details?
(ive built 2 or 3 apps over the years that keep track of telephone
poles and the boxes on them-- so i'd better shutup)
-Aaron
(ive built 2 or 3 apps over the years that keep track of telephone
poles and the boxes on them-- so i'd better shutup)
-Aaron
J
John Vinson
I was thinking 'pipelines' who needs to keep track of pipeline details?
British Petroleum didn't... now they've had to shut down Prudhoe Bay
and oil's up ten bucks a barrel.
Maybe they should have hired Tony!
John W. Vinson[MVP]
A
aaron.kempf
LoL. That mess has turned into a criminal investigation now...
-Aaron
-Aaron
J
Jeff Conrad
You may find this interesting:
http://accesstips.datamanagementsolutions.biz/apps.htm
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
in message:
http://accesstips.datamanagementsolutions.biz/apps.htm
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
in message:
A
aaron.kempf
friggin fabulous apps.. are they all freely downloadable?
Maybe i'll convert them all to ADP some weekend and show you kids some
real stuff
-Aaron
Maybe i'll convert them all to ADP some weekend and show you kids some
real stuff
-Aaron
T
Tony Toews
Jeff Boyce said:Ask Tony Towes ... he's described a pipeline management system that sounds
like it qualifies!
Yup, but there are one or two I've heard about that are close in size.
ERP app for a welding shop with several hundred welders. Handles
drawing status, material receiving, inventory, scheduling,
fabrication, very complex quality control (15 different types of
tests), shipping and invoicing.
All for refineries, oil sands processing plants, power plants, etc,
where the wrong piece of steel can cost someone a billion dollar
shutdown.
Twenty five users in Alberta and Ontario. One hundred sixty tables,
450 forms, 350 reports.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
A
aaron.kempf
Tony;
you're still a fucking pussy for using MDB.
I've built several apps with several hundred reports.
MDB has given me stability problems at a half-dozen users and 30mb in
data. And don't start about how i haven't seen X or I haven't done Y.
I've worked with hundreds of Access apps over the past decade.
What a joke. I mean-- do you really want to spend all your time
finding workarounds? Do you spend half your time juggling your front
end updater bullshit? Making your end users wait 10 seconds each time
that they open their app? That isn't acceptable these days.
Keep all your tables and queries on the database server and deployment
becomes about 100 times simpler.
Queries on top of queries just randomly crap out?
Compact and Repair?
ROFL wake up to the 90s kids; MDB is DED.
I'll run your shit through my upsizing wizards and presto chango give
your end users 3 times the performance.
-Aaron Kempf
ADP Nationalist
you're still a fucking pussy for using MDB.
I've built several apps with several hundred reports.
MDB has given me stability problems at a half-dozen users and 30mb in
data. And don't start about how i haven't seen X or I haven't done Y.
I've worked with hundreds of Access apps over the past decade.
What a joke. I mean-- do you really want to spend all your time
finding workarounds? Do you spend half your time juggling your front
end updater bullshit? Making your end users wait 10 seconds each time
that they open their app? That isn't acceptable these days.
Keep all your tables and queries on the database server and deployment
becomes about 100 times simpler.
Queries on top of queries just randomly crap out?
Compact and Repair?
ROFL wake up to the 90s kids; MDB is DED.
I'll run your shit through my upsizing wizards and presto chango give
your end users 3 times the performance.
-Aaron Kempf
ADP Nationalist
R
Ricter
Number of objects and code complexity is what I was wondering about. And
wow! 160 tables, 450 forms and 350 reports!? That's pretty intense.
wow! 160 tables, 450 forms and 350 reports!? That's pretty intense.
A
aaron.kempf
Rick;
that is great!!
I urge you to lose the training wheels and use Access Data Projects.
-Aaron
that is great!!
I urge you to lose the training wheels and use Access Data Projects.
-Aaron
T
Tony Toews
[email protected] said:I urge you to lose the training wheels and use ...
Rubbish.
Access and Jet work well as do ADPs and SQL Server. They each have
their own niche. And I suspect the work in upgrading his app to ADP
would take a lot longer than any possible benefit. If anything he
could link to SQL Server tables.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
D
dbahooker
Tony;
you are a complex LIAR.
Access / Jet doesn't work 10% as well as ADP.
What happens when you have parameters in your sproc??
What happens when you change a query-- do you really want to wait 30
seconds for each end user to open their app so that it can sync the
queries?
You're stuck in the 80s, kid.
And Canada?
Canada?
Yes.. upgrading to ADP is DIFFICULT.
Is it my fault that you're a fat, lazy Canadian?
You should have realized that MDB was obsolete the DAY that Access 2000
came out.
MDB is for WIMPS and so is Canada.
you are a complex LIAR.
Access / Jet doesn't work 10% as well as ADP.
What happens when you have parameters in your sproc??
What happens when you change a query-- do you really want to wait 30
seconds for each end user to open their app so that it can sync the
queries?
You're stuck in the 80s, kid.
And Canada?
Canada?
Yes.. upgrading to ADP is DIFFICULT.
Is it my fault that you're a fat, lazy Canadian?
You should have realized that MDB was obsolete the DAY that Access 2000
came out.
MDB is for WIMPS and so is Canada.
T
Tony Toews
Someone wrote:
Nothing here worth responding to.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nothing here worth responding to.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
R
Rick Brandt
Tony said:Rubbish.
Access and Jet work well as do ADPs and SQL Server. They each have
their own niche. And I suspect the work in upgrading his app to ADP
would take a lot longer than any possible benefit. If anything he
could link to SQL Server tables.
Tony
In fact, of my 307 tables there is only a handful of work tables that are Jet
tables. All the rest are SQL Server (three different servers and two different
versions) and UDB400 tables on an IBM ISeries box.
If I felt like shackeling myself with an ADP I would be restricted to exactly
one SQL Server database. I could scarcely call that a real application.
A
aaron.kempf
not one DATABASE.. you mean.. ONE DATABASE _SERVER_
DATABASE.OWNER.OBJECT
or
DATABASE.SCHEMA.OBJECT if you live in the SQL 2005 world
-Aaron
DATABASE.OWNER.OBJECT
or
DATABASE.SCHEMA.OBJECT if you live in the SQL 2005 world
-Aaron
A
aaron.kempf
ONE SERVER
you have to maintain one connection.. and then you can always refer to
other tables as you like.
set a recordsource to
Select * from Master.Dbo.Sysobjects - you can point to any DATABASE
that you would like to.
Now trying doing THAT with linked tables.
-Aaron
you have to maintain one connection.. and then you can always refer to
other tables as you like.
set a recordsource to
Select * from Master.Dbo.Sysobjects - you can point to any DATABASE
that you would like to.
Now trying doing THAT with linked tables.
-Aaron
D
dbahooker
you don't think that CORRECTING MIS-INFORMATION about ADP is
newsworthy?
it's not limited to a single database.
if anything; it is limited to a single server.
but right-click LINK in ADP is _ALMOST_ as easy to use as right-click
LINK in MDB.
Except you only need to do it in one place.
Aren't you tired of looping through all your SPT (Sql Passthrough) and
changing the connection string?
compacting and repair?
refresh / relink?
Linked table manager?
Importing / Exporting Queries?
How the **** do you think that you are? ADP KICKS MDB's ASS BUDDY
Parameterized sprocs vs MDB queries?
HAHAHAHAHAHA ROFL
newsworthy?
it's not limited to a single database.
if anything; it is limited to a single server.
but right-click LINK in ADP is _ALMOST_ as easy to use as right-click
LINK in MDB.
Except you only need to do it in one place.
Aren't you tired of looping through all your SPT (Sql Passthrough) and
changing the connection string?
compacting and repair?
refresh / relink?
Linked table manager?
Importing / Exporting Queries?
How the **** do you think that you are? ADP KICKS MDB's ASS BUDDY
Parameterized sprocs vs MDB queries?
HAHAHAHAHAHA ROFL
R
Rick Brandt
ONE SERVER
you have to maintain one connection.. and then you can always refer to
other tables as you like.
set a recordsource to
Select * from Master.Dbo.Sysobjects - you can point to any DATABASE
that you would like to.
Now trying doing THAT with linked tables.
-Aaron
Are you suggesting that one could not create a link to
Master.Dbo.Sysobjects? Even more stuff you don't know apparently.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.