Form usable if Access is not installed?

[kelemvor]

Howdy,

I have created a very small DB that has a form to enter data into the DB. I want to put this out on our shared network drive so anyone can enter data if they need to.

Problem is that not everyone has Access on their PCs. Is there some way I can take the form and make it a stand alone application so anyone can bring it up to enter the data and not have to install Access on all the people's PCs?

Or maybe some way to create a web page type front end that could be used to access the MDB file?

Just looking for any options.

Thanks.

 

[boblarson]

You can't do up an Access form that will work on a computer without Access installed. If you have the Developer's Edition, it will allow you to create Access databases and install Access (the runtime version) on a user's computer so that they can use the database (they can't create anything with that installed version).

However, there are a few options available to you.

1. You could create a web page that is connected to the database and can add/edit information. I use FrontPage to set up the necessary connection information and programming.

2. You could use the full version of Visual Basic (if you have it available) to create a program you install on the user's computer that will be able to access the backend database. This requires quite a bit of programming.

3. There may be other ways that I'm not mentioning here. If there are, I just can't think of them at the moment.