473,322 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

MSDE or Jet for my application?

We are developing a fairly simple database to be deployed on the
internet. It consists of an artist's works (approx 2600 of them) based
on references to books from which his ideas came. Relative fields will
be fairly few, data related to the books, a pic of his initial sketch,
and a pic of the final painting. Searches will be provided and probably
a feedback form. The plan is for this database to be used by students
when studying myths of the world (and other interested parties, of course).

i am in the beginning stages using Access 2002 and Jet. We just
purchased and installed Visual Studio .net (academic version), but i
haven't actually used it yet. The install mentions MSDE. However, even
after reading about MSDE on MS's site, i still can't determine my course.

For our web application, what should i use? MSDE or Jet? ADO or is DAO
(i am familiar with DAO but not ADO)?

i need a plan, a course of action to follow for this, as it is new
ground for me. i'm not asking for details, just general direction. i'm
basically self-taught and there is no one here who knows any more about
this.

Any guidance is appreciated.

--e

Jul 21 '05 #1
4 1259
As far as which to use, go with MSDE. Access is nothing but headaches and
isn't a real client server DB. MSDE gives you all the perks of real SQL
Server with the main difference being the 2gb limit, which is the same as
access. YOu'll have much better security, performance, backup/recovery
functionality etc.

As far as accessing the data, if you are using VS.NET, highly recommend
ADO.NET.
"elizabeth baker" <ba********@yahoo.com> wrote in message
news:40**************@yahoo.com...
We are developing a fairly simple database to be deployed on the
internet. It consists of an artist's works (approx 2600 of them) based
on references to books from which his ideas came. Relative fields will
be fairly few, data related to the books, a pic of his initial sketch,
and a pic of the final painting. Searches will be provided and probably
a feedback form. The plan is for this database to be used by students
when studying myths of the world (and other interested parties, of course).
i am in the beginning stages using Access 2002 and Jet. We just
purchased and installed Visual Studio .net (academic version), but i
haven't actually used it yet. The install mentions MSDE. However, even
after reading about MSDE on MS's site, i still can't determine my course.

For our web application, what should i use? MSDE or Jet? ADO or is DAO
(i am familiar with DAO but not ADO)?

i need a plan, a course of action to follow for this, as it is new
ground for me. i'm not asking for details, just general direction. i'm
basically self-taught and there is no one here who knows any more about
this.

Any guidance is appreciated.

--e

Jul 21 '05 #2

Thanks, William. i ordered SQL Server 2000 Developer Edition.

How will this affect things? How does everything interrelate?

i'm used to DAO, so i have to learn ADO and about putting the db on the
web. i'd really like to get started out on the right path.

Thanks for your help and any advice you'd like to give.
--e
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #3
William Ryan eMVP wrote:
As far as which to use, go with MSDE. Access is nothing but headaches and
isn't a real client server DB. MSDE gives you all the perks of real SQL
Server with the main difference being the 2gb limit, which is the same as
access. YOu'll have much better security, performance, backup/recovery
functionality etc.
I second that. From experience with an Access based site using classic Asp,
you can expect to be rebooting your server once a week using Access.

I don't think the ODBC drivers are good enough for the multiple connections
and threads that a typical website will open up on a database.

As far as connectivity, if you use SQL Server, you should use the SQLClient
libraries in .NET. They are optimized for SQL Server.


As far as accessing the data, if you are using VS.NET, highly recommend
ADO.NET.
"elizabeth baker" <ba********@yahoo.com> wrote in message
news:40**************@yahoo.com...
We are developing a fairly simple database to be deployed on the
internet. It consists of an artist's works (approx 2600 of them) based
on references to books from which his ideas came. Relative fields will
be fairly few, data related to the books, a pic of his initial sketch,
and a pic of the final painting. Searches will be provided and probably
a feedback form. The plan is for this database to be used by students
when studying myths of the world (and other interested parties, of

course).

i am in the beginning stages using Access 2002 and Jet. We just
purchased and installed Visual Studio .net (academic version), but i
haven't actually used it yet. The install mentions MSDE. However, even
after reading about MSDE on MS's site, i still can't determine my course.

For our web application, what should i use? MSDE or Jet? ADO or is DAO
(i am familiar with DAO but not ADO)?

i need a plan, a course of action to follow for this, as it is new
ground for me. i'm not asking for details, just general direction. i'm
basically self-taught and there is no one here who knows any more about
this.

Any guidance is appreciated.

--e


--
W '04 <:> Open
Jul 21 '05 #4

"Elizabeth Baker" <ba********@yahoo.com> wrote in message
news:uD*************@TK2MSFTNGP09.phx.gbl...

Thanks, William. i ordered SQL Server 2000 Developer Edition.
Good choice.
How will this affect things? How does everything interrelate? You can use the Client Tools (Query Analyzer and Enterprise manager to name
two) to connect to any sql server (which includes MSDE) on your network or
that you can see.
i'm used to DAO, so i have to learn ADO and about putting the db on the
web. i'd really like to get started out on the right path.
ADO.NET is soooo much cooler than either of those. There's a really active
ADO.NET NG and ADO.NET supports a direct Sql library SqlClient
the NG is microsoft.public.dotnet.framework.adonet

Thanks for your help and any advice you'd like to give.
--e
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
1
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve...
2
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
41
by: NB | last post by:
Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2...
3
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together...
3
by: NWx | last post by:
Hi, I write an ASP,NET application who uses SQL Server (MSDE) as Back-end I'm an experienced developer, but haven't used SQL server before and I need some help. Since I don't have full SQL...
3
by: David Lozzi | last post by:
Howdy! I have a question for all you smarties... I have a ASP.Net application running on Windows 2000 Professional and MSDE, same box. While running the application, users will randomly receive...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.