|
|
Posted by M Bourgon on 07/10/07 20:59
On Jul 8, 8:31 pm, "JA" <jarmour at kc.rr.com> wrote:
> When making stock, price, etc, changes - back when I used Access, I would
> make the changes to a copy of the database, on my desktop, give it a
> different name, upload it to the server, and when it was finished uploading,
> I would rename it, so that it would overwrite the original database
> immediately. (It was about 80 mg back then).
Not sure exactly what you're trying to do - I don't use Access much.
But are you trying to update the contents of the table, or the
definition of the table?
If you're trying to update the contents, you're best off either
learning the basic UPDATE syntax of SQL, or using a Linked Table.
Those may give your DBA the shudders, though. But it's quick, easy,
and can be relatively painless. Another idea is to have him code an
SP or two that you can run that will update the records. If you have
access to a web programmer, they should be able to build a web page to
do so.
If you're actually updating the table DEFINITION more than once or
twice, you really ought to look at why this is happening. Tables
should not be changed often - things break. It should be a major
thing. You might need to look at rearchitecting your tables, build
something that doesn't ever have to be tweaked.
> And if the other way is better, how do I make a query (I know- it's a view-
> but that's about all I know!) of 2 tables? I don't think the table in
> question has a primary key any longer, I think maybe the tables are joined
> programmatically? And is it possible to copy and paste from one column to
> the next?
I know that there's a SQL button somewhere in there. What it sounds
like you want to do is join table A to table B, only showing records
where there's a match in both tables. The syntax in SQL is:
select * from A inner join B on a.key = b.key, with KEY being whatever
your key is to connect the two. It doesn't have to be a primary key -
a logical key will suffice, and even if there's no longer a primary
key, you might be able to use the key anyways.
> I hope this makes sense.
Hope this helps. You might be better off trying the Access
newsgroups, they have more experience than I at what you're trying to
do.
Navigation:
[Reply to this message]
|