Have you checked the following:<br>
1: Do all users have the drive to the Access file mapped to the same letter?<br>
If its not on a network, check to see if the user installed the program to the default setting.<br>
2: Could the users all use the program earlier, and if not, you may...
This should work if I'm understanding what your looking for:<br>
Dim MySet(4, 4) As String<br>
Dim i As Integer<br>
<br>
MySet(0, 0) = "1"<br>
MySet(1, 0) = "First"<br>
MySet(0, 1) = "2"<br>
MySet(1, 1) = "Second"<br>
MySet(0, 2) = "3"<br>...
I found the problem, I had converted a Access Database to SQL Server and its datatypes were different from Access's so when I tried to update... it failed. Would have been easier to track down if VB had not of been giving an error that said that I was writing to a read only file.
I'm having a problem writing to SQL Server from my VB program. In one area, I can write to SQL Server on all but 3 areas, in the other area I can't write to the table at all. Does anyone have any ideas?
<A HREF="http://msdn.microsoft.com/vbasic/downloads/alphasamples.asp" TARGET="_new">http://msdn.microsoft.com/vbasic/downloads/alphasamples.asp</A><br>
<br>
It also includes the documentation for its properties. Works well for me, I can create reg. calls that will write or read <br>
from the...
I'm suffering a terrible slow down when I use the refresh command with my ADO control. <br>
Any ideas on how to get around this or what may be causing it? I happens when I'm connected to a NT box with SQL Server and then through the Novell Network going to Access.<br>
The method that I was going to use, is to import the CSV to an Access table (with commas and such left in). Then use VB to parse out the information (using the instr) to break at the commas, and populate the text boxes. Then... call out to SQL Srv, and enter the data to it. In theory its sound...
I need to convert a CSV File (beyond the normal problem of the comas, each two rows need to become 1 row in SQL Server (6.5)). Any help would be great.
I'm trying to write two programs ,one that does the updates to the database, and the other displays messages to the user in the other program that calls on the same database, and would prefer to use a DDE will display the information to the other program. I can do it using the programs on the...
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.