Search results

I did that and it has now created alot of duplicates. The original Table 1 hade 4965 contacts the Query returns over 7000.

I have 4 tables as follows: 1. Company Info: Company, Phone Number 2. Source: Company, Source 3. Industry: Company, Industry 4. Location: Company, Country In the company info table I have approx 5000 records. I am running a query to create a list of the following: Company, Phone Number...

Sorry I would rather keep it as is. It is purely in access for the purpose of the join.

I have a teple with the following fields: Company Contact Email Address Phone Some companies within that list are unique while others are duplicated if I have more than one contact from that particular company. I have a second table with the following: Company Industry The companies...

I have sorted the IP issue but I am looking to go for the dsnless connection option but where do I put the connection string?

Are you following me? ;) I will have a look at your sample. As for the other MySQL external IP problem from the other thread I have decided just to move the SQL box to the datacentre with an IP that can be accessed from the office and externally. :)

Do you mean move the whole project over to VB.NET? The current setup is a MySQL back end with an access front end. It is using an ODBC connector. I am not sure where to begin with connecting VB.NET with SQL I have not had that much experience with VB.

I have a few applications written in VB can the code from these be used in Access?

I can connect to the mysql externally using ODBC. The problem is I cant connect to the box from inside the network using the external IP. No the router is not the DHCP, The phone system is the dhcp server.

Ah routing is handled by the router, the sbs is really only there to provide logins and as a file share. DHCP come from the phone system.

How do you mean is SBS handling the handling?

When on a pc on site I can ping the external IP address. I can connect to the MySQL data base using an internal ip 192.168.1.1 port 3306 this works with the ODBC, when i try to connect to to the external ip from an internal machine using the ODBC I get the following error: Connection Failed...

It can be seen externally, I am connected to it just now fro home.

Nope that is not going to work all though I cant connect to the database I get a ping reply from the external ip internally

Not sure not had a chance to try your solution yet :)

There is only a few users who will be working from home with it all who have static ip addresses. I have set up the mysql box only to accept external connections from these ip's.

I am assuming due to the coding involved with the ASP is can only connect to a local database.

I have managed to set up the MySQL and everything seems to be working correctly the problem I am facing is the MySQL is hosted on a server within the internal network. User who are working in the office can access is. I can access the database externally using the external IP. A few of the...

No one? I really need some help :)

Have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=157719&highlight=computer As for the date and time you should be able to do with with the Now() function