Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 27th, 2004, 09:12 AM
Registered User
 
Join Date: Jul 2004
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default convert macro in MSAccess to Sql Server

Hi,
  Any one help me that i have a macros which generates reports in MSAccess taht i have to run in Sql Server.And one more thing i want to convert all the "queries" in MSAccess to Sql Server.
 
Old July 27th, 2004, 12:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

SQL Server doesn't use macros (although the new SQL Server 2005 will support VB.NET code). You need to move them over to a VB program or vbscript.

SQL Server uses stored procedures, so copy them there. Although stored procedures have a different syntax for declaring the procedure and parameters.

Brian





Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Report from SQL server to Oracle database zahidhussain Pro VB Databases 1 October 10th, 2007 03:11 PM
Convert Crystal reports from access to sql server sunbagga Pro VB Databases 9 July 16th, 2007 05:57 AM
CONVERT VISUAL FOXPRO TABLES TO SQL SERVER anantha krishna ADO.NET 1 June 25th, 2007 12:30 PM
how to convert ms access db to sql server method SQL Server 2000 1 March 11th, 2005 11:44 PM
howto convert sybase to sql server db qwjunk SQL Server DTS 0 August 14th, 2004 11:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.