MDE to MDB in Ms Access 2000

[rabselling]

Hello every one !!!
This is my first time posting, 'coz i'm a new member to this community.

Please let me seek you all's expertise.
Problem is that i couldn't find my .mdb file and i got the .mde file from my client. Now, he wants me to make changes there in the application. where i have tried many times. I could only see the database (i mean tables), i couldn't see any forms, reports, macro, etc. and even the design mode there is disable and coding form too.
How am i going the design or get into the .mdb format where i can make changes in anything, like forms, reports and coding?

Please suggest me...might be possible around you all, but io couldn't!!

[Tanis]

The short answer is you can't. Once you have converted to an MDE file there is no going back!

[pgirl]

Create a new mdb database.

Use the file -> get external data -> import utility.

Choose SELECT ALL to import all the tables, queries, reports etc.

You can import the data as well, or just the data definitions. (Click OPTIONS to choose)

This should give you back the design options.

[rabselling]

Thanks Pgirl,

Thanks for that idea, but can i get the coding view also ...i mean do i need to do coding right from the beginning. If even after importing the forms and reports back to new project.

any ways i will try your idea, and will let you know the problem.

Many thanks indeed.

rabselling.

[Tanis]

You can only import the tables and queries. The whole idea of an MDE file is to seperate the code frrom the data. I'm afraid you are stuck, unless you have a backup of the MDB file!

[rabselling]

Hi there,
Thanks! but if i get replica of MDB then can i make get the design mode...like will i see my coding and all ..
please help me ..how to if yes ..!!!

[Tanis]

Not sure about replicas. Why not try to import all the objects from the replica to an new DB? Then have a look to see if you can see the code.