No, I don't believe you can create SP's in Access 2000, the DTC package would be created and run on the SQL Server side from one ODBC source to another ODBC source, or in your case, one Access to one SQL.
HTH Bill -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 4:07 PM To: SQL Subject: Re: Access to SQL Server ok, can i create Stored Procedures in Access 2000? what are my limitations? Bill Killillay wrote: > > Very, you can create a DTC package to do it, there are wizards for it. It's > pretty much point and click if you have Enterprise manager installed, a bit > more complicated if you don't... > > -----Original Message----- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 3:51 PM > To: SQL > Subject: Access to SQL Server > > How easy is it to migrate an Access database to SQL Server 7 or 2000? I > don't have one to migrate, just asking. > > James > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
