Developer
Developer at UltraDNT.com
Tue Mar 2 18:18:25 CST 2004
Robert: I thought that at first, but if that was the case, why not just send the client the empty .mdb? Communication is key ... Lol Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Tuesday, March 02, 2004 1:13 PM To: accessd at databaseadvisors.com Subject: [AccessD] Re: Create scripts: CreateTable? Steve, I believe he was asking about a way of doing it in Access, like the way SQL Server can do it. Robert At 10:59 AM 3/2/2004 -0600, you wrote: >Date: Tue, 2 Mar 2004 10:40:58 -0500 >From: "Developer" <Developer at UltraDNT.com> >Subject: RE: [AccessD] Create scripts: CreateTable? >To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> >Message-ID: <000501c4006c$c5294260$7001a8c0 at COA3> >Content-Type: text/plain; charset="US-ASCII" > >There is absolutely something like it, in MS-SQL 7.0 or 2000 (it's >likely in 6.5 too, I just don't remember). In Enterprise Manager >(2000), you right click on the development database, then "All Tasks", >"Generate SQL Script...". Select any objects you want scripted >(including sp's, views, etc.) and EM will generate a text file you can >run in Query Analyzer on the production server. I use this all the >time to develop one server and deploy on another. If you are quicker >at Access tables, you may want to do your tables there, use the SQL >upsize wizard, then generate the script (watch for data-type conversion >quirks, however, going from Access to SQL with the wizard). Books >Online will give all the details for script generation. > >Hth >Steve -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com