Search results for query: *

Hey thanks for all the advice. I was able to use the Where Not exist clause to only append the records where the primary key was not already in the table appending to. example: INSERT INTO tbltestappend ( Company, [E-mail], [Name 2], [Name 1], [Address 1], PhotoID ) SELECT...

Can anyone provide suggestions on the following situation: I have a ODBC bridge for access that connects to our website sql server. I need to periodically (once or twice a week), pull the user information from the web server and append it to a table in our local database. Problem is append...

I am working on my first ACCESS project and have run into a bit of jam. I have created a form showing total number records of different queries. I want to put an additional row on my grid that totals the number of records from two different queries which have criteria defined. I have written...

I am working with a contact management database and need to create a form that allows the user to create a query using states (NY, CA) as criteria. Ideally the form would contain each state with a check box. The query should be based on the selected states. I figure I would have to create a...

Hey thanks for responding. From home the employees would just need to be able to browse the network and have the network resources available to them. Remote desktop is not necessary.

I am looking to setup a VPN host in a small office for remote access by the employees from home. Existing currently is a win2k local domain and five workstations. This office has static IP's for all computers provided by the ISP, so the PDC is not running DHCP. They use a public IP scope with a...

open your dns manager console and and navigate to the forward lookup zone for your domain. right click in the pane and select new host record. in the name field type www.mycomp.com, in the address field put in the hosting servers ip. Can the network browse the internet besides their own site?

are you using a mail exchanger? like mail.mycomp.com, if so try computername.mycomp.com for the setting for smtp server internally.

First answer a few questions. Does your network have the same domain name as the website? If it does you need to enter a www.mycomp.com host record in your dns that points to the web hosting server. Have you manually entered any host (A) records in the dns server currenty running on your...

Ok I guess if I explain the topology of the network and then background of my situation first this posting will be more comprehensive. We are a small company setting up a brand new network using a registered mydomain.com. This network consists of two windows 2000 servers and some clients. One...