Prevent being open in Design mode...[Rather why is my access opening in design mode?]

[pedie]

Hi, I want to prevent being open in Design mode...
For now when i open the form, and right click on title section it give me options to desgin....which i do not want to....

Thanks for helping

 

[pedie]

Thanks again Norie, thanks HiTechCoach! for usefull piece of information...'ll have to try again as i go to work...


And I want to confirm one thing....if the file is in executable format there is no way to edit/ open in design mode, is that correct?


Thanks again.
After i send out the tool i do not want anyone to make changes...or open in design mode...

Sounds like you have compiler errors.

Manually compile the VBA code. This should identify any errors i n the VBA code.

To manually compile:
Open any VBA module or press alt-F11. On the VBA Editor menu go to Debug > Compile (should be first option on the menu)

 

[Norie]

Pedie

When you do start again, how are you going to approach this?

 

[pedie]

Pedie

When you do start again, how are you going to approach this?

Rebuild the whole thing....
Some tables in the databse contain confidential information so i would not like to linked it to front end.

I tried linking it and then making frontend only executable accde file, however after doing so I tried linking the linked table from master db in accde frontend and it allowed me to linked it without even asking for password....dont you think it is weird? I thought as the main database is protected and I linked the table entering the password, i thought when I try linking table in frontend it might ask for password but did not...

'm i missing something?

 

[Norie]

Pedie

So that means rebuilding without code, to begin with anyway.

 

[pedie]

Pedie

So that means rebuilding without code, to begin with anyway.

I would love to do with minimal use of coding, however this accde thing i think is not working out very well for me...
But yes it is an amazing new thing i learned from you guys!

Now 'm using more query and something like dlookup, dsum,iif etc....
So there is not way to stop people from linking the table the front end table, right?
Thanks again Norie

 

[Norie]

Pedie

I don't think you get it.

The problem with the accde is because you have too much coding.

Using queries is a good idea, but I'm not sure about DLookUp, DSum etc.

Access can automatically sum, count etc in queries using whatever criteria you want.

 

[HiTechCoach]

Pedie
The problem with the accde is because you have too much coding.

Interesting ... too much coding ... hum..

I use VBA in for everything . No macros. I have large front eds with 100's of forms and 500+ reports. 20+ code modules. Almost every form and report have VBA code.

I have never had any issues with making an MDE/ACCDE because of too much coding.

The most common reason for not creating an MDE/ACCDE is the result of compiler errors.


Even is you have no VBA code and just used embedded macros in 2007/2010 I would still create an accde. This will disable the ability for end user to go into deign mode for forms and reports.

 

[pedie]

The most common reason for not creating an MDE/ACCDE is the result of compiler errors.

Even is you have no VBA code and just used embedded macros in 2007/2010 I would still create an accde. This will disable the ability for end user to go into deign mode for forms and reports.

I think compiling code would most probalby solve my problem tomorrow...
HiTechCoach, you said "forms and reports" so this means that they'll still be able to view the table by changing the access settings opening it in edit mode though they cant edit it,'m i getting this correctly?

 

[HiTechCoach]

... however this accde thing i think is not working out very well for me...

Sounds like you have database and/or VBA coding issues. Your database must be "clean" before you can create an accde. If you can create an accde then your database is has issues. It is not ready to be used in production even as an accdb if you can't compile it to an accde.

 

[pedie]

You are HiTechCoach...'ll compile my code tomorrow
we cross posted....

Please see my prev post too.