Changing tables in a split database

[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.

 

[Jack Cannon]

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

 

[dhstein]

Thanks Jack. That worked.

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

 

[a a r o n _ k e m p f]

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