Adding a new field to a table

[stealth3]

Hi

This will be a very straightforward question for someone. I have an established database and need to add a new field (hyperlink) to my main table. I've just tried and the new field isn't appearing. I intend to add this field to my main table and reports.

I realise that I will need to also modify my queries and reports.

Is it to late to add a new field to my table.

thank you

stealth

 

[LittleSmudge]

No - its not too late.

However, think carefully before adding 'hypertext' fields.
They are a one way street leading to a dead end. If you ever need to upgrade the db to something more powerful you won't find a hypertext data type in SQL Server or MySQL etc.


As for your "not appearing" comment :-

That 'usually' occures when you have the database split FE/BE and you make a change in the BE schema - it doesn't appear in the FE until you refresh the table links.
From the Tools Menu select Database Options and then click on Table Links. In the dialog click on Select All and then click the Okay button.

NOW you should see your changes in the FE.



'ope-that-'elps.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[stealth3]

Hi LittleSmudge

Ok I've added the new field and then had to give the table a new name, and then updated the table links because yes my db is split.

I believe I have to now re-establish the relationships but as its sometime since I created this db and its my first real on, I can't seem to get rid of the old to establish the new to the new table, and enforce referential integrity from the main table to another table.

I presume once I've worked that out, I may need to redo my queries and reports. Would that be correct?

Hope gratefully accepted.

cheers

Stealth

 

[LittleSmudge]

Yes you will.


If you maske sure the FE is closed and then open the BE you can make changes to the BE schema without being affected by anything in the FE.

Delete old links that are no longer needed by clicking on the link and hitting the delete key ( gently ! ).

If your new links are prevented because of referential integrity issues you might need to add the appropriate records in to the ONE side table or edit the reference in the MANY side table.

Close the BE, open the FE and refresh links.

THEN open up each query, form, report and make sure they work with the new schema - or adject as necessary.



'ope-that-'elps.


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[stealth3]

Hi LittleSmudge

It's still not working. This time I started from scratch. With the FE closed, I opened the BE and added the new hypertext field to the table. I then checked that the relationships revealed the new field in the appropriate table. Check check. I then closed the BE and opened the FE and relinked all the tables.

However, the new field and relationships weren't updated.

Is there something that I am obviously doing wrong?

cheers

Stealth

 

[LittleSmudge]

I know this one might sound daft - but sometimes .. ..


Are you totally sure that you have updated the BE and are linking to THAT BackEnd rather than an old copy of the BE that might be loitering somewhere ?


G.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[stealth3]

Hi LittleSmudge

I have the answer now. I thought the changes on the BE should be reflected in the FE, but they aren't. So your advice was correct. My database was split after the tables were constructed, and I wasn't aware that the tables in the front-end shouldn't necessarily reflect the BE.

I only discovered this today.

cheers and thanks for posting a reply and persevering.

Stealth