VB Forum / Database Access / March 2008

how to create a access table during run time from vb 6.0

Hello. I am using ConvertReportToPDF in an application and would like these
PDF files to be printed's protected editing and copying. Is there any way to
do this? Thank you.
Ana Paula de Freitas Soares

I've Googled around but can't seem to find what I'm looking for.
I currently using this SQL statement to retrieve some info from two
tables in an SQL Server database.
SELECT Projects.*, Customers.Name as CustName

I need to retrieve some records from an MS Access database where some
of the data fields contain special characters (primarily the single
quote - chr$(39)). This is not just a simple "import" of data; I need
to selectively retrieve the records. I'm trying to do this by

Is there a way to change the Database Source at run time in the Microsoft
Data Report Designer? If so. How?

I have installed Visual Basic Express 2008 on a Vista HP machine, and I wish
to add a data source to an SQL Server database which is set up as an ODBC
System DSN on the machine.
However, when I click 'Add new data source', I only get the option of

I have VB6 application which connects to SQL Server 2000 (installed on the
developer machine) database.
I use this code to connect:
strConnectionString = "DRIVER=SQL

Hi, sorry for what will most likely be seen as a noob question, but
here we go.
in SQL 2000 i have a Stored Proc, (lets call it sp_xxx)
this stored proc requires three pramaters to run as shown below,

sorry for cross posting, but I believe this is the right newsgroup for
it.
I've installed vb6 under admin on vista 64bit edition. I can see the
ado control on the form, I can see all the methods visible. except

As I understand queries straight out of access must be changed a little in
order to work with ADO? I didn't have to do this in DAO but the same query
does not work with ADO. So Can someone point me to some basics on how to
change this query so it works with ADO?