Results 1 to 15 of 15

Need help importing to SQL

  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    Need help importing to SQL

    Hi All

    Need some help and advice, I have built a database in access 2010 in windows seven, been able to split the front end using the access wizards and got the users using it like a dream (around 12 users).

    I would now like to move the back end into SQL which as I understand will give me a more stable and up sizeable database.

    My question is what SQL software do I need (Free ideally) as I am no expect and am running windows 7, and any help or advice would be great.

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,205
    There is a free version of SQL Server:

    http://www.microsoft.com/sqlserver/e...s/express.aspx
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,205
    Meant to include this comprehensive guide by my friend Leigh:

    http://www.utteraccess.com/forum/Beg...-t1732935.html
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  4. #4
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Thanks will read over it and play with it on Monday

  5. #5
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    I have down loaded the software and it seems very good, but I can't get it to connect to the server(which is my pc), from what I have seen looking up the error code it seems I need to set an admin account up any idea how I do this as looking over the software the rest seems not bad

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,205
    I've never used the express version. In the full version, the user "sa" will be created when you install, and that is the admin account. Did it ask you about a password for sa?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  7. #7
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Ya, but I let the thing us the windows trusted password on my network so I think the thing has not set up the sa account, so my thinking is to uninstall it and do it again

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,205
    We may want to rope in somebody who has used the express version. In the full version, in SQL Server Management Studio (the main interface) you can set up users in the Security area. In the properties of the instance is the option for "Windows Authentication mode" or "SQL Server and Windows Authentication mode". It sounds like you've got the former, I have the latter.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  9. #9
    RayMilhon is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    726
    In SQL Server Management Studio under Security there should be an entry for your windows login something like domainname/username. If you right click on that and open the properties You will see an icon for server roles click on that you will see the list of server roles and which ones that user is assigned to.

  10. #10
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Think I got that sorted but I keep getting a error, I will screen print it and post it in the morning

  11. #11
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Hi I have loaded the screen shot for you to look at.

    Thanks

    Hads

    Click image for larger version. 

Name:	SQL Screen Shot.jpg 
Views:	20 
Size:	79.9 KB 
ID:	6924

  12. #12
    satishchandrat is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Mar 2012
    Posts
    2

  13. #13
    RayMilhon is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    726
    On the SQL Server Login Screen try changing SQL Server Authentication to Windows Authentication

  14. #14
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Tried that and still no joy, I will read over the links above and see if that helps

  15. #15
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Some good ideas for me on the links will have a try in the morning as away from the office at the mo

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing Table
    By TPH in forum Import/Export Data
    Replies: 3
    Last Post: 11-10-2011, 02:08 PM
  2. Help with Importing
    By Souperbc in forum Programming
    Replies: 2
    Last Post: 04-13-2011, 11:45 AM
  3. Example Importing routine
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-23-2010, 11:35 PM
  4. Importing vs. Linking
    By nickanderson in forum Database Design
    Replies: 2
    Last Post: 08-13-2009, 03:35 AM
  5. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 07:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums