Changing tables in a split database

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

I have split my database and I was told that it is not a problem to make
edits on my home computer. All I need to do is bring the front end and back
end home, put them in a folder and run the link table manager to relink the
tables. So I did that and now I want to change a field in the table and I
get this message:

Table 'tblTableName' is a linked table whose 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.


Now if I must do this in the source database - how can I do that since the
source database is in the office - and not at home. The question that I'm
trying to resolve is how to update table definitions and do development on my
home system. Thanks for any help on this.
 
You are apparently attempting to modify a table definition in the BackEnd
database but doing so from the FrontEnd. You cannot do that. Open the
BackEnd database instead of the FrontEnd and make your modifications from
within the BackEnd database.

Of course, you will have to make the same modification in the BackEnd
database in the office prior to installing any update to the FrontEnd.

Jack Cannon
 
Thanks Jack. That worked.

Jack Cannon said:
You are apparently attempting to modify a table definition in the BackEnd
database but doing so from the FrontEnd. You cannot do that. Open the
BackEnd database instead of the FrontEnd and make your modifications from
within the BackEnd database.

Of course, you will have to make the same modification in the BackEnd
database in the office prior to installing any update to the FrontEnd.

Jack Cannon
Click to expand...
 
in other words-- you would have a much easier time with this if you
just moved to ADP
in other words-- you would have a much easier time with this if you
just moved to ADP
in other words-- you would have a much easier time with this if you
just moved to ADP
in other words-- you would have a much easier time with this if you
just moved to ADP
 
Back
Top