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 wOOdy-Soft 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: *

  • Users: ottman2
  • Content: Threads
  • Order by date
  1. ottman2

    Syntax for Variable Field Names

    I want to reduce duplicating code, by looping through the field names. Is there syntax to reference variables i.e. glbLastExportDateNP1, replacing the 1 with the x? Here is a simple version of what I'm trying to do. For x = 1 To 2 Set inputdb = CurrentDb.OpenRecordset("qry_NP" & x...
  2. ottman2

    List all users that have a file open

    Is there a way to determine all users or machines that have a particular file open?
  3. ottman2

    Linking to SQL Server, Index Missing

    I'm using Crystal 8.0 and I connecting to SQL Server 2000 database. I want to link more than one table, but the indexes are not showing up in Crystal. From what I have searched, it seems indexes are not supported using ODBC? Is there any way to get the indexes to work with SQL Server?
  4. ottman2

    Allow zero length as default

    Several times a week, I import a different text delimited table to process in Access, but it always takes me two steps because the text field parameter "Allow zero length" defaults to "No". I have to import once with errors, then change every field's parameter to "Yes", then delete all records...
  5. ottman2

    Field Permissions in SQL Server?

    I have a database in SQL Server 7.0 and I'm using MS Access 2000 as the front end. I would like to give certain users read only access to certain fields and edit access to other fields. I know I can create a form in Access to do this, but I like to setup the security on SQL Server side, to...
  6. ottman2

    Append to MS SQL Server, System Resource Exceeded

    I'm using MS SQL Server 7.0 and MS Access2000 with NT 4.0 sp6. I have a append query that tries to append 50,000 records from Access to SQL Server. It comes up with the error "cannot undo", which is fine, I tell it to continue, then shortly after, it comes up with "System...
  7. ottman2

    Problem reconnecting mapped LAN drive at logon

    I have a shared folder on a NT 4.0 Server running Sp6. I have several workstation that are mapped to this drive. Originally mapped using Windows Explorer and I had checked "reconnect at logon". When each person boots up, they get a error at log on "An error ocurred while...
  8. ottman2

    Call VB 6.0 dll or function from Stored Procedure in MS SQL Server 7.0

    I'm migrating my databases from MS Access 2000 to MS SQL Server 7.0, but I also want to move my functions that currently exist in MS Access Modules, because the process is too slow from Access and with a Stored Procedure I can schedule it at night as well. I was approaching the idea of creating...

Part and Inventory Search

Back
Top