ACDE Question

[uaguy3005]

I'm relatively new to databases and access. I have a database that I've compiled into an ACDE file. When I enter data using the ACDE file, the tables in the ACDB file are not updated. Are these 2 file formats supposed to be linked? What happens if I want to add a query in the ACDB file and recompile into the ACDE (ie, will i lose the data entered in the ACDE)?

[pbaldy]

They are not linked unless you link them. Typically an application is split between a "front end" accde with the forms, reports etc and a "back end" accdb with the data tables. There's a wizard that will split the db or you can simply go into the front end accde and do it manually. You'd delete (or rename) the local tables in the accde, then click on the Access button on the Import section of the External Data tab and choose link rather than import.

[uaguy3005]

Thanks! That helped. Got it split.

[pbaldy]

Excellent! Keep in mind that you can't make form/report design changes to the accde. You keep the accdb it was created from, make changes to it, and compile a new accde from that to give users.