Recreating Backend Database From Frontend

[PTraxler]

Hi,

I have deleted the backend of my database by mistake. Is it possible to recreate this from the frontend? I understand the data is lost, but the database was very complex and is more important.

Is it possible?

It was created using Access 2000.

Any help would be much appreciated,

Paul,

[phkninja]

it depends. usually when creating a database a Entity?Relationship diagram, a UML diagram or some method of graphically describing the database is created. Depending what information is in the front end, depends on how much of the database structure can be recreated.

In most cases the database is set up to do most of the work, and the front end is passive (meaning it doesnt give much clues as to the backend's construction). One reason for this is speed, with the database server doing most of the work.