VB Forum / Database Access / September 2006

select * from employee with (UPDLOCK) where empID = 100
Does this statement lock the entire table or just one record (empID = 100)?

Is there a system function for MS Access DAO to count the amount of users
who are working with the database ? I want to verify the amount of
connections by my VB application by verifying each log-in and log out to the
database. However I am afraid that this might not be the best ...

Hi!!
I need to send a DataTable from vb.net to an access table, does anyone
have an example?
Regards.

I need to find way to connect SQL database via Internet. What is the safest
way to connect? I need to find way without risk of secury. Please help me out
here.

My app scans a folder for MS Access files, and I need to ascertain
whether a found file has a password protected VB Project.  My current
code is:
   Dim objAccess As New Access.Application

I need to programmatically get the SQLServer Name into my VB app space.
I know how to get it in the Query Analyzer, but need to get it from within
the vb
app.  I suspect it's in the Registry somewhere, which would be fine except

I would like to create a new Worksheet in an existing Excel file by a VB6
application.
I managed to COPY an existing Excel Worksheet by an ADODB connection and SQL
by: (criptical)

I have a datagrid that is bound to a recordset in a SQL 2000 database.
I want the user to be able to highlight the record and press a command
(delete) button to delete the record.
Currently, when the command button is pressed, it just deletes the top

(stupid question alert!!)
I just installed Oracle 10gExpress on my home machine and would like to try
to use it. Which reference should I include to be able to use the
ADODB.Connection style db connection?

I have an access database which is publicly shared (all users have full
access to the directory and file). I am trying to insert data using a query
into a single table with no connections, but it keeps on coming up with a
"must use updatable query" error. I have tried the sql in ...

Hello and God Bless,
I am stumped trying to get a simple xml database replacing certain data
with other data programmatically. This is what my xml looks like.
****************************************

I am writing a VB6 app that will search a folder for MS Access
databases - anything from Access 97 to Access 2003 - and then analyse
various things (in system tables, queriess, VBA code, macros, etc).  I
do not need to analyse any of the table data.

My VB6 application opens and after some processes closes ADODB.Connection
several times on the start. After the application finally started I'd like
to have 1 single connection.
If I use sp_who2 stored procedure in MSSQL Enterprise Manager I see 2 open

I have a customer that is operating over a WAN on a T1 line.  They are
experiencing unsatisfactory performance.  (they have tried using ODBC
and OLE-DB connection) They gave the application 30% of the bandwidth a
put a monitor on it.  It never used more than 10% of the available

I've this SQL
SELECT Item1,Item2,Item3,
             CASE WHEN Item4='-99999' THEN NULL ELSE Item4 END AS
[IFMISSING(Item4, "NULL")],