By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,481 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,481 IT Pros & Developers. It's quick & easy.

Works to Access

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.