single non networked machine. One day somebody might get access to it over
ADSL (probably TS), but for now it's a single user no lan.
The machine will actually be running the MSDE. Windows XP Home.
I'm quite happy, for now, to put all the business logic in SQL Server.
Triggers, SPs etc.
I've got a fair bit of Access development experience.
What's the absolute quickest way to develop a client for this?
MDB or ADP client?
OLE-DB or ODBC connection?
Bound or unbound
My experience is with Access 97/2000 FE/BE type apps.
I've got ADSL, the customer's got ADSL, so any emergency DBA type stuff I
can do via VNC.
Yours opinions, as ever, are most valued and welcome.
MikeI would suggest an Access MDB with linked tables and bound forms as the
'RADiest' way to get your front end developed. There are inherent
performance issues with this methodolgy, but they will not likely be
apparent in the setup you have described. And any processes that are too
slow or require client server can be converted to unbound ADO connections
running stored procedures etc after you have build your prototype.
Andrew Chanter (RAD solutions)
"Mike MacSween" <mike.macsween.zerospamplease@.btinternet.com> wrote in
message news:419a766c$0$221$5a6aecb4@.news.aaisp.net.uk...
> I've got a SQL Server database. Nearly finished. It's going to go on a
> single non networked machine. One day somebody might get access to it over
> ADSL (probably TS), but for now it's a single user no lan.
> The machine will actually be running the MSDE. Windows XP Home.
> I'm quite happy, for now, to put all the business logic in SQL Server.
> Triggers, SPs etc.
> I've got a fair bit of Access development experience.
> What's the absolute quickest way to develop a client for this?
> MDB or ADP client?
> OLE-DB or ODBC connection?
> Bound or unbound
> My experience is with Access 97/2000 FE/BE type apps.
> I've got ADSL, the customer's got ADSL, so any emergency DBA type stuff I
> can do via VNC.
> Yours opinions, as ever, are most valued and welcome.
> Mike
No comments:
Post a Comment