Reversing Database Splitter 2

[BoulderBum]

I split my database to seperate the data from the interface, but now I want to combine the front- and back- end so I can put the DB on CD to show someone. What is the best way to go about this?

If the above process is complicated, is there a way to link tables to a relative path (such that the DB will function correctly if the CD drive E: or D: or whatever).

 

[hjgoldstein]

You can do this either from a copy of the front-end or the back-end.

In the Front-end, delete the linked tables completely, and then use the "Get external Data" menu item inder "File" and copy the entire tables from the back-end.

This is easier than copying all of the other objects - forms, queries etc. from the front-end into the back-end, though this is also possible.

Hope this helps.

 

[willir]

BoulderBum

Two things...
- I have found running a database from a CD real awkward -- Access wants to write to its system files -- cant on the CD, and complains very loudly.

- You can still keep your database split. On the front, delete the linked tables, and then re-link them to the new location. Very easy. In fact, much easier than copying / importing tables and reestablishing relaitonships, etc.


My suggestions would be one of the following...
- Copy the Front and Back end to a local PC to be used for the demo. Delete end relink the tables on the front end.
or...
- Use one of the new USB devices currently available. I have started useing them, and now that they can handle 128 to 256 MB, they are assume! Compact flash, smart disk, PCMCIA / PC card, and others. The one catch is the supporting computer has to be Windows 98, ME, 2000 or XP. 95 and NT will not work without supporting software. And the USB device solution will cost you a few bucks -- perhaps $60 to $80, but well worth it. You can link your back end tables on the external media, rather than doing it on the fly at a customer's site. This is my preferred solution.

Richard

 

[BoulderBum]

Perfect! Thanks, guys!

"I have found running a database from a CD real awkward"

The thing is that the DB is just for demonstration. I need to have it in a format where I can just leave it with someone (along with a few other projects) as part of my portfolio. When using the DB, it was actually ported around on a flash drive, but I can't afford to leave that with everyone.