Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems importing reports from Access 2.0

Status
Not open for further replies.

rodenm

Programmer
Jan 15, 2002
3
GB
I am trying to convert an Access 2.0 database to 2000. However, it fails when converting the reports, giving the following messages:

"Microsoft Access can't add, rename or delete the control(s) you requested."

"Microsoft Access failed to create the visual basic module 'Report_report name'. If your database is on a network drive, check your network connection, and then tru again"

"Microsoft Access failed to convert or enable your code modules."

I have tried everything, from changing the owner to the Admin account, assigning all permissions to the Admin account, importing the reports into a new Access 2000 database & even drag & drop. All my attempts have failed.

Thanks

Mike

Mick@roden1.freeserve.co.uk
 
The problem arose from the length of the object names. If a control on a report is given a name with 20 or more characters then the report fails to convert.

Amending the object names so they contain less then 20 characters enabled me to import all the reports I was having problems with.

Mike

Mick@rodenm.freeserve.co.uk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top