Updating DB 2005 cannot connect with Access

[Teressa64]

I have a database and I am trying to update one of the tables called "members" I use to be able to update my table by upsizing through Access.
I have SQL Server Management Studio Express 2005 and Access 2007.
I can connect and retrieve the table that I have on the DB using Access but I can't upsize.
Is this a MS SQL thing or is it a problem with Access?
And what should I do to fix the problem.
I have over 2500 members and I really don't want to update manually.
Also is there another program I can use to update my DB instead of Access?

Thanks

[NeoPa]

I'd suggest using Data Transformation Services (DTS) to upload your Access table into SQL, then work natively in SQL from within Management Studio.

Welcome to Bytes!