Search results for query: *

I am trying to convert this code from an MS Access table to code that will be usable with an ADO connection. But I've had problems trying to figure out how to select multiple tables, inner join relationships and summing up fields from the RS.Open statement. SELECT Sites.SiteID, [To Date] AS...

This is all in VB6 by the way.

Is there a way to have the session use windows authentication rather than session.open "ADMIN", "ADMIN", "THEDB", DATE, 0? I am also using the xapi method to access accpac from outside the program. I thought I could go in with the normal string, get the user id that matches the current user...

Exactly what I needed. Thanks.

Is there a way to have an application detect the user that is using the app? e.g. Their windows login?

Looking at it again, I think it crashes every time it tries to look up a field in the record source.

I have a program that is supposed to access a ms access database, pull the information, and then post it to a MSOWC spreadsheet. If I run the code from VB6 it works fine, but when I compile it it crashes with an "unhandled exception...Access violation writing location..." When I debug the...

Well who knew. That worked perfectly. ArtieChoke you are the man. I appreciate your help! Thanks

Can anyone tell me how to create a DAO ODBC connection to a MS SQL server? I can do an ADO connection like so: Dim conn As adodb.Connection conn.ConnectionString = "driver={SQL SERVER};Server=Williamtell;DATABASE=" & sqldb & ";uid=accpac;pwd=accpac;" conn.Open I'm wondering what the DAO...

Thanks, I will check it out. Appreciate the help.

Can you tell me what the connect string is supposed to look like? I think that is where I am getting junked up the most, I'm not sure the format.

I suppose this is probably a basic question but this is what I am trying to do, keep in mind I am brand new to crystal reports and not the best VB programmer in the world. I am trying to bring up a report designed to pull information from any one of about 20 databases. The db's are located...

OK thanks.

On another note, I am wondering if anyone can tell me how to use the AccpacOrganizations object? Along the above lines I'd like some way to return the SQL database name of the company I'm in. Thanks

I have a function that executes until it runs into an inconsistency, then another form loads to supply the correct variable. The problem I am running into is that although the other form loads the primary form where the function is running continues to run. How can I pause the current function...

Thanks, that is exactly what I am looking for!

Is there a way to get a list of all the company databases and their MS SQL names using VB or is there a file accpac saves this information to?

Thanks I'll give it a whirl.

Thank you, one more question: Is there a way to do this with a DSN-less connection from a VB app?

Is there a way to return a list/names of every database that is on the MS SQL server?