Results 1 to 2 of 2
  1. #1
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48

    Access Frontend to SQL Server 2008 Express

    I have an access database that is split into frontend and backend. I am using Access 2010. I used the upsize wizard to link my tables to sql server 2008 express. I have been using the old access frontend and backend on my network sharing it from my desktop to other users. Now that I have upsized the access frontend workes fine on my desktop but when I place the frontend on a networked pc it cant connect to the database.



    I know this can be done but I am missing something, like the proper path.

    When I ran the upsize wizard I selected trusted as apposed to using a user id and password.

    Thank you in advanced.

    Randy

  2. #2
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48
    It was somthing simple. I had to turn on SQL Server Browser in in SQL Configuration Manager.

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

Similar Threads

  1. odbc vista SQL Server 2008 Express Slow
    By BrianM in forum Access
    Replies: 2
    Last Post: 02-07-2011, 11:47 AM
  2. Can't connect Access 2010 to SQL Server 2008 R2
    By LAazsx in forum Import/Export Data
    Replies: 6
    Last Post: 12-10-2010, 08:44 PM
  3. .adp in access 2007 to SQl server 2008
    By NoellaG in forum Access
    Replies: 5
    Last Post: 09-07-2010, 09:18 PM
  4. Access Frontend to Sql server db
    By ksukat in forum Import/Export Data
    Replies: 0
    Last Post: 06-08-2010, 01:35 PM
  5. Convert Access 07 ADO code to SQL Server Express 2008
    By jrdnoland in forum Programming
    Replies: 8
    Last Post: 04-14-2010, 05:57 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