Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Location
    Toronto, Ontario
    Posts
    11

    Unanswered: convert or transfer access mdb file to sql server

    what's the easiest way to do this. i have 5 tables within the mdb file
    i tried the "easiest way" shown in a website but it does not work.
    the way i did it was on access(2007) > database tools tab > sql server button
    it gave me an error when it ask for an login ID
    i do not have any password/id..


    please help
    thanks
    Last edited by mackenzo; 10-11-07 at 04:07.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you do not have a logon to the SQL server then you do not have the permissions to do anything to it - simple eh?
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    He could be set up with windows authentication or mixed-mode security, which would not require a password.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Oct 2007
    Location
    Toronto, Ontario
    Posts
    11
    it's microsoft sql server management
    when i open it.
    it will show a box to connect.

    server type is Database Engine
    Server name is Mackenzo
    auth. is windows auth

    yes i have a username without a password which is mackenzo/mackenzie

    what can i do??

Posting Permissions

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