Hi Clifton,
A.) Yes, ... but any "edits" that you do to the MDB will replace any changes
that may have been made by other users.
B.) The MDB could be sent as an attachment, which you would "save to disk",
make your changes, then send a revised copy back. Again, the comments in "A"
obove would apply.
C.) You'd naturally *think* that a Works WDB (database file) could be
imported into another Microsoft application (Access) ... wouldn't you? Well
.... sorry, but no. A "work-around" is to export the WDB data as DBF, then
import the DBF data into Access. This applies to *data only*. There is no
way to export other objects (queries, form, reports) that I am aware of.
A + B) As an alternative to *replacing* the entire MDB file, you could edit
the data on your PC , then design an append (or update) query to append /
update the "main" copy with your data. If you are appending data NEVER
include any AutoNumber - type data in this scenario ... let Access add that
itself on the "main" I'm also thinking that this approach could get a
little tricky with relational data, however. I'd advise you to make a backup
copy of the "main" database every time, before performing this "append /
update", followed by a careful scrutinization to ensure that you have made
valid changes.
HTH,
Don
"Clifton" <cx******@worldnet.att.net> wrote in message
news:k3*********************@bgtnsc04-news.ops.worldnet.att.net...
I included Access in my new computer especially to be able to receive
Access database files, edit and send back. A) Can I do that? B)Where do I
copy the received(Email) file; a new folder created for that purpose, or?
C) If I have or receive a works database file, can I convert to an Access
file? and D)Do I need Works installed on the new computer?
