gexen
asked on
Access to SQL Upsize Error
Hello,
When attempting to upsize an Access database, a client is receiving the error:
Error:
Server Error 15135: Object is invalid. Extended properties are not permitted
on 'dbo.forumMessageAttachmen ts', or the object does not exist.
when attempting to upsize his forum software. Does this error message mean that it is unable to be upsized because it uses special Access features that do not translate to SQL server?
When attempting to upsize an Access database, a client is receiving the error:
Error:
Server Error 15135: Object is invalid. Extended properties are not permitted
on 'dbo.forumMessageAttachmen
when attempting to upsize his forum software. Does this error message mean that it is unable to be upsized because it uses special Access features that do not translate to SQL server?
Sounds like a compilation error. Was the database compiled prior to upsizing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not to my knowledge, but I know virtually nothing about Access nor MS SQL, all my SQL work as been in SAPDB or MySQL, so I know nothing about these Microsoft technologies.
I can advise the client to try Compact and Repair, but what does it mean for an Access database to be compiled?
I can advise the client to try Compact and Repair, but what does it mean for an Access database to be compiled?
Is there any VBA (Visual Basic for Access) code written in the database? All you have to do to compile open a "module" even if you have to open a new one and go to the Debug menu and choose Compile [Database Name]. If there is an error, there is a problem with some code.