VB Forum / Database Access / December 2004

hi hope some one can point me in the right direction
i have a simple vb app that querys a oracle database for example
select distinct(fullname)
from nametable

I have secured a database with an passwort. From VB6 users can access the
data, read and write. But I have the problem to run the reports which are
stored in the Access2000-database.
How should be the syntax to run them?

I have secured a database with an passwort. From VB6 users can access the
data, read and write. But I have the problem to run the reports which are
stored in the Access2000-database.
How should be the syntax to run them?

I would like to open a database (Access Database "c;\test.mdb") with VB6.
How do i do?
i tried  :
dim cmp as database

For no apparent reason my programme comes to a dead stop when it runs on
computers with Windows XP Service Pack 2 installed. I am not  sure why
because it runs excellent on Win98 and Win2000 computers. As far as I
can trace it, the program hangs randomly and on an instruction ...

Hi to all,
I've a little problem.
I've some secured MsAccess databasesat level user, and my system.mdw file
with user definition is on a shared path.

Windows 2000 Professional installed with Service Pack 4.
MDAC 2.8 installed.
Visual Basic 6.0 installed with Service Pack 5.
SQL REPLACE function executes fine in a Access 2003 Query window with an

My query will just generate a number result.
The SQL is "select max(number) from table".
How to get the result to display in a specific textbox?
Thanks,

Is there a tool available to easily develop a connection string?  I have a
customer that can connect to the database from the host machine but not from
a client.  I have connected with my SQL Server database both on the host and
from a networked laptop but as I remember it I used ...

Can anyone please give me an example of the VB code required to create a temp
table in MS SQL Server.  I am creating a mult-user application so each temp
table must have a user-only scope and must also be visible to other parts of
the application.  

my self avinash
i m developing one application in vb 6 and sql server 7
i have one table name - Salesvoucher which has fields like
voucherno,voucherdate,debitto,creditto,amount.

Using VB6, I want to read barcode data into an Access 2000 DB.  What do you
get when you read a barcode? Text or numbers.  How do you define the field
were the data would be stored?
Thanks in advance,

Hi, How to do this:
Create a disconnect recordset and bind it to serval text box controls, so if
user change the text box content, it will auto update the disconnect
recoreset? thanks...

Is there any upgrades to vb6  to make the IDE have MDI tabbed document
interface like VB.net
or Sliding Docked windows for the toolbar property window and others
windows.

Hi to all,
I've a little problem.
I've some secured MsAccess databasesat level user, and my system.mdw file
with user definition is on a shared path.