asked on

unlink table in Access 2007

I have a database on a network, the database is split and the tables are on s:/ drive and the front end is on C:/ drive. I need to add somemore onto the Table however this has a active link on it. How do I un link it so I can make updates to the table and then put the links back on again. The front end will not let me go into Design to add more firelds to the form - I'm unsure how to un link and make changes and re put the link back on again.

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erolmurat

ASKER

I'm using Access 2007 and it still will not let me un link, I have been in Link Manager but still nothing seems to be working for me as I'm getting the following message

Table "WPSINDEX" is a linked table who design can't be modified. If you want to add or remove fields or change their properties or data types, you must do so in the source database.

Open in new window

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erolmurat

ASKER

it would be good if I could do this from the front end as I cannot get into the back end of it to make any changes. It maybe on a drive where I have not got permission, i have to check with IT over this issue. It seems so easy to make changes but I cannot get into it to make them nor can I un link the database to do any changes. I have read the book and followed the steps even going into Link Manager screek where it show me a tick box, but this does nothing for me, I still cannot get into it to make any changes.

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erolmurat

ASKER

I will have to check with the IT to find out, it seems strange to me that I cannot do any changes to it, after I have followed everybody who has contact me. Thank you for getting back to me and trying to help me out. Regards

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erolmurat

ASKER

DatabaseMX
Thank you for this information you have sent out to me, I will try and see if I have the permissions as I did not write this database and not sure I can make changes to it as its is on a Drive on our network. I will check with the IT deptment to see if I can make changes, Thank you again

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

erolmurat

ASKER

ill give it a go and let you know, thanks again for your help