Re: Upgrading Access 97 application to dotNet
- From: Tim Patrick <invalid@xxxxxxxxxxxxxxxxxxx>
- Date: Sat, 2 Dec 2006 05:38:25 +0000 (UTC)
I think you read the postings incorrectly. He said that he can NOT let the database run on the central server. Also, my advice included a continued use of the Access database with just an updated front end in VB2005. Without knowing the full specifics of his situation, all we can do is offer general advice and options. It is up to him to make the right choice.
-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
RobinS and Patrick,
Do you think that it is helpful to show people a wrong way of use of
tools.
kavsaks organisation is obvious afraid that he build applications in
his organisation and now we are helping to brake those rules with all
kind of bad advices.
He just need to get his application running on his central
organisation server. If not, then the organisation does not need his
application.
Just my idea maybe not so well written but I hope you understand what
I want to say. If not I will repeat it.
Cor
"RobinS" <RobinS@xxxxxxxxxxxxxxx> schreef in bericht
news:kLSdncGlAP1_I-3YnZ2dnUVZ_sCdnZ2d@xxxxxxxxxxxxxx
You *could* put a SQLServer database out there and use it.
This is from a post by David Browne back in mid-November; he said
you could use SQLServer express for multiple users. These are the
restrictions.
-----
SQL Server Express is well suited to small workgroup environments.
It has no connection limit or workload governer. Rather it is
physically
limited to 1CPU, 1GB of RAM and 4GB per database. By default the
installer
doesn't enable remote connections to the database, but that's just to
be
"secure by default". You can enable remote connections after the
install
and you're good to go.
-----
However, I have to admit, I'd probably use Access, because it's so
easy to manage (assuming the database isn't huge).
Robin S.
-----------------------------
"Tim Patrick" <invalid@xxxxxxxxxxxxxxxxxxx> wrote in message
news:e3b4697630578c8e36ddd769512@xxxxxxxxxxxxxxxxxxxxxxxxx
Gee, this doesn't sound like a technology issue.
SQL Server does run as a service, not as an application like Access,
or as an extension of your own program like OLE DB and the like. SQL
Server Express does have a mode that lets you access an MDF file
(similar to an MDB file) directly instead of through the normal
server-based methods, but I don't know if that method would support
multiple users. I've never used that file-based method, and I think
it only applies to the Express version of the product.
VB2005 continues to support Access just fine, so you're free to
continue with that data source.
-----
Tim Patrick - www.timaki.com
Start-to-Finish Visual Basic 2005
Thanks for the prompt reply, but I really do mean that there can be
no server. Using someone elses workstation is not an option either.
Central data storage and individual database engines are mandated.
There is a very large amount of paranoia in this grey suited
organisation.
.
- Follow-Ups:
- Re: Upgrading Access 97 application to dotNet
- From: Cor Ligthert [MVP]
- Re: Upgrading Access 97 application to dotNet
- References:
- Re: Upgrading Access 97 application to dotNet
- From: Cor Ligthert [MVP]
- Re: Upgrading Access 97 application to dotNet
- Prev by Date: Re: best way to learn Windows Forms
- Next by Date: Re: Best way to get a Junior Programmer up to speed
- Previous by thread: Re: Upgrading Access 97 application to dotNet
- Next by thread: Re: Upgrading Access 97 application to dotNet
- Index(es):
Relevant Pages
|
