Can I downsize SQL 5 tables? (1 Viewer)

[jlathem]

Hey Guys,

I have an Access DB that I upsized the tables to SQL 5 backend. Since then I changed laptops and by back up (original) files were lost.

I have the front end that is talking with the SQL tables fine but I need to make start making some enhancements and don’t have my original DB with the original tables intact.

Is there a way, without disturbing the SQL tables, to downsize the tables so I will have a local copy of the database?

Thanks I advance for any assistance you can offer.

James

 

[vapid2323]

I am sure there might be a better way but till somone posts that I will post the way I create a local verson from SQL.

Open a database with the ODBC connection to all the tables on the SQL server

Open a second database you would like to create a local table

Copy a table from the ODBC connected database and paste with Structure and Data.

This will not keep the relationships though

 

[jlathem]

I am sure there might be a better way but till somone posts that I will post the way I create a local verson from SQL.

Open a database with the ODBC connection to all the tables on the SQL server

Open a second database you would like to create a local table

Copy a table from the ODBC connected database and paste with Structure and Data.

This will not keep the relationships though

I have two sets of tables.

1 - has SSMA$ before the table name
2 - has an arrow and looks like a globe next to the table name

Do you think I should copy all of the tables or set 1, or set 2?

Thanks for your help by the way.

James

 

[vapid2323]

I have two sets of tables.

1 - has SSMA$ before the table name
2 - has an arrow and looks like a globe next to the table name

Do you think I should copy all of the tables or set 1, or set 2?

Thanks for your help by the way.

James

I would get the globe ones, but keep in mind:

• The ones with the Globe are your remote tables on the SQL server.
• The ones with the SSMA i think are backups when you migrated to SQL (you sure these are not the orignal tables you are looking for?)

 

[jlathem]

I am not sure of anything. This project was the first I have done with the upsizing to SQL.

But it looks like you are correct. When I double click them the ones that have the SSM$ seem to only have the original data that was there when I upsized the tables.

The tables with the globe show all production date.

 

[jlathem]

I think I have it worked out. Thanks for your help!

James
PS I gave you “thumbs up”!