How can I send updates to an ACCESS 2000 program?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I wrote an Access 2000 routine for my brother.
He has already started using it ... it contains: 4 tables and
approximately 10 to 15 each of queries, forms, and reports.
At the moment, the complete '.mdb' file occupies about 48 MB; which is
too large to email back and forth.
I would like to send him some changes in the reports, queries and forms.
I have asked him to make a copy of the '.mdb' file on a CD and send it
to me ... I will modify it, and send it back.
It is rather awkward to do the updates this way.

I plan to cut the relationships between the tables and move the 'tables'
to my modified routines; reconnect the relationships, etc., and sent the
entire '.mdb' file back to him on a CD.

Is there a better way of doing updates?

Bob
 
Firstly, you are probably better off splitting the data from the
application:
Create a new database, & import the tables into it.
Then, in your 'application' db, remove the tables, & then link the 'data' db
tables back into it.
This will make the application & data mutually exclusive.

If your brother makes a change, he could export the modified object to a
new, empty DB & email that. You could then import the object from this DB
upon receipt...
 
You should split the database. There is even a wizard for doing it. (Tools
.... Database Utilities ... Database Splitter) If you both have the path to
the data on the same place in your computers, you don't event have to relink
the tables. Otherwise use the Database link wizard to connect them back up.

With the database split, he does not need to send you anything, you work on
a new copy and then zip it up an email it to him. He unzips it and put the
file where you've told him to. What could be simpler?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
ZBC said:
I wrote an Access 2000 routine for my brother.
He has already started using it ... it contains: 4 tables and
approximately 10 to 15 each of queries, forms, and reports.
At the moment, the complete '.mdb' file occupies about 48 MB; which is
too large to email back and forth.
Click to expand...

This sounds very large for what you've done.

Once you've done the splitting make sure you compact both. I'd
suspect that, unless you've got graphics, both files would be under 1
or 2 Mb.

Tony
 
Back
Top