Access ---> SQL conversion can't get update to work.
Here is my sql:
UPDATE repo INNER JOIN Quotes ON repo.ID = Quotes.RepoID SET repo.InvoiceNum=1064, repo.Rsoldto ='Town Business Center', repo.Rsolddate =4/30/2003, repo.Active = 'Apr 03' WHERE (((Quotes.QuoteNum)=1064));
I get the following...
I can get the data to sql 2000 ok.
My question is how to get the query that is looking locally for a table called customers and it is not there anymore.
It is now an external link called owner_customers in a sql database somewhere.
How do I get all my queries and forms to point to the new table?
I need to setup a wireless net between 2 offices.
I have drawn a diagram and would appreciate any input anyone has.
http://www.callrich.com/network
My objectives are:
1. Faster internet connection for location B. They currently only have a 256 DSl connection.
2. I need to make sure no one...
Hello,
I have been using Access off and on since the old days of Access 2.0.
I am currently using Access 2000.
Pretty much everything I have done has been without doing any coding.
I think I need to do some vba coding to solve a current problem I have.
I have a table called debts and
I have...
I have SCO 5.0.5 and want to direct print to my remote pc printer. I have this working fine using RPM print manager software on my pc.
Now I need to netop remote control into that pc and work and have the print jobs destined for that PC re-directed back to me at home using the netop remote...
I need to enter a bunch of records at a time into a table from one screen.
The table looks like this:
id
serial
invoicenum
I want to be able create 1 form that allows unlimited (if it can be done) input fields and process them into an sql insert into my table.
Are there examples of this...
Help!
I have SCo 5.0.5.
I have a Lexmark 4227 Plus currently on lpt1 using standard_ems script. It works great.
I just put this box on the network and want to move this printer to a HP Jetdirect 300x so that My NT users can print to it as well.
I have done the following.
Moved the printer...
I have a new problem with a sco system.
Until recently users were able to telnet in from another subnet just fine.
Now there is a 1-2 minute delay in getting the login prompt.
As far as I can tell , nothing has changed on the server or the network.
I have tried putting the ip of a machine on...
Can someone give me a quick synopsis of how to add a nic to an Acer server running sco?
I do not know which version of sco is currently installed yet.
The current server is currently not networked.
After I install the nic, will it be recognized automatically?
Are there supported and...
I have an XP pro machine with 2 NICs. On the 1 side is a wireless linksys connection 192.168.1.102 via dhcp from linksys router.
Side 2 is hardwired to 130.140.150.165. It is on a hub with 2 other pc's.
I want the 2 other pc's on the hardwired side to get to the internet via the xp machine...
I have 2 nets in my building.
The first is a 192.168.1.100 linksys wireless network (internet) and 2 pc's.
I have 10 other pc's in the building with a 130.140.150.160 255.0.0.0 network.
Can I put a wireless card in a pc that is already on the 130.140.150.160 network and somehow make it...
Can anyone tell me what if any symptoms I would get if I linked too many hubs to gether?
I am trying to put a linksys 4 -port hub on the end of a cable as I have to add 3 devices in that one area.
I get link lights .
If I connect 1 pc to the line it works fine.
If I connect the line to the...
I have 3 pc's in my small network. 2 have win 2k pro installed from scratch and communicate fine together.
The 3rd PC I upgraded to win 2k pro from 98.
The 3rd PC can be seen on the network by the other 2 but cannot access any shares on either of the 1st 2 PC's.
The same is true going the...
I am trying to setup a win 2k pro box on a Windows NT 4 domain.
I have this problem.
If I don't login to the domain, just the box, I can install software (as administrator) and run it as any other user I login into the box as. I get a new desktop and configuration for each person I login as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.