VB Forum / Database Access / May 2004

When trying to open an Access type Database in VB6 using the
OpenDatabase command I get the following message
"The Microsoft Jet database engine cannot open the file <name>. It is
already opened exclusively by another user, or you need permission to

Greetings to all..
I've a simple Qs to VB (6.0) cum ACCESS DB (2000) gurus.
In VB, can I query a long table name ..E.g "Select * from [big and long tablename]" ?
if no, any alternatives beside rename it.

the following code states taht sql server does not exis
Dim GetConnectionString As Strin
Dim newitem As Objec
Dim con As ADODB.Connectio

I have an Access Database that has a Date/Time Field.  I want to read
the date into a Visual Basic variable.  But Visual Basic has its own
date type, and I don't know if its date type is the same as Access's
date type.

This thread was posted in comp.lang.basic.visual. When you use this method
(SendMessage) to move windows, why doesn't it work with Frames, Drive
Boxes, or Combo Boxes. I threw this code together. Original code for thread
is below. All other windows (controls) shown work. Windows XP ...

I've got an existing table in a database with the following setup:
Table:    tblData
Field1:    ID (Long Integer)
Field2:    LineNum (Integer)

I have an app that has been installed successfully on dozens of machines.
The app is written in VB6 (SP5), and used ADO 2.5 to connect to a local
Access 2000 database.
After connecting to the database, one of the first things the app does is a

who can help me out on a strange problem?
Ik created a small app with vb6p (on w2kp). It worked fine, and i
copied the generated .exe (68k) on my laptop (XPH)
It complained about some missing ocx'es, so i downloaded them from the

How hard would it be to port a client side vb program that currently accesses MS Access to access a FoxPro database.  Or is it possible?

Is it possible to find a certain part in a string?  I need the last part of
the string which is after the last backslash in the string. The string can
contain more than one backslah but i never know how much.
Example:

This problem may cut accross a couple of feeds so I'll try this one first:
I have some VB which opens a database file. The enviornment is XP Pro on a
domain, and the Access database is on a client and needs to be accessed by
other clients.

My vb application runs fine while it is run from VB IDE.
However, when an exe file is executed, FEW of the forms crash when user try
to click on any of the form buttons without firing the event i.e. code
behind the button_click event doesn't executed. Program run fine if mouse is

I have a very simple stored procedure:
CREATE PROCEDURE [dbo].[sto_SelectedBenefitGroup] @BenefitGroupID as
int AS
SET NOCOUNT ON

I have a VB6 program. While I run it in VB development environment, it is worked fine. But it is failed with the captioned error after making it as executable. Do you have anyone know what's wrong?

Is there some VB6 code I can use to create a MS Access type database
or do I need to own a copy of MS Access in order to create a Database
for my program?
Delphi had a database creator program I was hoping that VB6 would also