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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GeekToMe

    Masking Confidential Data in SQL '05 Table

    Greeting! I am loading data files that we are receiving from an external client into a SQL Server 2005 database and have been asked to mask confidential fields such as Social Security Numbers, Account Numbers, etc. (i.e. display '****' in the tables). I'm certain this can be done but I'm...
  2. GeekToMe

    Scripting SQL Server Role Creation

    Greetings all! In our database environment, we create a dedicated database whenever we get a new case. Each case has a project team assigned to it and the members of the project team are assigned read-only access to their databases. I have written an automated process that creates each new...
  3. GeekToMe

    Replace a range of ASCII characters???

    Greetings all! Does anyone know an effective and EFFICIENT method of replacing a range of characters using TSQL? The issue I am trying to resolve has to do with loading data files into SQL with field values that sometimes contain control characters (carriage return, line feed, tab, etc)...
  4. GeekToMe

    Use Access VBA to capture Field List from Visual FoxPro (dbf) file???

    I answered my own question. This is the Visual FoxPro connection string that ended up working for me: conn.Open "Provider=VFPOLEDB.1; Data Source=" & Path & ";" Thanks everyone for all the feedback! NateTheGreek
  5. GeekToMe

    Use Access VBA to capture Field List from Visual FoxPro (dbf) file???

    Sorry, I guess I spoke too soon... The above connection string is throwing the following error: Run-time error '-2147217900 (80040e14)': Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE' Anyone have any additional thoughts? Thanks again, NateTheGreek
  6. GeekToMe

    Use Access VBA to capture Field List from Visual FoxPro (dbf) file???

    Thanks for the prompt replies! This is exactly what I needed. NateTheGreek
  7. GeekToMe

    Use Access VBA to capture Field List from Visual FoxPro (dbf) file???

    Greetings All! Can anyone tell me how I can use Access 2000 VBA to connect to a Visual FoxPro file (dbf) and return the field/column list from that file? Code samples would be greatly appreciated. Thanks in advance, NateTheGreek

Part and Inventory Search

Back
Top