RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
- From: SailFL <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 04:24:01 -0800
Nathan,
I appreciate your response but I am a bit confussed.
What is the difference between MSDE and WMSDE?
I has been announced that MSDE is being replaced by SQL Server 2005 Express
and MSDE will not longer be supported after 2007.
Also I found a document that talks about Migrating from WMSDE to SQL Server
but in reality what you are using with SharePoint is SQL Server 2000 Desktop
Engine.
It is my understanding with the release of SQL Server 2005, Small Business
Server 2003 currently uses SQL Server 2000 but in the next releases Premium
will use SQL Server 2005 and standard will use SQL Server Express.
So in reality, isn't SQL Server Express replacing MSDE and WMSDE?
So I can use Access to have database files on a share pointe site. Will
that Access also than be able to connect to SQL express and can it do it now?
You can see I am confussed. There are some many products it is hard to keep
up and to be able to tell a client which to use.
Thanks
--
SailFL
""Nathan Liu [MSFT]"" wrote:
> Hello SailFL,
>
> Thank you for posting in the SBS newsgroup.
>
> >> 1) While we be able to access these databases using SharePoint? >> 2)
> What does access use? Is it compatable to MSDE - SQL Server Express?
>
> Please kindly note the SharePoint is using WMSDE instance on SBS 2003
> Standard Server, it is using SQL instance on SBS 2003 Premium SP1 Server if
> we upgrade it to SQL Server 2000.
>
> We can upload an Access database (.MDB) into WSS (SharePoint). It is
> possible to directly upload the file into WSS document library by removing
> the file type block. The steps are as below:
>
> a. Go to Adminsitrative Tools->SharePoint Central Administration.
> b. Under "Security Configuration", click "Manage blocked file types"
> c. Remove "mdb" from the file extension list.
> d. Click OK.
>
>
> I appreciate your time and cooperation. If anything is unclear, please feel
> free to let me know. I am looking forward to hearing from you.
>
> Best regards,
>
> Nathan Liu (MSFT)
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
> ======================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> >Thread-Topic: MSDE, Access, SharePoint... I am not sure where to ask this
> questi
> >thread-index: AcX/OgIUVzgubT+RSGywg6TaqcZXDA==
> >X-WBNR-Posting-Host: 71.52.219.10
> >From: =?Utf-8?B?U2FpbEZM?= <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx>
> >Subject: MSDE, Access, SharePoint... I am not sure where to ask this questi
> >Date: Mon, 12 Dec 2005 08:35:05 -0800
> >Lines: 15
> >Message-ID: <92708308-690C-4F4F-8057-2AF073017A18@xxxxxxxxxxxxx>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.windows.server.sbs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:229557
> >X-Tomcat-NG: microsoft.public.windows.server.sbs
> >
> >As I mentioned, I am not sure where to ask this question because I don't
> >completely understand the relationship.
> >
> >We are developing a number of databases in Access. We don't see the need
> to
> >move to SQL Server 2005. We are moving to SBS soon. I understand that
> MSDE
> >is being replaced by SQL 2005 Express.
> >
> >1) While we be able to access these databases using SharePoint?
> >2) What does access use? Is it compatable to MSDE - SQL Server Express?
> >
> >Point me in the right direction, Pleases.
> >Thanks
> >
> >--
> >SailFL
> >
>
>
.
- Follow-Ups:
- RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
- From: "Nathan Liu [MSFT]"
- RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
- References:
- RE: MSDE, Access, SharePoint... I am not sure where to ask this questi
- From: "Nathan Liu [MSFT]"
- RE: MSDE, Access, SharePoint... I am not sure where to ask this questi
- Prev by Date: Re: IBM Director
- Next by Date: Re: Clients cannot locate SBS for DHCP or DNS
- Previous by thread: RE: MSDE, Access, SharePoint... I am not sure where to ask this questi
- Next by thread: RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
- Index(es):
Relevant Pages
|
