VB Forum / Database Access / March 2005

Howdy All,
I'm not sure if this is the right group for this question, but
hopefully, if it isn't, someone will point me in the right direction.
Now, on with the show.

I heard that there is a way around the 256 character limit that Access has.
I have a form with VB on the front end, Access on the back end.  Any ideas?
Thanks.

Is there a recordset function I can pass a fieldname to, to check if it
exists? Or do I have to roll my own?  Thanks.

I've created a web page in ASP using vbscript with ado objects,
I'm testing it in a pc with Xp Pro and IIS 5.1,
I've not setted a Data Source Name in "ODBC data administrator"
The DB is an MsAccess file.

I am trying to execute an SP which contains cursors etc....but when I create
the RS using ADO, I seem to get an error?
Is there something wrong with executing SP's of this type through VB using
ADO?

I have a VB6 application that performs various SQL tasks.  I am using a
progress bar when data is being inserted into the database.  This works
well.
However, I do run a few queries that take a bit of time to execute.   I' not

I'm wondering if there is a way to return a collection of all of names of the
tables in a specified database (MS SQL 2000) using ADO 2.5 in a VBScripting
project I'm working on.  If not, does anyone have any suggestions on another
way to do this?  I do not have .NET.  Thanks in ...

I'm developing an application that connects ADO with an access 2003
database. That is all ok, but now I'm thinking about do relationships
between tables to have relational reference when deleting and when I
whant to get some relations. I don't know how to do it, I have an idea

Can anyone tell me whether Access can import data from Clipper DBF file?  If
so, which versions of Access can do this?  TIA

I'm using dao 2.5 to delete records from dbf file.
Set dbDatab = Workspaces(0).OpenDatabase(...)
Set rst = dbDatab.OpenRecordset ...
rst.Delete

  Many a many posts on snapview.ocx I see, but not germane to my
problem.   I'm using access reports from a VB6 application, building
the MSI installer with Microsoft Visual Studio Installer 1.1.    Yes,
using the ODE license, and including the MS Access runtime.   I see

I am an Australian Secondary School teacher who is developing a VB front end
for an
access database to help automate our school's reporting process. The
programme is

Im currently working on a program that is written in VB and with it we
use DAO to connect to the Access database.
The program we created stored not confidental information, but we have
now reached the point on which we want to store this kind of information

Era Soluzioni announces the initial release of DbUpdater32 1.0
We're pleased to announce the availability of the DbUpdater32 1.0, an
easy-to-use program which synchronizes database structures using the
DbUpdater technology  (http://www.erasoluzioni.com/DbUpdater/).