Re: Upgrading Access 97 application to dotNet


My impression from the original post was that he had a VB6
desktop app with an Access back-end that he wanted to *rewrite*
in VB.Net, and he wanted to know what we thought he should use
for the database back-end.

It has to be something he can take on his laptop, and the
database must reside on the network server, but the server
can't "run" database server software, like SQLServer.

Are you saying that he should get his company to buy a server and
put SQLServer on it? I thought he said in a subsequent post
that that absolutely was not an option.

So his other choices that I see are Access, or SQLServer Express.
I don't see what's wrong with using Access as the back-end. I'm
assuming they would upgrade it to the most current version, not
use Access97.

Please enlighten me on my misdirection, I'm always willing to
learn.

Robin S.
----------------------------------
"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:euNOAgcFHHA.3780@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: MySQL used with VB .NET 1.0
    ... Whatever process you eventually develop for getting the data from an EXCEL spreadsheet on your machine into a database on your ISPs server will be much more complicated than a simple CSV export and FTP. ... I don't think that much people here use MySql as SqlServer Express from Microsoft is freeware. ...
    (microsoft.public.dotnet.languages.vb)