Re: Upgrading Access 97 application to dotNet

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.







.

Relevant Pages

  • Re: Upgrading Access 97 application to dotNet
    ... You're an Acccess wannabe programmer! ... RobinS wrote: ... SQL Server Express is well suited to small workgroup environments. ... 1GB of RAM and 4GB per database. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Server user list
    ... SQL Server MVP ... "Patrick" wrote: ... > I have inherited SQL server which need a lot or clenup work to do. ... > How can I know all users on server who don't have access to any database. ...
    (microsoft.public.sqlserver.programming)
  • File Sharing Violation
    ... I am sure that I have open only one connection to my SQL Server CE Database ...
    (microsoft.public.pocketpc.developer)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)