Update queries...I'm stuck!
Posted on 2005-05-06
Here's the scenario...
I've created an Outlook form that includes VBa to fire the results into an Access table (outlookdata). To get this to work I am using a Linked table from a database that is stored on the network, but the data from the Outlook form is fired into a database on my machine, which includes the linked table from the network.
In a test environment this works fine, when i activate the Macro containing the VBa, it fires into the database on my machine, which in-turn populates the table on the Network...the problem is that I am taking over a database designed by someone else, however the field names are not all the same:
The database on my machine has the following table fields:
SPNumber, FullName, Summary, Impact.
The database I'm taking over (on the network) has the following that contains the same information, but named differently:
SPnumber, Name, Proposal, Decision
Would it be OK to rename the fields on the network database to match the DB on my machine? Or can I do some kind of query that would "convert" the details in say, 'FullName' to 'Name'?