If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table design Updates
1. I have set up a DB in access 2003 (ac200 format). I have split the db to
front/back end. Installing a new version of the front end is easy. Copy - paste - replace. But for the backend?? Let's say I want to change a table (in the backend). What is the best way to incorporate the change in a working copy (not replica) of the db?? 1) through DAO? 2) through ADO? 3) through data definition query? And how is this done? (hope I'm not asking to much) It would be best for me to work a way to apply changes without 2firure lines of code, cause updates are to be released frequently. 2. I have a set of linked and imported tables in a db. Is it possible to "edit" the link/import properties??? So far each time I want to change something in the link, I delete the table and relink/reimport it. :-( Thanx in advance |
#2
|
|||
|
|||
DAO is the language that Access itself uses behind the scenes, so the best
language for working with Access tables. Some of the properties of the table and fields can only be set through DAO, e.g Format and Caption. ADOX is still to buggy to use IME, and DDL is useless as you cannot even set crucial properties such as AllowZeroLength. If you cannot just go to the site where the back end is in place or open the file directly, one approach is to write an "updater" database, which contains the code to create/delete/modify the fields, indexes, tables, relations, and the properties of each. Re q.2, you can just set the Connect property of the TableDef and RefeshLink to reassign where an attached table gets its data from. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jim Tanis" wrote in message ... 1. I have set up a DB in access 2003 (ac200 format). I have split the db to front/back end. Installing a new version of the front end is easy. Copy - paste - replace. But for the backend?? Let's say I want to change a table (in the backend). What is the best way to incorporate the change in a working copy (not replica) of the db?? 1) through DAO? 2) through ADO? 3) through data definition query? And how is this done? (hope I'm not asking to much) It would be best for me to work a way to apply changes without 2firure lines of code, cause updates are to be released frequently. 2. I have a set of linked and imported tables in a db. Is it possible to "edit" the link/import properties??? So far each time I want to change something in the link, I delete the table and relink/reimport it. :-( Thanx in advance |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Table design | BillT | New Users | 11 | May 25th, 2004 03:41 PM |