Solved

Access to SQL Upsize Error

Posted on 2004-10-09
6
564 Views
Last Modified: 2008-02-01
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.forumMessageAttachments', 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?
0
Comment
Question by:gexen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 2

Expert Comment

by:bbaldwin
ID: 12268175
Sounds like a compilation error. Was the database compiled prior to upsizing?
0
 
LVL 2

Accepted Solution

by:
bbaldwin earned 500 total points
ID: 12268180
Also, you may need to Compact and Repair before upsizing.
0
 
LVL 1

Author Comment

by:gexen
ID: 12268194
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?
0
 
LVL 2

Expert Comment

by:bbaldwin
ID: 12268908
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.  
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question