How do I add a table to existing db that has been upsized to SQL Express

[digitaldb]

I have an Access db that has been upsized to SQL express and the upsize process created a new mydatabase.adp file. Now I need to add another table but can seem to add it in Access in the .adp file. How do I add tables in Access to a database that is already upsized ?

[CJ_London]

add it where it has been upsized to - in this case sounds like sql server express

[digitaldb]

Is there a way to do it in access ? Or is the upsize a 1 time option for that database ? I only use sql express fir the 10gig size. Not sure hiw to add a table and link it back inti tha access project

[CJ_London]

not tried it but you can try using a passthrough query - syntax needs to be sql server, not access

google 'sql create table' or similar

you can also use sql to add indexes, create relationships etc

[ssanfu]

The method to add/edit/delete tables in SQL Server/Express is to use the SQL Server Management Studio (SSMS).

When SQL Server/Express was installed, the SSMS also should have been installed. If it wasn't, search for "SQL Server Management Studio"... make sure you have the same version as the SQL Server you have installed. For example, SSMS for SQL Server Express 2008 R2 will not work for SQL Server/Express 2014.

Once you have added the table to SQL Server/Express, you might/will have to modify the ADP file to be able to use the table. I have never used ADP.... I understand it has been depreciated.

[digitaldb]

Thanks for the suggestions everyone. I created several new tables in in my db using SSMS but when linked ro them in Access they are read only.

I have a backup of the original accdb file before it was upsized. I should be able to add my new tables and complete all my additions and changes the make a new backuo of it then do a new upsize. Im not really good with SS ir SSEXPress so this may be an easier way for me unless theres something i havent thought of.
-----------------

UPDATE - It looks like the problem I was having is related to using the .adp file. When I use the accdb file, any .accdb file, I can link to any new table and it works fine. I didn't realize that .adp files had been depricated, I'm not a regular Access user. When I did the upsize, I had the option of using the original accdb file or creating the .adp file and I chose creating the .adp. Looks like with Access 2010 at-least, using the .accdb file is the better way to go if you ever need to add or change anything.