By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Reverting to original state of Access database from MDE file

Dököll
Expert 100+
P: 2,364
Hiya Fans!

Looking to see if there is a way to revert back to my original tables/queries/forms views and so on, after making up an MDE file out of our database.

I haven't done that yet, just making sure we're not stuck after I do this...

Any ideas how this can be handled, fetched here beforehand, and also found nada through Google.

Your thoughts!

Thanks:-)

Dököll
Dec 6 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,383
What do you mean by revert back to your original views? Whatever the case, always keep a copy of the mdb.
Dec 6 '07 #2

Dököll
Expert 100+
P: 2,364
What do you mean by revert back to your original views? Whatever the case, always keep a copy of the mdb.
Indeed, I have copies up to the Wazoo:-)

In any event I needed to redesign forms or fix bugs I did not know existed. I wanted to see if the MDE file can be reverted to allow me to see database tables, queries, and forms views. By your response though, I am guessing I may just need to use my original copy and make another MDE file as needed.

Is this correct?

Have a great week-end!
Dec 7 '07 #3

Rabbit
Expert Mod 10K+
P: 12,383
Indeed, I have copies up to the Wazoo:-)

In any event I needed to redesign forms or fix bugs I did not know existed. I wanted to see if the MDE file can be reverted to allow me to see database tables, queries, and forms views. By your response though, I am guessing I may just need to use my original copy and make another MDE file as needed.

Is this correct?

Have a great week-end!
That's right. You should be able to see the objects but you can't change their design. You have to create a new MDE.
Dec 7 '07 #4

Dököll
Expert 100+
P: 2,364
That's right. You should be able to see the objects but you can't change their design. You have to create a new MDE.
In this case I think I'll just keep it as is and keep fancy Keys off, perhaps even add a password to enable/disable keys, thought to have seen a code out there for that. Will need to be able to access tables and archive what is needed. MDE file seems like something for down the road, when the database is rid of all bugs, I am sure there's plenty. Much appreciated input, Rabbit:-)
Jan 10 '08 #5

missinglinq
Expert 2.5K+
P: 3,532
My practise to date hasn't required the use of MDEs, but as I understand it, the single most critical thing is to have total error handling in place! When an unhandled error is encountered, an MDE file simply closes without popping an error message, leaving the user and/or you totally in the dark as to what has gone awry!


Linq ;0)>
Jan 10 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.