Frontend VB (with access db) - backend Access

[Fuga]

Hi all,

I´m thinking of creating an application built on a database in access.

My question is:
What happens to tables that are linked to the database that will be integrated in the application.

I would like to make an application with a db that has a linked table to another database. I would like to have the records added in the application reflected in the second database.

Is that possible?

Fuga.

[Hack]

Then why incorporate Access at all?

Why not just link directly to the database that the records will be added to?

[Fuga]

Hmm,

Well, maybe I should. I´m quite new to this.

The thing is I wanted to distribute the frontend to maybe 15 users so that they should be able to input data in the backend.

I thought the database would become a part of the program once it's been compiled.

How should I go about this?'

Fuga.

[Hack]

The database is never a part of the compiled program. It is always an external, physical, file.

If you are using Access, then you would need to include the MDB file in the setup and installation package that you create unless it is parked on a network drive to which your VB front end points.

What kind of database do you need to update? SQL Server? Oracle? Something else?

[Fuga]

Thanks for your answer.

I´ve missunderstood the thing with database development. Like I said, I´m new to it.

I knew that you don´t need a database program on your computer in order to run an application built on a database, so I assumed that the database was integrated in the program.

I´m using an access database. It´s a very simple application. Basically the users should be able to add records to 1 table. I´m using it as a method for collecting ideas for a projekt.

I´ve placed a backend on a network drive, and distributed access frontends, but that excludes those who do not have access installed.

So you´re telling me that if I place the backend on a network drive and make all the data connections to that db, I can distribute the compiled application and the data will be collected in the backend?

Fuga.

[si_the_geek]

That is correct.

A VB program does not require any other software to be installed (except perhaps MDAC and Jet, see here).

To ensure the permissions for the database file are valid, see this FAQ article.