Post by tim » Sat, 22 Sep 2001 14:24:01

I dont have microsft access, is there anyway I can use
excel when I write my visual basic programs instead of
using access, all signs point to no. I dont have $500 to
get access. Any repplacements that might work, I need
something, that will harbor thousands of names, dates etc,
with out access, and display them on a web page using ASP
or such procedures.
Any ideas?


Post by Frank Hickma » Sat, 22 Sep 2001 15:24:19

You can create and use Access databases in VB without actually owning

Frank Hickman
NobleSoft, Inc.


1. Pasar consultas a proyectos access / Convert access queries to access projects

Estoy tratando de pasar algunas consultas que usan campos de form para
filtrar datos:

por ejemplo:

select * from clientes
where usuario=Nombre_Usuario() and fecha=Form!FormSelecciones!Fecha_entrada

?Como harais esto?

(In weird English)
I 'm trying to convert a query that uses a field set in a form to use them
in a access project.
In example:

select * from customers
where user=Name_of_the_user() and date1=Form!FormSelections!date_arrival

How could I get this?

2. Row number

3. SQL data access by Access 97 and Access 2000

4. Date of the first day of the week

5. Access 97 upgrade to Access 2000 or Access 2002

6. Webserver 2.1: ndwlli_Init: Duplicate values in [AppDir] Section

7. DrWatson when jdbc access - Access violation (access to address 0x00005)

8. Corrupted Runtime solution, Can they be recovered?

9. Access to access 2000 mdb by access 97 program via VB6 and ADO

10. Access 2000 to Access 2002

11. Access accessing a Remote Server

12. Join Access SQLServer Table with Access Table

13. Access db, access project and SQL