Concerning Sql or Access...

If a sql server is available, it is almost always preferable to use Sql, if
one isn't available, I certainly wouldn't set up an entire server just for
this application.

I agree on the using access for development then changing it to sql.  If you
use classes and ado, all you need to change is the connection string (and
move your tables to sql, of course).

Thanks.

Chris Ellegood, ATP,  xxx-xxx-xxxx

--
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the
original message.
----- Original Message -----
From: "Tom Malone" <tmalone@n...>
To: "professional vb" <pro_vb@p...>
Sent: Tuesday, April 17, 2001 7:52 AM
Subject: [pro_vb] Re: [Re: Network Application in VB]


> Hello Prashant,
>
> I hope that others will join in with advice as I'm still new to
development.
>
> You could use Access, but you're already close to the suggested limits for
> users, and will be adding 300 + records per day, so I would use SQL Server
> if it were my decision.  I'd use Access to design and develop the tables,
> use MSDE on your machine for testing, and then SQL Server for the
delivery.
> If you design in Access, use it just for the tables, and keep all code and
> queries in your application. You probably will want to use classes and
> objects to process your data, and compile these as one or more DLLs to
make
> it simpler to maintain your application. Try to keep your user interface
as
> small as you can. I'd also use NT security. I'm going to email you some
> articles that I've found helpful.
>
> Tom
> ----- Original Message -----
> From: "Prashant Shinde" <pds_shinde@u...>
> To: "professional vb" <pro_vb@p...>
> Sent: Tuesday, April 17, 2001 1:49 AM
> Subject: [pro_vb] Re: [Re: Network Application in VB]
>
>
> Hi Tom,
> There approx 10 users. Database is MS Acces or SQL, Which will be better?
> All 10 will have write privileges. No heavy reporting. Database size would
> be
> 1000 records per month.
> This is the more information as you needed. Please tell me how my design
> should be? Which database I should use? Acces or SQL?
>
> Thanks, waiting for the solution.
> Prashant Shinde
>
> "Tom Malone" <tmalone@n...> wrote:
> Hello Prashant Shinde,
>
> Additional details regarding the users, and the database would be helpful.
> How many total users? How many may have write privileges? Will there be
> heavy reporting? What is the size of the database? etc. There are a lot of
> knowledgeable folks, but you need to provide more information.
>
> Tom Malone
>
> ----- Original Message -----
> From: "Prashant Shinde" <pds_shinde@u...>
> To: "professional vb" <pro_vb@p...>
> Sent: Monday, April 16, 2001 1:55 AM
> Subject: [pro_vb] Network Application in VB
>
>
> Hi All,
> I have developed a stand alone Software in VB. I want to convert the same
to
> the network environment. Network is windows NT and database is MS Access.
> Will
> it be possible for me to use Access for networking version. Or I should
use
> some other database. Please suggest me. And what are the things to be
taken
> care off in my code, when I am converting an application to networking
> application. I want a detailed note on this. Please help me.
> Regards to all
> Prashant Shinde
>
>
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
>
>
>
>
>
>