Getting a database without the data

[GRB]

Hello,

I want to get an Access database from someone to modify the user interface and design a few reports. But the information in the database is very sensitive. What is the best way to obtain the database without the data? Do we copy the database file, run queries to delete the data, and work on the resulting database file? Is there another, better, way?



Thanks in advance.

[boywonder]

How I do it is creating a temp table, load the data in it from running my code, show the report, and after the report is finished, removed all data from the temp table.

[GRB]

Thanks boywonder,

I guess my question was not clear. I need a copy of the database design (the form design, report design, table design, queries, etc) without the data itself. The question is, how to do it. Do we copy the database file, erase the data in the tables, and then work with the database designs? Is there another approach to just getting the design without the data?

Thanks again

[SteveH2508]

Import the objects into a new database. When you import the tables, select definition only - this will leave the data behind.

[RuralGuy]

If the application was split into FrontEnd and BackEnd then it would be a snap. As it stands you will have just as much trouble integrating your changes into the existing system.
http://allenbrowne.com/ser-01.html
http://www.granite.ab.ca/access/splitapp/why.htm

[GRB]

Thanks RuralGuy and Steve2508,

I will look into these two solutions and let you know how they work out.

Thanks again.