Advice MSDE/ACCESS

I wrote an app that uses MSDE. IT is VB.NET, and there are only 10 users
tops.
To make an MSDE installation and get the database working requires me, which
makes it not really a commercially distributable product.
Would I be better just using an MDB file? Seems like MSDE is really nice
and basically SQL but I need something that installs easy--i.e. my users can
install. I know I can easily install an MDB file.
Would the MDB file be sufficient for 10-20 users tops?
thanks,
Shane
On Sat, 12 Jun 2004 02:36:37 -0500, SStory
<TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote:

> Would the MDB file be sufficient for 10-20 users tops?
That depends on the complexity of your queries and the level of your
requirements. If you're only doing some SELECT statements and occasional
updates/inserts, an .mdb file is certainly enough. You could run into
troubles with locking mechanisms in MS Access though, so take care.
Installing MSDE is not a big deal, you just have to care for populating
the database yourself (ie: from your application) to make it easier for
your users.
Using SECURITYMODE and DBPWD(?) as setup parameters can even set up a
version of MSDE that runs similar to MSDE 1.0 (speaking of access to it)
Stefan
Give a man fire and he is warm for a day.
Set him on fire and he is warm for the rest of his life.

ADOMD and XML/A

Hi,

I got the following from a Microsoft Technet Chat - "The advantage of XML/A over ADOMD is the thin client. ADOMD requires PTS and ADOMD installed on all client machines while XML/A would only require an XML parser."

Now say, I develop an asp.net application which would use adomd.net to get cube data, and will also run mdx queries. I host the asp.net page on my server, and allow it to be accessed by remote users. My server itself contains all the necessary cubes, and other components like adomd.net, etc.

My question is, if you want to run the asp.net page hosted on my server, (via HTTP), will it be necessary for you to install the adomd.net components on your local (remote) machine also?

(Actually I dont like coding with XML/A and find execution of mdx queries via Adomd.Net much easier! Any links showing xml/a coding for MDX in VB.Net from scratch?)

Thanx and Regards!

As in typical ASP.NET apps, you only need data access components on the ASP.NET server - maybe the 2nd figure on this page will help you:

http://msdn2.microsoft.com/en-us/library/ms174518.aspx

>>

SQL Server 2005 Books Online

Client Architecture (SSAS)

...

Analysis Services provides broad middle tier support for Web services. ASP applications are supported by OLE DB for OLAP and ADO MD, ASP.NET applications are supported by ADOMD.NET. The middle tier, illustrated in the following figure..

>>