VB Forum / Database Access / August 2005

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

I am using VB5 and am modifying an Access database using the Visdata add-in.
I would like to set a username & password for the database and the
documentation suggests that this is possible using the options on the Utility
menu. The only thing I can get it to do is prompt me for a ...

does anyone have any tips or links to articles that shows you how to speed up
database processing?  Just want to process information faster.  Here is the
code i typically use to connect to a database.....anyone see anything that
can make it perform faster?

I am writing a utility that reads a record in SQL, and compares it to an
attribute for a user in AD.  'Employee ID' is the attribute in question.    
The problem that I am having is that I'm trying to detect when the values
match between the employee ID field in SQL and the ...

I have a odbc driver for quickbooks.
Too make the connection I right click on "Data Connections" and go to "add
connection", I select "Microsoft OLE DB Provider for ODBC Drivers" from the
"Provider" tab, and then hit "Next". Then I select "QuickBooks Data" from the

I'm displaying an image in a picturebox which I want tosave in a SQL2000
database
How do I ?
Thnks

Using ADO, is it possible to have tables from different data sources
and use them in one query?
I am trying to copy data from a table that exist on SQL Server 2000
to a table in ACCESS MDB.

Any creative ways to get around saving a cost for a quote? I have a
situation where a customized price may change (usually does in fact), so
it's not enough to simply store a FK as the item selected. More importantly,
I have to save the price *at the time the item was quoted*. ...

i'm trying to create a form where the user can connect, at runtime, to
any odbc database of their choosing (ms access, sql server, oracle,
etc.) and then execute a stored proc or view a table.  i'm sure
somebody has already done this and posted their code somewhere but i

I've populated a datagrid from a select query with an inner join. The
query returns a recordset containing a lookup field from a related
table. The lookup field (table2.f3 in the example below) presents a
textual description of the numeric value contained in table1.f2.

I am trying to access my access database by using visual basic 6.0. I
want to use recordset method to get data from query.
I can get connection established, but I get error in further debugging
with message "arguments are of the wrong type, are

The complete error messages is as follows:
Error #-2147217900: [Microsoft][ODBC FoxPro Driver]SQL: Column 'Q787P18' is
not found.
Error reported by: Microsoft OLE DB Provider for ODBC Drivers

This post contains an apology, a question and a comment:
mea culpa: Sorry for posting here; can't find the VFP group in this
environment.
Q.  What VFP (NOT VB) code can I use to return the field caption (the value

I have an application (written using VC++ 4.2). This connects to an
Access (95) database using DAO. Now due to some issues we decided to
move to the latest JET DLL (MSJET40.DLL). This DLL uses DAO360.DLL as
the COM wrapper.

How can I view Names of All the Roles, created by user, no matter they are
granted or not ?
I tried using USER_ROLE_PRIVS but it contains only roles granted, and not
showing ungranted roles.