Search results for query: *

I am trying to pass a simple parameter to a stored procedure from vb6 and recieve the above error. heres the vb bit: Private Sub Command1_Click() Dim cnn As Connection Dim rst As Recordset Dim Command1 As Command ' Instantiate the object variables Set cnn = New Connection...

Does anyone know of a fix for this----can't use this method in Access2000

I need to add a header and footer to a text file. I have the header and footer done using transact but, I don't how to attach the header and footer to the text file (csv). Is it possible using transact? what i want to be able to do is open the text file using transact sql and to paste the...

I have an import routine in Access2000 that keeps failing when it encounters records that contain apostrophies in it. When I get rid of the apostrophies, the import routine works. (I am working with text fields.) Has anyone come across this problem or knows about a fix for this to allow for...

If I had a table for example called Authors which has a field called Topics <Art,Science,Astronomy,Geology> How can I count all the commas and remember their positions? I want to extract individual topics and then append them to another table. I dont know how to look for commas in a string...

I have FileMakerPro 5 databases on Apple Macintosh computers which I would like to import data from. I created an ODBC connection to do this successfully. I can use Microsoft Access and import the data successfully however, when I use the same data source with SQL Server 7.0 it doesn't work...

Or knows where to get hold of a copy. It has discontinued on the Apple platform.

I need to extract the results of a view to a table in the same database. The table has exactly the same column structure as the view. I tried to create a DTS package to do this but, you can not see views when creating a DTS package(only tables are visible). can someone help?

I need to import a csv file to a table that already exists on SQL Server7.0 on a regular basis.<br><br>I have tried using the import wizard but had no luck. How do I specify the table on SQL Server that will store the data held in the csv file?<br><br>I tried reading the csv file from Excel and...

I have reference field that I need to filter some records based on two different criterias. <br><br>For example, if I wanted to filter for reference numbers that end with 'zzz', how do I specify the criteria ('*zzz' as the criteria does not work)?<br><br>For example, if I wanted to filter for...

I am having problem trying to do calculations in a view.<br>I am trying to divide the values in one column by a value in another column. <br><br>I have no problem adding, subtracting or multiplying columns and receiving the correct result however, when trying to perform a divide calculation I...

I have a problem enabling a client to write, edit and make updates to a database. The client has full permissions to edit and update the database. When trying to edit a record a message comes up saying this recordset is not updateable.<br><br>The client is able to access and view the relevant...

I have a client with relevant permissions to access a database based on NT security. Every possible permission has been granted to the client (NT Login Account)for the database and database objects. <br><br>My client can login and see tables and views, however cannot update or edit any records...

You are right, thankyou for your help. Reinstalling service pack 4 fixed the problem.

I have a fresh copy of NT4 Server installed on Pentium III 450MHz machine,with 128MB RAM, 2048GB NTFS partition and service pack 3,4 installed. The graphics card (ATI) and NIC card were successfully recognised. I can see the network successfully, however, I can not get the new NT Server machine...

I have a fresh copy of NT4 Server installed on Pentium III 450MHz machine,with 128MB RAM, 2048GB NTFS partition and service pack 3,4 installed. The graphics card (ATI) and NIC card were successfully recognised. I can see the network successfully, however, I can not get the new NT Server machine...

I am having great difficulty in creating a form to read and write to our backend database on SQL Server 7.0. My front-end tool is Omnis Studio which offers cross-platform enterprise solution capabilities. When creating forms using Omnis data files, I don't have a problem.<br><br>However, when...

We have a Dell Power Edge 4400 server. Windows NT Server installed successfully. The system reports no faults and appears to work beautifully. <br> <br> However, when you connect it to the network we have a little problem. The new server can see the network, we can copy files from the server to...

I am having problems linking to SQL Server 7.0 from a third party application. The error message tells me that the data source name was not found and that no default driver has been specified.<br> <br> I have noticed that there is a odbc.ini in the Winnt directory. Is this where you are suppose...

Yes it is possible!<br> Install Acces97 upsize wizard<br> Go to Tools,Addins,SQL Browser