473,394 Members | 1,797 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Reverting to original state of Access database from MDE file

Dököll
2,364 Expert 2GB
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
5 1993
Rabbit
12,516 Expert Mod 8TB
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
2,364 Expert 2GB
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
12,516 Expert Mod 8TB
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
2,364 Expert 2GB
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
3,532 Expert 2GB
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

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

Similar topics

1
by: Ruth | last post by:
Alison, You are going to find this a real coincidence! To begin with, I am Roberta Laird's husband. I think you know Roberta. We also are friends with Laura McConnell. Anyway, I am in business...
2
by: Jean | last post by:
Hello, I have just read through the MS Access Security FAQ, and had a go at securing my database, but now I am stuck. I successfully set up a new .mdw file, say DEPARTMENT.MDW. With this...
2
by: ross kerr | last post by:
Hi all, I have a control that extends the ComboBox object. It updates the selected item based on what the user enters in the text area. In the OnLeave event of the combobox, the selected...
3
by: Mark | last post by:
Ok, I know that .net inherently does not share session data across asp.net projects, but is there any decent work around to this. We already have a big chunk of our application using the asp.net...
9
by: charliewest | last post by:
Hello - I have images saved in my SQL SERVER 2000 database. Using ASP.NET (C#) is there any way to temporarily save an image to a session object, and after running some other operations, later...
2
by: san | last post by:
Hello, i am in great trouble. I want to revert back to original state of database before i performed restore database on my sql server 2K Database. Accidently i didn't take backup of my Database...
1
by: techiesekar07 | last post by:
Hi All, I have done a MS access VBA application. I unchecked all the options in the startup options and made a screen to populate. The application is working fine. I need to restore to the...
0
ADezii
by: ADezii | last post by:
In Tip #12, we showed how to display a Progress Meter within Access by using the SysCmd() Function. By using this same Function, with different Action Arguments, we will now demonstrate how you can...
6
by: =?Utf-8?B?VGVycnk=?= | last post by:
When I asked this question before, don't think I was showing up as an MSDN subscriber, so I hope that is fixed now. I am a newbe here and am working through some books on using ADO.Net. These...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.