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?
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?
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...
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...
UpperCase function is exactly the type of functions I want to use in MS SQL 7.0. From the comments from rajeevnandanmishra I will not be able to use these functions created in VB. Can I create something to be used in MS SQL 7.0?
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...
That was helpful, I created my Extended Stored Procedure.
Question:
Where should I keep my dll? Or is it ok, to use Enterprise manager to point my Extended Stored Procedure to the location on a LAN drive?
I'm trying to use my new Extended Stored Procedure function in a view, but it will not...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.