473,325 Members | 2,712 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Accesss ADP

JA
First, I gotta tell you, I know almost nothing about SQL Server. I'm pretty
good with Access, in my own way (not programming though) and that is the
only thing I have to administer my SQL Server with (access adp).

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).

But now I have sql server, and don't quite know how to do it. I have a
programmer who writes scripts to do it, but it takes 2-3 hours to make the
changes, and they don't seem to all get done.

So, I have 2 ways of wanting to do it, but I don't know if they are possible
or a good idea to do in sql server. One would be to do like I used to, make
the changes on my desktop, import the new table, and overwrite the old one,
OR, the other way would be to import the new table and make queries on the
fields that have changes, (<>) and copy the changes from one column to the
other. Just using copy and paste. And then delete the "changes" table, to
save space.

So, if either of these are possible, how do I import a table, from Access
into the adp (and ultimately into sql server)? It would have Access
datatypes. Will the adp automatically change them to sql server datatypes?

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 hope this makes sense.

Thanks! Jill

P.S. I wrote in this group once, asking if I could append records to a sql
server table through the adp. The answer was yes, but I am still worried
about the datatypes matching up. If anyone can address that too!



Jul 9 '07 #1
1 1218
On Jul 8, 8:31 pm, "JA" <jarmour at kc.rr.comwrote:
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.

Jul 10 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: WindAndWaves | last post by:
Hi Gurus Has anyone ever developed a tree viewer (something similar to windows explorer) for access without any add-ins, active x-es or what have you? Be keen to hear from any experiences ...
2
by: leiyangcl | last post by:
I have to access Properties of an Object at rumtime at means I do not really know the type of the Object. I do not konw which class it declared with. But I have to access all the properties of it,...
10
by: Robert Fitzpatrick | last post by:
I have plperl installed my PostgreSQL 7.4.2 server, but from what I understand in chapter 39.3 of the docs, you cannot access the databases without DBD::PgSPI. According to the readme for that...
2
by: Des | last post by:
Hi I have created in visual studio 6 an application using access 2000. What I want to do is to put the database and asp on a website. I have been told previously that I would not need to register...
0
by: PaulR | last post by:
Hi, When we use MSAccess to connect to our DB2 database we see the following: An "import" of a table with BIGINT columns works fine however, A "Link" to a table with BIGINT columns fails...
1
by: zuhrs | last post by:
how to access the session variable in adifferent project, whicjh is not in the same solution, but in the same aoolication
2
by: pmfunder | last post by:
Hi all, I'm new to the site so please forgive me if I missed one of the guidelines that I read. I have a large budget database using Access 2000. I'm trying to make the budget table into a...
3
by: Fred Chateau | last post by:
I am trying to access a user control class, for a user control that is loaded dynamically, from the containing page. I have been able to access Web controls in the user control, but so far I have...
3
by: ashvinguna | last post by:
HI, I AM TRYING TO ACCESS MS SQL 2005 DATABASE THROUGH JAVASCRIPT BUT IT GIVING ME RUNTIME ERROR. <SCRIPT type="text/javascript"> <!-- function Aufruf(){ var rst; var dsn; var sql;
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.