Recent content by ottman2

That will work. Thanks. Dim glbLastExportDateNP(2) as date ... glbLastExportDateNP(x)

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...

I'm not sure about the path syntax. Set fso = GetObject("WinNT://mcmnetapp/LanmanServer") If I want to hit a Windows Server2003 named "testserver" with a shared folder name "maindata". How would I type the syntax?

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

Using a Inputbox, how do you make part of the display message to be bold. I know I've seen it before somewhere, maybe using Chr() function?

I am using SQL2k and Pervasive. That would explain it, thanks.

My goal is to link them, I thought you needed a index to link fields, now I know better. I have not been able figure out the rules or logic of linking fields. Sometimes I get a error saying the field is not indexed..

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?

That worked, I now have the function created, and all I do is pass the table name. It will save me a lot of hand labor, thanks.

I looked at the thread listed, but I believe that solution is for exiting tables. I do import different tables on the fly. I'm hoping there is some object table I can munipulate quickly or change the default when it imports. I don't understand why Microsoft would make a text field default to...

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...

That lead me to learning that SQL Server 2000 has the GUI version of field permissions. I was able to upgrade my Enterprise Manager to 2000 and change my permissions to my SQL Server 7.0 database. Thanks.

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...

Its looks like I was able to resolve it. The error was misleading. After I originally imported the data to create the table in SQL Server. I fixed my append problem by changing all fields that were set to 'ntext' to nvarchar. I'm now able to append the records. I appreciate your help...

I have 394mb RAM with 10gb of free c drive space. My pagefile is 700mb. I also tried it on a XP machine and I got the same error. I tried it on fresh data and it still failed. I've done a compact and repair as well. How do I determine if the SQL Server is running out of locks? I don't...