Results 1 to 2 of 2
  1. #1
    Mark Pomeroy is offline Novice
    Windows Vista Access 2003
    Join Date
    Apr 2009
    Posts
    1

    SQL server

    I am new to using Access and gather that to make a database more usable it needs to be attached to an SQL server. I have downloaded SQL 2008 express free edition and installed it. I cannot link it to my database, or make a project that links to it. I get a dialog box comes up when I go to connections tab. I do not know and cannot find in help what I am supposed to write in all of the boxes.

    Please can any one help?

    Thanks in advance.

    Mark

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    When starting with Access, I would recommend starting with one of the free templates and internal tables. As you get comfortable with the system then split the db into FrontEnd and BackEnd using linked tables. I'm no expert on SQL Server but it seems that you need to use SQL tools to get the system started, but I could be wrong. An Access only system is quite robust and reliable done properly.

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

Similar Threads

  1. Import from SQl server
    By NaatuGaadu in forum Import/Export Data
    Replies: 2
    Last Post: 06-18-2009, 09:56 AM
  2. Access / SQl Server Advantage.
    By caljohn527 in forum Queries
    Replies: 0
    Last Post: 01-24-2009, 06:40 PM
  3. Replies: 0
    Last Post: 11-04-2006, 02:31 AM
  4. sql server active x - HELP!!!!!!!!!!!!!!
    By Valeda in forum Access
    Replies: 0
    Last Post: 06-27-2006, 01:02 PM
  5. Unique Record Identifier for MS SQL Server Tables
    By MGSP in forum Import/Export Data
    Replies: 2
    Last Post: 01-29-2006, 03:00 PM

Posting Permissions

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