Editing tables

  • Thread starter Thread starter Rick Witte
  • Start date Start date
R

Rick Witte

How do I add fields to table that have already been upsized?

I have recently upsized an Access 2002 database to SQL server using the
wizard. Everything is working just fine. Now I find that I need to add
some fields to a table. When I attempt to open the table in design view I
get an error message: "Table <table_name> is a linked table with some
properties that can't be modified. Do you wish to open it anyway?"

I open the table in design view and add a field but when I try to save I
get: "Microsoft can't save properties changes for linked tables".
 
Rick said:
How do I add fields to table that have already been upsized?

I have recently upsized an Access 2002 database to SQL server using the
wizard. Everything is working just fine. Now I find that I need to add
some fields to a table. When I attempt to open the table in design view I
get an error message: "Table <table_name> is a linked table with some
properties that can't be modified. Do you wish to open it anyway?"

I open the table in design view and add a field but when I try to save I
get: "Microsoft can't save properties changes for linked tables".
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It sounds like you've linked the SQL tables to your Access front-end &
are not using an Access .adp front-end, correct?

If linked tables, you'll have to use a pass-thru query to add columns to
tables in the SQL server database. Here's how:

In the Access front-end:

1. Create a pass thru query:
While in query design view: use the toolbar item Query > SQL
Specific > Pass Through. The view will change to SQL View.
2. Use a DDL statement like the following:

ALTER <table name> ADD <column name> <data type>

e.g.: ALTER MyTable ADD MyColumn VARCHAR(25)

3. Run the pass-thru query.

See the Access SQL Help article "ALTER TABLE Statement" for more
information.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQYqh5IechKqOuFEgEQJMkgCePwMd665TwFVuflZ9qNJ4h8sWNcIAoPYS
qXX1MKGwzcWDA37l6GIl7kPS
=jNpz
-----END PGP SIGNATURE-----
 
Back
Top