VB Forum / Database Access / July 2004

I am trying to change the Field Description in an Access App. with
linked tables (SQL). The reason is because we have many tables and
each table has more than 100 fields and it would take forever to copy
the description from original Access database to the SQL Linked Table

i have a website hosted on the internet. it uses an access
database(db.mdb) which is on the site outside the webroot. now i want
to access this mdb file from a local macine via vb. can any one tell
me how this can be done. my database file db.mdb is outside the web

Could someone tell me how i could check if my user's information (i get
infos. from a form in VB) has administrator access to SQL Server using VB?
Here is another question. I would like to copy a database from a script.
How can i execute this script in SQL Server using VB (using ...

Hello there..
I am making a program in visual basic whose backend is a dbase III file.
the problems are: when i use an ODBC driver, after some minutes, it
displays "System Resource Exceeded"; i cannot reference Microsoft Jet

I'm writing a client/server aplication with VB6. In the server is an Access Database and a COM+ dll who actualizes a table. In client side I have a listview where clients show the info stored in the table an actualize the registers.
The problem is how other clients show the ...

I have a database which has 2 tables:
TBL_Customers
TBL_Deleted_Cust
The TBL_Deleted_Cust contains a list of Customer_ID numbers that

   I am a bit new to DAO and I have been having a bit of a problem when I
try to perform a command on a Database. I try the mydatabase.execute "DELETE
FROM ........" command and other applications cannot read the database
because it is locked by the app performing the execute. Now, ...

I am using an access 97 database (I have no control of the database type)
I am using VB.net 2003 to insert data using a query (it is later in the
post) and I am also most likely updating the database via a 28k link so I
want full control over the data I send.

good am to all. thank you for this opportunity to ask about my current
problem on my application create under visual basic 6. here is my problem:
I developed a application system using microsoft access as my database
engine. i used oledb as my connection. my program works ok and ...

I would like to know if there is a way in VB to check if SQL Server is
installed on the machine from any OS (2000 pro, 2000 Server, XP, NT4...).
Any help is appreciated.
Jonathan

Hey guys,
  I have a program that I want to allow my users to simply click a button and
the program will download some pictures onto their computer for them.  I will
have a folder on my web server with the pictures, but I need to know how the

Is it possible to search for a word in an access database memo field using
ado in vb, say:
select * from mymemotable where mymemo like '*abcde*'.
The sql works if it is done in access query but not when building the vb

I'm using a Data Environment and have a connection(connection1) with 2
commands.
I am using these to query to build a report.
I can use each command successfully ONE time. After that I am not able to

I have been running a program against an Excel record set for months and
developed what appears to be a data type problem. The code I use to create
the recordset is:
'Instantiate the database and recordset

I am just starting out using ASP and ADO and right away have a problem. If I
specify the userid and pswd in the code below I can connect but I want to
establish a trusted connection(Windows Authentication).
<%