Home Forums SQL Server 2008 SQL Server 2008 - General creating forms to enter data RE: creating forms to enter data

  • June 13, 2009 at 11:12 am

    #1009117

    Alvin Ramard (6/13/2009)

    smsam1 (6/13/2009)

    and is there any way to combine access forms with sql?

    I believe you can do that by linking Access to SQL. I haven't done it so I cannot tell you how.

    Hi Alvin

    Usually it is possible to link SQL Server to Access via "adp" Files. But there seems to be a problem with using this feature for SQL Server 2008 (just googled)

    http://blogs.msdn.com/access/archive/2009/01/21/adp-s-and-sql-server-2008.aspx

    Anyway, connecting via ADODB/ADO.NET is possible and Access can be used a client application.

    Flo