It is much easier to export than that. You can go to tools.......database utilities.....upsizing wizard. It creates all relationships needed etc and creates an access adp(project file) which is basically an Enterprise manager interface with more of an access look and feel. It has limitations but it is easier to work in than the native SQL tools.
-----Original Message----- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:22 PM To: SQL Subject: RE: Access to SQL Server 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
