How to open an Access DB project for modification 2

[problemsinadb]

Hi
I want to change the connection of an ADB project to a new database. But i could not open it in design mode.When I am trying to open ,it is going directly to the running mode and i can not make any modification in it. How can i open an access database project for modifying its connection properties. Any answers will be highly appreciated
regards
jim

 

[PPJOSEPH]

Try opening the file by Shift + Enter

 

[Pampers]

Or holding the shift-key pressed while clicking on the database... if this doesn;t work it probably means that the shift-key is disabled.

Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

Hi pampers,

Thank you for your timely and valuable helps. I tried pressing shift key while opening. Still it is not going to the design view of the project. You mentioned the shift key may be disabled..How can i know whether it is disabled or not? How can i enable it?

Thanks in advance
Jim

 

[Pampers]

You also want to check if the file is not a runtime version. Normally the file extension of an access project is adp, but if you create a runtime (source code is taken out) the extension will be .ade. If the latter is the case, you cannot open it in design mode.



Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

Hi Pampers,

It is a new information to me that the runtime version, . I checked the extension (By trying to open it from the file menu of MS access) it is .adp only.

Is there any possibility that a runtime version with extension .adp ? , since in my machine i created some sample applications that are opening properly in the design mode. But only this one( that was developed a couple of years back and we have to support it now) with the same extension "adp" is direcly going to the running mode.

First it is showing the errors (That i mentioned in my previous post and you suggested it may be the problem of the ADO reference) and then going to a startup screen in running mode. I am not able to add the ado reference also since i couldnt take it in design mode.

I hope if i can open this adp in design mode i can fix the other issues..!!!

Thank you for the patience and help you are showing in this case.

Best regards

Jim Martin

 

[missinglinq]

Does the form have the Close Button (the X) in the right upper corner? If so, what happen if you close the form? Sometimes the Object Dialog box is unseen but behind the form, and will be revealed if the form is closed, allowing you to go into Design View. The problem in situations like this is that you have no idea of the skill level of the person that orignally developed the app.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[problemsinadb]

Hi missingling,

There is the close button in the upper courner. If ai am closing the form then then some of the menu items in the top menu will disappear and only the file, window and help menu items will be visible after that. There is no object dialog box behind the form.

Thanks

Jim

 

[Pampers]

On this page you will find a little tool to disable/enable the shift-key. Maybe you can use it.

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

hi pampers,

The link is good, but it is for adb, and ade extensions. Mine is .adp !!!!!!,

Thanks, and have a good day

Jim

 

[Pampers]

I think you mean: it is only for mdb and mde, not for adp and ade

you can change the code in the program, from:

    strFilter = ahtAddFilterItem(strFilter, "Access files (*.mdb, *.mde)", "*.mdb;*.mde")

to

    strFilter = ahtAddFilterItem(strFilter, "Access files (*.adp, *.ade)", "*.adp;*.ade")

Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

Hi Pampers,

When i tried to enable the shift key for my access db project an eror is coming from the line of code
"Set MyDb = OpenDatabase(Text0)"
Does it mean we have to modify the code for the adb projects.. ? Thanks for your timely and valuabe directions

Thanks
Jim

 

[Pampers]

Yes, the code is not working for adp... But I don't know how it should be modified? Mmmh... I'll keep looking around, but you may want to post the question again, since this post it has a star and thus looks like it is succesfully ended (which is not the case) - Sorry for that.

Pampers
Keeping it simple can be very difficult

 

[Pampers]

Me again,
I just disabled the shift-key in adp. Then I created a new empty application, and used the import fuction (right click the database window and choose import), the adp opens and allows me to import all the forms, reports and so on... If you then would reconnect to the backend???? Maybe it works...

Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

Hi Pampers,

Thanks a lot man.. I am able to import the objects from my adp to a new one.. I hope it will work out..

Thanyou for your patience and your time.

have a good day !
Regards

Jim

 

[problemsinadb]

Pampers,

The forms and reports are password protected it seems. luckly we got the password also. When I am trying to export the below dialog box is coming
"Microsoft helps protect this visual basic for applications project with a password. You must supply the password in the visual basic editor before you can perform this operation."

Where to give the password? How?...Hope you have an idea , Sorry, it may be a basic thing, but the adp is a new one to me (even though it is old !!!!!)

Thanks in advance

Jim

 

[Pampers]

This is also unknown ground for me. But a bit of googling helps. In the visual basic editor (alt F11), go to tools, and then UnlockYourDbProperties. There you can set and fill in a password... (this can be done for .mdb's as well). Hope it works!

Pampers
Keeping it simple can be very difficult

 

[problemsinadb]

Hi Pampers,
Finally we solved it( hopefully), PHV also helped...

As u said we imported the password protected adp by, first adding it as the reference to a new adp. Then we opened it in the vb editor and changed the password to empty. Then it is imported to the destination (the one we added the reference) adp. I hope this solved the issue..we have to check it by changing the database connection...

Thank you for your valuable ideas...by that only we solved it...at last.

regards
Jim