Will speed be a problem for using access in the company?

[David W. Fenton]

Everyone please note that Aaron Kem.pf is attempting to
impersonate one of our regular posters again. Tom would never
post such a message.

Do people *still* think that Aaron Kempf is not Don Mellon in
disguise? The MO is exactly the same:

1. first use lots of throwaway hotmail and gmail accounts to create
a group of sock puppets.

2. then start impersonating real posters using more free email
accounts.

 

[Tony Toews [MVP]]

Do people *still* think that Aaron Kempf is not Don Mellon in
disguise? The MO is exactly the same:

The MO is similar but the postings content is very different.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

Splitting the data/BE does help prevent corruption so what reason is
there for this separation except to save 10 seconds on loading?

Well, I'm not sure sure you'd save that 10 seconds. Leaving an FE MDB/MDE means that
you'd have to fetch various objects such as queries, forms, reports and modules from
the server as required. Thus leading to a sluggish app. That said one of my clients
chose to do this on a Citrix environment and it wasn't too bad. However I designed
the Auto FE Updater to ensure each user on the Citrix server had their own copy of
the FE MDE anyhow.

Also you'd only need to copy down the FE when there's a new version on the server.

Especailly with Access 2002/2007 versions, is this extra complication
going to help.
Yes.

The main reason I am against this is that we have three enviroments
for each system, Developement, Testing and Production. So the front
end always checks and updates it's links to the BE in the same
directory.
This makes moving the updates to testing and then to production very
simple.

You could put some code in to handle this situation. For example designate some
workstations as development, test or other. Then ensure the tables are linked to the
appropriate backend depending on that designation.

I saw some articles regarding errors with people updating filters, but
is this still the main reason why you would want to put the FE on the
user's pcs?

Sharing an Access FE MDB/MDE can cause corruptions in the FE MDB/MDE. And downright
wierdness. You also can't update the FE MDB/MDE to a new version until everyone is
out of it.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[dbahooker]

dude you're crazy

use Access DAta Projects

you don't need to deploy anything; and performance is always a lot
better

 

[dbahooker]

how is it easier on a server?

u can create a query in ONE PLACE-- where it belongs-- ON A DATABASE
SERVER


Access Data Projects are 10 times simpler; lose the training wheels
you newbie, so-called 'David Fenton'

 

[dbahooker]

if you wanted 'very simple' you'd just use an Access Data Project

these can work with 3 different tiers quite easily

and you don't need to write code to do it!


aren' you tired of changing the connection strings on your SQL
passthroughs?

ROFL

 

[dbahooker]

James

you're a liar and a fucking cock sucker

splitting the database is no longer reccomended.
it is reccomended to use Access Data Projects because it has LESS
LAYERS OF COMPLEXITY than a 3-tier MDB application

 

[dbahooker]

splitting isn't logical, fucktard

using Access Data Projects is logical
plug and play, no deployment hassles

and REAL SECURITY, REAL DRI AND TRIGGERS?

AND ETL?

Access MDB has _NO_ benefits over MDB

 

[dbahooker]

Who the **** is Don Mellon?

Do people *still* think that Aaron Kempf is not Don Mellon in
disguise? The MO is exactly the same:

1. first use lots of throwaway hotmail and gmail accounts to create
a group of sock puppets.

2. then start impersonating real posters using more free email
accounts.

 

[dbahooker]

Gunny

had good computer skills?

you dipshits can't calculate ROI and you can't decide on a decent
database platform .

I asked my dad the other day 'so what would happen if you had a
database that crapped out once a month'

a) bitch about it
b) get it fixed
c) find someone with a real database

the logic is really straight-forward

anyone using MDB should be fired and then spit upon