Access Connection String

Hot Topic

Thread.BeginThreadAffinity required before WaitHandle calls?
Mutex could not be created
Process.start not behaving as expected
DWORDS and Sockets
uploading images onto an SQL database through ASP page
problem with enum
WebClient.Download gives an error:- "Forbidden 403" with .NET 2.0
Can 1.1 and 2.0 framework coexist on the same box?
removing protection from vba code
A Question on GC

.NET Development

Endless waiting in use of System.Net.Sockets.Socket.Receive()
Loading a Type with the Type's Fully Qualified Name
How to read the following xml file?
VS 2005 & Access DB problem
Setting the debug symbol path to an internet source
Differences in VB and C# syntax Guide
Conditional Merging in DataTables
Got 'SocketException' in Async Connection
X has encountered an error and needs to close...
Filtering data

Access Connection String

I have developed an access database on my local machine that I wish now to host on network server.


Local Address:
Friend ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:\DB1.mdb;User ID=admin;Password="

The server name is E287868

How now do I configure the Data Source to  represent the new full path to the database   Do I need to create a share folder on the server and place the Access database in it

Thanks,
Fred Herring


 


Answer this question

Access Connection String

  • kavijay


    You'll definitely need to place the database on a network share.

    If you want the users to be able to modify the contents of the database, you'll need to give those users permissions to create and modify files on the share.

    I hope this information proves helpful.

    David Sceppa
    ADO.NET Program Manager
    Microsoft

  • LeylaBora

    David is right.  Place the Access database on a network share and give users permissions to the folder.  But I would be very careful not to give them Full Control permissions as this is very dangerous from a security point-of-view.  Consult your systems administrator regarding assigning permissions(NTFS and Shared Folder permissions) on the shared folder.

  • Access Connection String
Answer this question