Results 1 to 12 of 12

Thread: USING SQL Server back End for MS ACCESS Database Front End

  1. #1
    Join Date
    Aug 2009
    Posts
    50

    USING SQL Server back End for MS ACCESS Database Front End

    Gents,

    i Have data base (MS ACCESS) that will work in home server with more than 250 Users the Size is 84,816 Kb but this will increase to achieve 1 GB i did not finish the project yet

    to Avoid data Rupture I Want to use SQL Server for Back end will reside into the server and front End linked to each computer what kind of SQL server Product can I Use and how much does Cost to buy is there a free down load or a trial please i need your help
    Last edited by FMKA; 10-19-2009 at 12:29 PM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can download SQL Server Express from Microsoft, it is free.

  3. #3
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by skhanal View Post
    You can download SQL Server Express from Microsoft, it is free.
    I did it but i do not find the functions have a look what i have
    Attached Files Attached Files

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.

    You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.

  5. #5
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by skhanal View Post
    What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.

    You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.

    Thanks, Bro but is not Available

  6. #6
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Functions can be Created within the Application, of Course ...

    You can build your functions in MSSQL Server.

    Did you examine the upsizing tools?

    Bill

  7. #7
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by Island1 View Post
    You can build your functions in MSSQL Server.

    Did you examine the upsizing tools?

    Bill

    Bill

    I selected sql management studio. what do you say ?

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    Sqlexpress doesn't have data imput tool, should use access' upsizing tool like Bill said.

  9. #9
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by rmiao View Post
    Sqlexpress doesn't have data imput tool, should use access' upsizing tool like Bill said.

    What about SQL Server Import Export Wizard is not good

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Not available on express I believe.

  11. #11
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by rmiao View Post
    Not available on express I believe.
    is available I downloaded MS SQL Express 2008 the tool is there too that i am using

    thanks

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    What's the issue then? You can use vb script in access to query sql tables.

Posting Permissions

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