+ Reply to Thread
Results 1 to 3 of 3

Thread: C#.net form with microsof access 2003 db w user level security

  1. #1
    Barn Regular arloguth is an unknown quantity at this point arloguth's Avatar
    Join Date
    Apr 2009
    Posts
    61
    Rep Power
    3

    C#.net form with microsof access 2003 db w user level security

    Hello - I have access 2003 database with user level security on it.
    should I be able to code a connection to allow me to access the database with a user id and password?
    I have a statement now:
    I mean connect with a C#.net form
    Code:
    public void DataConnection()
    {
      con = new OLEDbconnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=./database.mdb"); con.Open();
    }
    
    ***i hand typed in if any mistakes- but it works-
    now I have looked at connection strings adding user id and password after data source- but I cannot find any that are similar to mine-
    specifically: source=./database.mdb"
    all connection string have backslash to C: drive- can i change my code- or add user Id and password to it?
    thank you
    Last edited by micky; January 23rd, 2010 at 02:24 AM. Reason: Added code tags, please do so in future

  2. #2
    Administrator richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich is a splendid one to behold richyrich's Avatar
    Join Date
    Mar 2008
    Location
    Somewhere only we know...
    Posts
    3,207
    Blog Entries
    14
    Real Name
    Rich
    Rep Power
    14

    Have a look here

    Hope that helps.

  3. #3
    Barn Regular arloguth is an unknown quantity at this point arloguth's Avatar
    Join Date
    Apr 2009
    Posts
    61
    Rep Power
    3

    thank you - i guess I will just try replacing my string with these strings- I am puzzled how my connection string with ./ database.mdb even works- I am not sure also whether using user level security and connecting from c# form is considered standard security or workgroup

+ Reply to Thread

Similar Threads

  1. how to use insert command on c# form to access database
    By arloguth in forum .NET Development
    Replies: 2
    Last Post: January 11th, 2010, 06:46 AM
  2. Access user security
    By Colper in forum Microsoft Access
    Replies: 7
    Last Post: January 6th, 2010, 08:38 AM
  3. User-level security strategy
    By PPP in forum Microsoft Access
    Replies: 5
    Last Post: February 8th, 2009, 10:14 PM
  4. Excel 2003 formula time issue
    By Rebelle in forum Microsoft Office
    Replies: 1
    Last Post: January 16th, 2009, 02:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO