Access database records - where did they go

[annettem]

I have an Access database that I have created and entered 10 employee
records in it. I then inserted the database in my FrontPage web. I am
able to create a form to allow for entry and a form to display the
records. When I add a new employee, the process is successful. When I
display the records, the process is successful... I see all the records
- the 10 that I started with as well as all the employees I have added.

When I try to access the database vial Access and look at the table, I
only see the 10 employees and none of the newly added employees that
were done via the web page.

I hope to use a FP database where I can collect work order information
and use those requests to initiate a work order in a more detailed
database on our network.

I can see the employees have been added by the database results page,
but don't see them when opening Access alone.

 

[Thomas A. Rowe]

You have to download/export the database back to your desktop to use with the Access application.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[annettem]

Thank you for your prompt reply. I would like to have a work order
database where a user makes a request via the intranet and the item is
entered in a database. Then the work order becomes assigned and work
performed. I was thinking that I could have the database in the fpdb
folder and then have that table linked to the more extensive database
that would allow the Maintenance department to function. Is that not
how this process works? Is there another technique I should be looking
at?

What about databases that are currently on our network that a user
could query data from - for example we have a database that lists job
descriptions along with benefits information. That database is on our
network. How would I set up the database results query to show
information from that database? Do I need to create a system DSN? Is
there a site that could explain this for me.

Thank you - I feel lost. I understand FP and Access but not the two
together.

 

[Thomas A. Rowe]

1. When you use a Access database on the web, you are not using the Access application.

2. You can not have the Access database being used on the web and at the same time have it open in
the Access application.

3. You would need to learn ASP and create a custom application to meet your needs.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================