Change Forms with Split Database?

[TKGerdie]

I have split my database. The back end is on the shared drive and I have
placed the front end (mde) files onto the users computers. They are working
great. However, I need to update the design of the forms and can't figure
out how to do that. When i go into the back end, there are no forms. This
is the first time I've split a database. I've tried to research it, but
can't find anything. Please help.

 

[Steve]

You need the original MDB file the MDE frontend was derived from. You can't
make design changes to a MDE file.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Spencer]

To expand a bit on Steve's response.

You need to edit the FRONT END - that is where the forms, reports, queries,
macros, and code modules reside. The backend has ONLY the tables. Also,
you cannot edit an MDE file, so you will need the MDB file you created the
MDE from.

Once you have made you changes to the MDB (and tested thoroughly), you can
create a new MDE and replace the MDE front end on the users' computers.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[TKGerdie]

Can I use the mdb that i created as the back up copy?

 

[John Spencer]

You should be able to if the backup was created after you split the
database.

If it was created before you split the database then you will have to split
the database again and relink the tables to the backend you created earlier.
CAUTION: Do not split the mdb to the same location as your existing data -
you could overwrite the data file and wipe out all the data entry.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[TKGerdie]

thank you very much. with your help, i was able to correct my mistake and
get it done!