VB Forum / Database Access / September 2005

I have a great problem of the database management of my project.
the project have the following requirements:
1. have many database (.MDB files) with same data structure
2. search from all database

When I try to view a SQL Server 2000 database diagram in Server Explorer in
VS 2003, a fatal error "Microsoft Development Environment has encountered a
problem and needs to close.  We are sorry for the inconvenience." raises and
VS closes.  Sometimes this error message is raised: ...

Is this possible?  What version of DAO do I need and where do I get it
from.  TIA!

I have to assing a Number to each person who fills out this web form. The
information on the for will be places on the database and well as the
number. this number will probably start from 100 and keep adding one.
How can I do this with VB?

Outside of shipping a new database with a product update and migrating
existing data into the new database. Is there a way to update the schema of
the existing Access database. I have 2 columns that are text datatype that
need to be increased in size Can this be done. I am using ...

""Can't Open a Databaes created with a Previous Version of your
Application""
i am using MYSQL as backend but using Data Control to connect With it.
I am using True DbGrid to bind with the Data Control.

I have an Access 2002 table with a logical field displayed as a checkbox but
when linked to data grid in VB6 it shows as 0's and 1's.  Can this also be
displayed as a checkbox in VB6?

Suppose I have an appliation made in VB6 which connects to SQL2000.
The applications creates a DSN(old style) to connecto to the server.
The user has a login an a password to use the application. The server
validades Windows NT login.

I am using vb6+sp5+access 2002. there is a table in which a field named
dob(datetime) to save customer's birth date. I use vb6 to retrive the date
value to display.but all birthday are set to 1/1/1900.
I tried to use asp+ado to display it,it works fine.

Anyone have VB6 code to read in from a xml file?

hello..everybody, I need help that I want to hide my database file. can
you show me how do it?

I have a procedure that takes an existing Access database and makes a copy
of it (structure only) using ADOX. However, I have the following problems
with the copy:
AutoNumber fields in the original MDB file become plain old Numeric fields

I have a procedure that takes an existing Access database and makes a copy
of it (structure only) using ADOX. However, I have the following problems
with the copy:
AutoNumber fields in the original MDB file become plain old Numeric fields

I develop an application that can create a database on request. (the user
can create several databases with different names)
I create these databases using DAO without datacontrols. (mdb files). Now
i'd like to create a report.

Will any included data control (VB6) allow me to click on a column in
the control and then sort the records by that column?
Thanks.
Greg in Cincinnati