SQL Connectivity

From: Daud (Daud_at_discussions.microsoft.com)
Date: 01/03/05


Date: Mon, 3 Jan 2005 00:29:02 -0800

I have two questions:
1> I developed my database in MS-Access then install SQL Server 2000 and
import Access database into it. All the tables were transfered correctly but
queries that i developed in Access were also imported in the Tables list of
SQL. How can I import Access queries in SQL view.

2> How can I make SQL connection with VB ADODB and open a recordset.

-- 
Daud Akbar


Relevant Pages

  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Anyone tell me whats wrong with this SQL statement?
    ... That sounds like an SQL error telling you that you are not accounting ... am also working on a Photo Album which uses an Access ... > PS - just to cover every area, the data types in Access database are as ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Calling SQL Stored Proc from Access (with Parameters)
    ... You can put the code in the after update of your "form field". ... property of the pass-through query. ... I have an access database and a SQL database. ...
    (microsoft.public.access.queries)
  • Re: VB or?
    ... using compact SQL for the desktop, or the free version of SQL (SQL ... as officially VB6 is no longer a supported product. ... I did some VB programming about 12 years ago, got as far as VB 4.0. ... again with VB and having problems opening an Access database. ...
    (microsoft.public.vb.general.discussion)