Search results for query: *

Thank you, Jeffrey! I finally found the syntax for the connection string. Here's what finally worked... .Connect = SetPassThroughConnection() With the connection string being... "ODBC;Driver={SQL Server};Server=" & gvarSQLDataLocation & ";Database=" & gstrDBName &...

I cannot figure how to set a SQL pass through query built on the fly to a dsn less connection string using nt authentication. The error I am getting is "The connection string is too long" Unfortunatly, I MUST have this completed by Monday so any responses/help will be greatly...

I cannot figure how to set a SQL pass through query built on the fly to a dsn less connection string using nt authentication. The error I am getting is "The connection string is too long" Unfortunatly, I MUST have this completed by Monday so any responses/help will be greatly...

I cannot figure how to set a SQL pass through query built on the fly to a dsn less connection string using nt authentication. The error I am getting is "The connection string is too long" Unfortunatly, I MUST have this completed by Monday so any responses/help will be greatly...

I'd like to publish an Access97 report to an Intranet site using VBA. Has anyone done this or have any suggestions for me? Thanks!

Thank you so much for the example!

I have looked all over the place. Does anyone know what MSDN cd the office developer's toolkit is on? I've tried #0743 and installed the tools (not even sure if this is the right cd!) and when I open the addin's in 2000 there are no add in's listed. I'm getting desperate... Any help is very much...

Are you saying that scheduler can automatically close your application for you too? How does it know when your process is finished? I have it open the app (via the command line) and then when my process is done I exit the app via code. (docmd.quit) Is there another way to do it? New options are...

The way I have handled this is to set up Norton or Windows scheduler to open your application at a specific time, then on open of the application write some code to check for the time. If the time is beteen 3:55 and 4:05 AM then execute your process. Hope that helps!

Couple of questions: 1) Does anyone have the code using ADO to relink tables autmatically upon app open? 2) Anyone know the MSDN CD that the Developer's Toolkit for 2000 is on? I've looked all over and can't find where it's supposed to be! The last one I've tried was #0743 but after I ran the...