Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import Source File Name with every record. How?
I'm am using DTS for importing multiple txt files from a certain directory (as described here: http://www.sqldts.com/?246) How could I also import for every record the name of the source file it comes from? The import is being done to a SQL server table where I will add a varchar column, let's...- natha
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Data Transformation Services
-
Several times same SQL db name in system DSN drop-down menu
I am setting up SQL Server ODBC connections on several machines on our network for "adp" front-end. But when I go to choose the server I want to connect to from the server drop down list, I got two or even three server names e.g.:"COMPANYSERV", "CompanyServ" and "CompanyServer". We have only...- natha
- Thread
- Replies: 7
- Forum: Microsoft: Access Project (ADP)
-
Several times same SQL db name in system DSN drop-down menu
I am setting up SQL Server ODBC connections on several machines on our network. But when I go to choose the server I want to connect to from the server drop down list, I got two or even three server names e.g.:"COMPANYSERV", "CompanyServ" and "CompanyServer". We have only one SQL server... -
Remote Connecting To SQL Server
Hi everyone, We want clients to connect via an Access Project front-end to a SQL Server database. SQL Server is located in our main office, and the clients will be located somewhere else, maybe outside the country. How do we connect the clients to the SQL database with adp front-end? SQL...- natha
- Thread
- Replies: 3
- Forum: Microsoft: Access Project (ADP)
-
Convert 23-character- long string to number. What datatype to use?
Hi, Following fields are in my db: [CodeBanque], char, 5 [CodeGuichet], char, 5 [NoCompte], char, 11 [CleRIB], char, 2 I need to concatenate those 4 fields and apply modulo 97 for Bank Account validation check. A msgbox must then appear with the result. (If = 0 it's OK. Else not.) The...- natha
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Connection to SQL Server 2000 lost several times a day.
We lose regularly connection with SQL Server. (We connect on LAN via Access project front-end.) That happens a few times a day. It longs for about 5 minutes and then we can go on. The problem is not the LAN, since connecting attempts on server machine itself (via Enterprise Manager) also fail...- natha
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
