Error 15135 on upsizing Access to Sql Server

[Paul Proefrock]

I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs
fine when I try it locally to Sql Server Express 2005.

When I try to upload it to our remote server, I keep getting a bunch of
errors "
Server Error 15135: Object is invalid. Extended properties are not permitted
on 'dbo.<table>.<field>', or the object does not exist."



I googled the error but all I could find was a change in coding to correct
it. Since this is a Microsoft Wizard, I can't change any coding.



Any ideas on what is causing it, how to correct it?



thanks



Paul P

 

[Gil Lapid Shafriri]

Why don't you try the SQL Server Migration Assistant for Access

http://www.microsoft.com/sql/solutions/migration/default.mspx

It is in beta now (release at the end of the mounth) but it is working fine.

Gil

Gil Lapid Shafriri
Program Manager
SQL Server Migration Assistant
Microsoft
425-7054487

 

[Alex Dybenko]

Hi Paul,
do you have enough permissions (should be dbOnwer) for remote database? try
to check this

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Paul Proefrock]

Gil
Thanks, I'll give it a try. I am currently in a testing mode so it may
benefit both of us.

Paul P

 

[Paul Proefrock]

Alex,
I am the only user of the database and owner is checked under my user name.
The database is on a leased server, I am not the admin of the server, if
that makes a difference.

Paul P

 

[Paul Proefrock]

Gil,
Just noticed the page for the Access Migration tool calls for 1Gig memory.
Is that for the machine it runs on or for the server?

Am I going to hit a wall on my laptop with 512?

Paul

 

[Gil Lapid Shafriri]

Should be OK as well.

Gil,
Just noticed the page for the Access Migration tool calls for 1Gig memory.
Is that for the machine it runs on or for the server?

Am I going to hit a wall on my laptop with 512?

Paul