Help out a friend and get their data back into their newer app?

S

SRussell

I have been working on a friends app over the week or so and I'm ready to
bring it back to him. Of course he and his company have been putting in
data in their version of the app.

So how do I get their "poo" from their app into my newer version?

20 tables with 2000 rows in a few of the tables, plus a few lookups.

TIA
 
D

Douglas J. Steele

To prevent problems like this, the application should be split into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). When you're
making changes, you make them to the front-end only. When you're done, you
give them a new copy of the front-end, and make sure that it's pointing to
the correct back-end. Note that each user should have his/her own copy of
the front-end, preferably on his/her hard drive, with only the back-end
existing on the server.

You can split their existing database now, and only give them the new
front-end.

References you might find useful for this topic include:

http://www.mvps.org/access/tables/tbl0009.htm
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.granite.ab.ca/access/autofe.htm
 
S

SRussell

Douglas J. Steele said:
To prevent problems like this, the application should be split into a
front-end (containing the queries, forms, reports, macros and modules),
linked to a back-end (containing the tables and relationships). When
you're making changes, you make them to the front-end only. When you're
done, you give them a new copy of the front-end, and make sure that it's
pointing to the correct back-end. Note that each user should have his/her
own copy of the front-end, preferably on his/her hard drive, with only the
back-end existing on the server.

You can split their existing database now, and only give them the new
front-end.

References you might find useful for this topic include:

http://www.mvps.org/access/tables/tbl0009.htm
http://www.granite.ab.ca/access/splitapp/index.htm
http://www.granite.ab.ca/access/autofe.htm

Thanks. I'll look into doing this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top