Got a problem with Moving into SQL

[winterh]

I have moved the backend of the database in SQL using the access wizard which seemed to work ok...

I have tried to link the frontend of the database onto the backend/SQL which I have followed the guide on MS (I hope is right :-) ), i have a couple of questions...

1st have I done it right by only moving the backend into SQL,
2nd when I have linked the frontend to the backend in SQL, I try to open one of the forms and it does not work, when I try and open the table in the frontend i get a message with says "ODBC - Call Failed" and when it opens it only has 63 recordes and not the 4500 which it should have and every field has #Name? any idea what I need to do.

Thanks

[June7]

1st - yes, only the data tables should be in the backend.

2nd - I guess something went wrong with the connection setup. I have done an ODBC connection to a SQL database, once. (I rarely use that data.)

Do you have link to the instructions you followed?

[winterh]

Hi

This is the link I used http://office.microsoft.com/en-us/ac...010200494.aspx

I just think I have missed something simply but I just can't get it clear, I am using Access 2010, if ODBC is not the best way can I make it work a different way?

Got the bosses on my case about getting it sorted (great) :-) any help would be great

[winterh]

When I upsize it I get this message, any ideas?

[winterh]

I have fixed the above problem, by removing a load of old queries and forms I have saved on the backend.

But when the thing imports the tables into SQL it displays all the information within CS file, apart from one table which holds most of the data, any ideas?

It does not show any error message when it does the import.

If i open SQL it seems like it does not have any data for that one table