New app, old developer

[Kevin3NF]

Wow. Got called by a company ready to move from spreadsheets to Access

What is the currently preferred app dev for SQL/Access convercing versions?

I'm thinking SQL 2005 Express and Access 2003 (unless the connectivity with
Access 2007 is recolved...I honestly have no idea).

Non-Access FE is not on the table for two reasons:
1. Its all I know as a SQL Server guy....
2. They know it well enough to make tweaks on their own without paying my
rate

Just polling the group to see where you would go on this.

Thanks!

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

 

[Larry Linson]

Wow. Got called by a company ready to move from spreadsheets to Access

What is the currently preferred app dev for SQL/Access convercing
versions?

I'm thinking SQL 2005 Express and Access 2003 (unless the connectivity
with Access 2007 is recolved...I honestly have no idea).

Non-Access FE is not on the table for two reasons:
1. Its all I know as a SQL Server guy....
2. They know it well enough to make tweaks on their own without paying my
rate

Just polling the group to see where you would go on this.

I suspect your thinking is correct, Kevin. There are still issues to be
resolved with Access 2007, and unless the client/customer has moved to
Office 2007, the UI will be even more unfamiliar to their users as it will
to the developer. On the other hand, I'd just use Access 2003 and a split
FE/BE unless there's a compelling need to back-end it with SQL Server, even
Express.

Larry Linson
Microsoft Office Access MVP

 

[Kevin3NF]

Aside from the ease of corruptibility, hackability and deletability of the
Access B/E, I agree!

Seriously...I'll take the free SQL with its better security, performance and
maintenance tools any day. Especially in this environment where sales
people run amuck in the data...

Thanks Larry....many years no see
--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

 

[Larry Linson]

Aside from the ease of corruptibility, hackability
and deletability of the Access B/E, I agree!

One needs, of course, appropriate tools for appropriate tasks and
environments. But, truly, the split Access/Jet multiuser environment is
adequate more often than it may seem to us who have been "sensitized" to
hacking and/or accidental deletion.

Seriously...I'll take the free SQL with its better
security, performance and maintenance tools any
day. Especially in this environment where sales
people run amuck in the data...

If there's anybody likely to be running amuck in my databases, I'll consider
the need for a backend server to be _compelling_, too. Most of the paying
work I've done over the years has, as I think you know, been Access clients
to server DBs (most of them were ODBC-compliant, but only a few were MS SQL
Server).

Thanks Larry....many years no see

Drop by and visit at 11:00 AM some Third Saturday... directions to our new
meeting place are at http://www.ntpcug.org, and details on the Access SIG
are directly accessible at http://sp.ntpcug.org/accesssig/default.aspx.

Larry Linson
Microsoft Office Access MVP

 

[Kevin3NF]

Thanks...but I promise you don't want me coming around on a Saturday
morning. As a competitive bike racer, I'm usually finishing up a 30-50 mile
ride or race about that time.

I'd sweat all over your presentations

I suppose the biggest issues I have with the Jet/MDB backed are the
susceptibility to corruption due to network glitches (been there done that,
save d the customer), and someone deleting the file to save drive space.
Its just too easy.

But...right tool for the job, eh?

There is a distinct possibility I won't take this gig. I'm about 50/50 on
it for now, since I am getting out of the independent game. I may be
looking for a qualified person to run with them. At most this is 100 hours
of work. Ping me offline if you might be interested.

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.