VB Forum / Database Access / January 2006

Thanks in advance
We have developed application in VB 6 / SQL Server 7.
In LAN it works fine.
But when I want to access database of SQL server 7 from outstation / branch

I have been working with the June ctp and create all my assemblies for Sql
with out a problem. I just installed the Standard version of VS2005 and
SQL2005 on a brand new x64 bit platform. I cannot get Visual studio to
display "project type: Sql Database". I have reinstalled twice ...

I'm making requested changes to an existing VB6/SQL Server database
program.  One of the changes the users want is a checkbox to indicate
whether or not a record should appear on a quarterly report.  We've added a  
bit field to a table to hold this flag.

Is is possible not to lose batch updates in an ADOQuery (configured with
batch optimistic lock mode) when it's closed or the connection is lost? (ex:
sql server restart).
The updates will be cached until the server is back online and then applied.

I intend to store global data (data which is required by all projects)
in the workgroup db (system.mda - need compatibility to Access 2.0) as
this database is available anyway and cannot get lost (without having
more serious problems).

I wanted to access a remote database in my VB application.

If so, is it possible for the following DBMS ... SQL Server, Oracle,
MySQL, Access & SybaseASE, DB2 ???

Dear Experts,
I currently trying to use the FileUpload control from asp.net 2.0 to upload
files. The uploading of the file I would like to store it in the Access
Database. Unfortunately, I've no idea how I can do that. Can anyone provide

I have create a new table wihin access 2000 through VB6,
But how can i specify field properties like
Format
Decimal Places

Dear Group Members,
I would like to ask you about your opinion concerning the
implementation of the following schema. Imagine you have a stock of
spare parts. You can order one type of spare part multiple times,

I am doing one project.the description is as follows.
Once the registeration number of the company is enterted in the text
box, the entire details like date of starting,shres,debentures etc
should be displayed automatically.the important thing is for eg  if

Hello to evryone.
I m Vivek B PAnchal .I m new in his group.
Now I m working with one software which uses the database Proprietary
Database.

Working my way through some existing code I have come across this:
If Me![First_Run] = "N" Then
    GoTo first_filter
End If

How i Open Password protected Excel Book ?
Bellow code is without password.....
Dim oCn As New ADODB.Connection
Dim oRs As New ADODB.Recordset

I create a temporary table and keep getting 91-Object variable or with block
variable not set.  How do I reference a temp table after creating it.
Mycon.execute "Create Table #scrTable"
Set rsRec.activeconnection = Mycon

I have problem with my application.
When administrator restricts user rights to read, and doesn't give
permissions to write in C: disk (only to My documents is write allowed), how
do you handle setup of application? Then off course admin has to install