I tried splitting an mde file.......

[lrfowler]

So, I tried splitting an mde file...I got it split....but then I lost the user-friendly form style interface with buttons, etc...Not sure how to explain it....
I created the 'filename_be.mdb'..and a 'filename.mde'...but the 'filename.mde' lost all of its user-friendly formatting with the buttons, etc...


any ideas?
please see pic of proper invoice...

thanks

[pkstormy]

Did you split the mde file or the mdb file? You want to split the mdb file and THEN create an mde file from the frontend mdb file that is created when splitting (the backend should remain an mdb file.)

[lrfowler]

I split the .mdb and I can access the Access form OK...but when I go to exit ..it asks me if I want to backup the database...so I say yes...then I get the error....I go to debug ...and now it doesn't let me debug....

the first time I got the error..it opened the debug screen.
If I press 'end' it ends ...but I don't know if it was backed up....does it need to back up?

please help..thanks...

[pkstormy]

Did you debug/compile the frontend code? Do you have any kind of backup routine coding run on exit?

[lrfowler]

I don't think there is a backup routine....
It asks me if I want to do a backup...but I don't really see a backup file anywhere....
Should the .mde file be the same as the .mdb file? same date and time?
Because I don't see a .mdb file...

[pkstormy]

You should have an mdb (backend) and an mdb (frontend). You make coding changes in the mdb frontend and the debug/compile and then create an mde file from that (under Tools -> make mde file).

If you need to make any design changes, you make them in the mdb frontend and then re-create the mde file. You cannot edit forms/code in an mde file.

[lrfowler]

So...does the .mdb get changed at all after the .mde is created.....?
what I mean to say is ..when the .mde file is saved...is the .mdb file affected?
and if not ....where is the backup Access is asking me if I want to create when I save the .mde?

Is there a backup file?

[lrfowler]

does the .mdb contain the same data (invoice info) as the .mde?
I found an .mdb...but it does not contain the same invoice info (up-to-date-invoices) as the .mde.

Would it be possible to have an .mde file without an .mdb file?

thanks!

[RuralGuy]

You should really stick to one issue in one thread: https://www.accessforums.net/access/...ers-12950.html

[pkstormy]

If you 'lost' the mdb after creating an mde file, something went wrong in the process. Look for a db1.mdb file which MSAccess uses as a temporary when creating the mde. (but you'd be best going with a backup of the mdb if you have one.)

When you create an mde (which you should do), you'll then have both an mdb and mde file in the same folder. The mde will be slightly smaller depending on the code/other factors.

I will make my code changes in the mdb and then just create an mde file which I then copy to the network drive for the users.