Question Link 1 more table to SQL

[swarv]

Hi,

I have to create a new table in access which is fine. But i want it linked to the SQL database. My other tables are. When I copy one of the other tables and then paste as a new name it doesn't show on the SQL server.
How can I get this to show?
Thanks

Martin

 

[Guus2005]

It doesn't work that way.

Linked SQL tables in Access have an actual table in SQL Server. You can link a table (e.g. Table1) from SQL Server and give it a different name (e.g. tblOrder) but it is still the same table (Table1).

Linked tables from SQL Server need to be created in SQL Server. Using DDL you can create a table in SQL Server on the fly from within Access if you have enough rights to do so.

HTH