|
|
|
MS Access Scripting
posted on 30/6/2003I need a bit of Windows scripting written that will essentially convert an MS SQL Server 2000 database to an MS Access DB.
The first few lines of the script will set the SQL Server database name and hostname and should be easy to modify. The system will be ran from a Windows account that has access rights to the database.
The system will perform identically to someone manually doing the following:
-Create an ADP file connecting to the database in the same folder as the script.
-Create an MDB file called data.mdb in the same folder as the script.
-Close both, then open both (to get round a bug in Access)
-Drag the tables, one by one, from adp to mdb.
-In each table, open in design mode and set the 1st field as the primary key.
-For every text and memo field in every table, set "Allow Zero Length" to "Yes"
Ideally, this would be done in JScript, but VBScript solutions will be considered.
We are no longer accepting applications for this project.