Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 25th, 2008, 03:28 PM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2003 closes when view design

I have a form and when I select View Design, Access closes. No error messages and nothing in the event log. The file is not digitally signed. The form has tabs on it, and its a many other controls (buttons, list boxes, drop list boxes, etc). Plus, 6 or so list boxes with data. I have Access 2003 with the SP3. Any advice why Access closes? I can't change the form and like to.

Reply With Quote
  #2 (permalink)  
Old April 28th, 2008, 06:30 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Try importing the form into a blank access database and checking the code from there.

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #3 (permalink)  
Old April 28th, 2008, 01:03 PM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, I was able to open the form in the new file. The old form is in a MS Office Access Project (.ADP). The form relies on a connection to a SQL Express database and makes stored procedure calls. I don't see in the Access Project file where I can set DB server properties, like I did with the Access Project file.

How do I convert the Access Application to a Access Project?

Thanks again!

Reply With Quote
  #4 (permalink)  
Old April 28th, 2008, 01:51 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I have never heard of any capability to convert an MDE to an MDB or ADP. Normally you create a new copy of the application when you turn it into an MDE, so you then have the old non-MDE copy of the file to continue to develop with. Do you have the ADP copy of the application?

Otherwise I think your only recourse is to import everything into a new file, then save it as an MDB, then upconvert it to an ADP using the Upsizing wizard.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #5 (permalink)  
Old April 28th, 2008, 02:44 PM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the ADP, where the bad form is. Just was not sure how to create a new ADP to import the form. I created a MDB for the test, but I have figured out how to create a new ADP. I will import the form into there and see what happens.

Thanks for you help.

Reply With Quote
  #6 (permalink)  
Old April 30th, 2008, 07:59 AM
Registered User
 
Join Date: Apr 2008
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

For converting MDE to ADP you do these things. First make MDB replica of your MDE file. Make MDB replica to MDB file using design master. Choose MDB file and recover your database using Stellar Phoenix Access Repair Software. You can get this software from here:
http://www.repair-access-file.com/ac...b-recovery.php
Now your have converted your MDE file to MDB. Now split you MDB database and upsize your MDB file. Upsizing wizard found in the tools database utilities menus. Upsize the data only to SQL Server. You'll end up with linked tables to the MSDE or SQL Server tables, but all your queries and DAO code should still work just fine. Through this way you can convert MDE to ADP file. If you lost some data in this conversion, you can use access repair tool and repair your recovered ADP file.

Hope You got your Answer

Good Luck


Reply With Quote
  #7 (permalink)  
Old May 23rd, 2008, 03:21 AM
fyz fyz is offline
Registered User
 
Join Date: Mar 2008
Location: , , China.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

If you still can't get your mdb file back, I think you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files. Hope this helps.

Alan


fyz
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 form in Pivot Table View Steve McGuire Access 4 July 29th, 2007 07:42 AM
Snap Shot of Design View Little Shell VB.NET 2 November 17th, 2006 10:34 AM
Blank Design View ??? smuger Dreamweaver (all versions) 4 October 11th, 2004 04:40 PM
how to enable the design view yylee Access VBA 2 October 4th, 2004 02:23 PM
Could not open in design view!! texasraven ASP.NET 1.x and 2.0 Application Design 4 March 17th, 2004 03:22 PM



All times are GMT -4. The time now is 02:23 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.