RE: MSDE, Access, SharePoint... I am not sure where to ask this questi



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
>

.



Relevant Pages

  • Re: Sharepoint URL error
    ... When we rename the file in Web UI/Explorer view, Sharepoint object model ... So we should focus on SQL server. ... Please create one new WSS site at the SBS server, ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Sharepoint 2.0
    ... Microsoft CSS Online Newsgroup Support ... <Thread-Topic: Sharepoint 2.0 ... > desktop engine was installed for each instance of the sql server going ...
    (microsoft.public.windows.server.sbs)
  • RE: upgrade sharepoint database to SQLserver - connect error
    ... 2005 database after he move the sharepoint data from MSDE to SQL 2005. ... This newsgroup is primarily for issues involving deployment, configuration, ... | I am trying to move my SharePoint data bases from MSDE to the Sql Server. ...
    (microsoft.public.windows.server.sbs)
  • Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
    ... is if changing the SA password will break the SharePoint. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... ShapePoint database upgraded to SQL Server 2K - change sa ...
    (microsoft.public.windows.server.sbs)
  • RE: My sharepoint intranet "companyweb" does not work
    ... We only have to uninstall the MSDE, and we do not need to ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... When I am uninstalling Sharepoint Services, ...
    (microsoft.public.windows.server.sbs)