Splitting database

[zbird]

Hi,

I would like to split my database but as it has been suggested I need to make the tables almost perfectly finalized before I do that. I have a lot of 'drop-down' tables and the content of those needs to be extended sometimes. Would I be able to make these changes if the tables are in the back end? Or shall I just get rid off the Drop-down tables and sort out my drop down fields on the form in another way?

Many thanks

 

[Galaxiom]

Changes can be made any time. Simply open the back end and do it there. The changes appear in the linked tables automatically. However you may need to edit the RecordSource of Forms and Reports and the RowSource of Listboxes and Combos if they are queries.

New tables can be added the same way but there is another technique that avoids opening the back end at all (unless you need to edit Relationships).

Create the new table in the FE, export it to the BE (right click on table in object list), delete it from the FE and link to the table in the BE.

 

[rodmc]

by drop down tables do you mean lookup's via a combo box?

If so, you could make the source of the combo box a select query (using distinct so that you dont have repeating values) rather than an actual table.

Theres load of examples on the forum, try a search

 

[zbird]

Yes, they are lookups via Combo box. I will look into how I can change them, before I split the database. I would like to avoid that someone else adding an extra word to the list in the combo box while they are adding new records, as it is very likely that they do a spelling mistake.
Many thanks for your help.

 

[ozzi]

Yes, they are lookups via Combo box. I will look into how I can change them, before I split the database. I would like to avoid that someone else adding an extra word to the list in the combo box while they are adding new records, as it is very likely that they do a spelling mistake.
Many thanks for your help.

Hi Zbird,
Someone correct me if i am wrong, but if the combo box control source property is left blank then there is no where for the new data to go, ie. no new record in lookup table.

edit> also set the limit to list property to yes.<edit

then if you want to edit the lookup table just create a data entry form in an administrator only FE.

ozzi