Help I need to create a new form in an MDE :(

[ShaneBrennan]

I have a little problem.

I've created a Access 97 Database where I create a sub-form on the fly - which I really need. It all works fine - no problems at all until I create an MDE - then the system does not work.

I've worked out why - after a couple of hours you can't create forms in an MDE - boo hoo

Has anyone got any suggestions on how to get around this ?

One train of thought, was to remove all the controls of the form then re-use it without deleting the whole form and starting again - but can I do this once the form has been compiled - again cause the design button has been disabled?

Shane Brennan - enjoying access until it doesn't play ball
Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[Maquis]

An mde file cannot be edited at all. It is meant as an executable to be given to users.

Do you still have your original mdb file? If so just make your updates in it and then create a new mde file from it. If you no longer have an mdb file, well, then I hate to tell you this but you're out of luck. Perhaps your network guys can restore a backup copy? Maq B-)
<insert witty signature here>

 

[ShaneBrennan]

No I have the original

I'm creating a little proggie for recording student grades, where the assessment criteria changes from unit to unit - therefore I need to change the number of columns and the headings - hence the need to create a new sub-form each time

I know it's possible to have a front-back end system for the DataTables - is it possible to have a backend module - that will create an form on a front-end mdb?

So I can hide away code and forms I don;t want people to change - or should I say prat around with

Shane - feeling a little better now
Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[Maquis]

Shane, if the only reason you're creating an mde is to keep people out of your code then you should read a FAQ that I've written. (FAQ181-1021). If you do all the steps in the faq, then you probably won't need your mde anymore.

If instead you decide to keep the mde, then just put the tables in another database and link them in the mde. That way you won't have to worry about re-importing the data every time you need to make a change. Maq B-)
<insert witty signature here>

 

[ShaneBrennan]

Okay I've read and implemented BOTH the FAQ's.

Is there anyway of bypassing this protection? as we don't want students getting hold of other student information.
Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[Maquis]

Well, those FAQs are meant to protect the design structure of your database, not the data contained in it. Students with Access installed on their computers can always link to your tables and see all the data that way. (They can get into mde's as well)

If you don't want students in the database, then you need to store the database someplace where the students cannot get to it. You should also place some user level security in the database.

I have never used Access's user level security system, so I can't give you any helpful advice there. You can read Access's help file on the subject as well search through these forums. I believe there are a few FAQs on security posted around here somewhere. Maq B-)
<insert witty signature here>