Thanks Craig. So, what you are saying is to make a new table with desired field names in SS first, then instert records into that table from other tables (also...

I'm sorry, but I'm not sure if I understood your response. Could you please clarify?

Remember, the tables are already in SS and linked to Access. All the queries/macros/codes are in...

Thanks Jerry. No we didn't specify any PK, may that what caused the issue?

We will re-link the tables and select PKs and test it again.

Thanks.

jerry-621596 (8/19/2010)

---

Exactly what is the error...

Thanks Simon.

I thought you can modify a table residing in SS and linked to Access by running an action qry from Access... I just don't know how to do it...

Thanks. I appreciate the feedback. Are you saying the 'SSMA' tool will convert all Access queries/macros without any adjustments?

Thanks.

Thanks Dan. Actually i'm not a DBA at all. But I do model data. I'd love to know the price of Oracle std edition for 5.

Thanks.

Thanks Henry. Do you know the pricing of Oracle for 5 licenses? I think MS SS costs about $1800, but I could not find stright answer about the cost of...

I'm in TX. I used to live in Central FL when mentioning 'End2End Training. Thanks for the info.

Thanks Grant.

It seems like the 64-bit desktop will be the ideal option.

Yes, we are looking into getting some training on TSQL (I have looked at MS training classes... they are...