Developer How-To

To create a new AWS instance

• log into AWS
• Under Images click AMIs
• select Contensive41 --> right click on Contensive41 and launch a new instance
• select general purpose t2.micro --> click next:
• review launch and click next:
• add storage change the size of root to 100gb
• add new volume under device change to xvdf change size to 400gb
• click next
• name the key Use new sever Name
• click next
• In configure security setting select an existing security group
• select production server, windows
• review
• launch

Assign an elastic Ip

• in ec2 select elastic ip
• under actions lallocate new address
• for a windows server select VPC in the EIP dropdown
• under actions associate the IP with the new instance created

Repairing a Microsoft Access Db

Use these steps to compact or repair an Access Db.

1. Open the Upgrade folder.
2. Shut down Contensive.
3. Turn off auto start in application manager.
4. Open the folder interpub/db and make a copy of the target database.
5. Open odbc32 --> select the system dsn tab --> push ADD --> select the appropriate driver (ms-access driver)--> push finish -->
6. select repair and find the newly copied db --> click ok --> close odbc32
7. Go back into Interpub and copy the newly repaired db and rename it.
8. now go back into odbc32 select the system DSN--> select add to create a new dsn --> select the ms access driver --> select the new db --> give it a new name (typically Incremented) --> click OK
9. open app manager and rename the connection string
10. restart contensive