bruce_bruen at mlc.com.au
bruce_bruen at mlc.com.au
Wed Mar 3 15:46:46 CST 2004
Sander,
I dont know where you could find it but the tool you need is called "Table
Code Creator" - tbcc???.mda that used to be around for A97. You will need
to update the code to suit later versions. I think it was a MS download
but it could have been from (memory fails me guys! - where did the list
used to live???)...
Bruce
S D
<accessd667 at yahoo.com> To: Access Developers discussion and problem solving
Sent by: <accessd at databaseadvisors.com>
accessd-bounces at databasea cc:
dvisors.com Subject: RE: [AccessD] Re: Create scripts: CreateTable?
04/03/2004 00:13
Please respond to Access
Developers discussion and
problem solving
thnx for the replies.
History:
I work for company A and I'm stationed at Customer B. I'm hired by Customer
B to develop stuff. Customer B has also hired company C to
implement/migrate changes. Company C has a rule that they ONLY use scripts
to implement/migrate changes that can be run by 'ZERO-KNOWLEDGE-USERS'!!
That is why I need a piece of code to generate CreateTable scripts. I need
this piece of code in Access 2000.
if anybody neesd any more info don't hesitate to ask.
Regards,
Sander
Developer <Developer at ultradnt.com> wrote:
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"
>Subject: RE: [AccessD] Create scripts: CreateTable?
>To: "'Access Developers discussion and problem solving'"
>
>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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com