Help, using an Access 97 DB without MS Access Application 
Author Message
 Help, using an Access 97 DB without MS Access Application

I am writing a software package that uses an Access 97 Database to persist
program data. How can I make it so the user will be able to use my software
(and MDB)  without having the Access 97 program installed (Can I do it in
code)?

Thanks



Sat, 09 Sep 2000 03:00:00 GMT  
 Help, using an Access 97 DB without MS Access Application

Quote:
>I am writing a software package that uses an Access 97 Database to persist
>program data. How can I make it so the user will be able to use my software
>(and MDB)  without having the Access 97 program installed (Can I do it in
>code)?

What language are you using to write your "software package"? If it's
VB you don't need anything extra. You can distribute the components
needed to use the database from your application.

-- Jim Ferguson, FMS
   http://www.fmsinc.com



Sun, 10 Sep 2000 03:00:00 GMT  
 Help, using an Access 97 DB without MS Access Application

Well, your application should handle this.  All of the communication
between the user and the database should occur in your application.  If you
want the user to be able to get into the MDB and muck around then they will
need Access.  Otherwise all you need to do is configure the datasource and
establish the connection, Access not required.
--
John Sextro
Diversified Consulting Resources, Inc



Quote:
> I am writing a software package that uses an Access 97 Database to
persist
> program data. How can I make it so the user will be able to use my
software
> (and MDB)  without having the Access 97 program installed (Can I do it in
> code)?

> Thanks




Sun, 10 Sep 2000 03:00:00 GMT  
 Help, using an Access 97 DB without MS Access Application

I have a similar concern. I realise that my VB .EXE file can work on a MDB
file even if my users do not have Access.
HOWEVER - what if they delete the data file by mistake, or want to start a
new one. I don't want to have to recreate the whole database structure
programatically (you know field.name = "ID", field.type="longNumber" etc
etc). Is there any way I can package an empty copy of the database format
(ie containing all empty tables with relationships defined etc) within my VB
project, like a resource or form file, and package it inside the EXE, then
spin out a copy when needed?

I guess it's a long shot, but what are the alternatives?

Rgds
Ewan



Fri, 15 Sep 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Help, using an Access 97 DB without MS Access Application

2. Help, using an Access 97 DB without MS Access Application

3. Using a Data Control in VB5 accessing a user-level secure Access 97 DB

4. Accessing Usernames in Ms Access 97 Using ADO

5. how do i access a password protected MS-ACCESS db without the password

6. Convert Access 97 db to Access 2000 db in VB6

7. Converting Access 2.0 DB to Access 97 DB in VB code

8. Using MS Access 97 to Create and Manage MS Project 98

9. Open a secured MS Access 97 db in VBScript

10. Help: convert access 2.0 to access 97 using VB 5.0

11. **** Send a mailing using MS ACCESS 95 with or without MS EXCHANGE SERVER *****

12. Help - Help : Unable to quit ms-access 97

 

 
Powered by phpBB® Forum Software