Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that has been working, but I added another table to
display info on another page and the first one stoped working while using
localhost. No error really just tells be to see the addministrator if the
problem continues. Any ideas would be woderful.

Bill Winter
 
Did you republish the DB to the fpdb folder (on localhost)?

This is only a guess, but the error might be occuring because your ASP page
is trying to pull data out of the 2nd table, but you may not have
republished the mdb file and therefore the data can't be found, and causes
the error. (it won't just give your "No Results" message; it literally can't
find the *table* it is being asked to search in and causes a less than user
friendly error.).

If necessary, rerun the db wizard(s) and republish all the asp pages and the
database files plus the global.asa file.
 
Andrew, thanks for the response.

No I have not republished the DB.

Do I use publish to a file on my machine? I have not done this before.
 
Do you mean that you made another web page and put a new html table on
it? Or do you mean you added a new table to the database?
 
If you were working in Access and added a table. then you need to
re-import that table into Frontpage fpdb folder. Make sure the
database connection is verified. Like Andrew says, you may want to run
the database results wizard again, maybe you run across the chance to
"update" the database etc.

Then do file / Publish and select the location that you have
previously published to.
 
Clark thanks for the response, I am creating a table from a database that is
already in FrontPage. Meaning when I have Access open I point it to the
project or database in Frontpage and creat the table there. Is this the
correct way.
 
Well I am not sure I completely understand what you are doing.

If you do not have Frontpage open, but open Access, and then ask
Access to open the database by browsing on your computer to the fpdb
folder of your web, and then opening the databse that resides there,
and then making / saving changes that change the structure of the
database (like adding a table), Frontpage will not know that you
changed the database.

If you have Frontpage open, then click on the fpdb folder, then open
the database and edit it (for example to add a table) I really dont
know if Frontpage "knows" what you did to the database. I never do it
that way, so I just dont know, maybe it is ok. Or not.

I get databases into FP one of two ways. The first way is to make a
form, and then save the form results to a database using the Wiz,
which lets you create a new database in the fpdb folder and get a
connection to it.

The second is to make the database in Access and save it somewhere on
my computer, say in My Databases.. Then open FP, open the web of
interest, go to the fpdb folder and then import the database from the
My Databases folder. Again, FP will set up the connection to the copy
of the database that is now in the fpdb folder.

Now, if I need to add a table to the database, I open the database in
the My Databases folder, and add the table to it. Then I open FP and
re-import the database. That way FP understands the changes.

Realize that when you re-import, the database that was in the fpdb
folder gets replaced with the newer version in your My Databases
folder. So you want to make sure the new version contains all the data
the old one does.

Hope this results in you being at least no more confused than me :=)
 
Clark, just wanted to say thanks for your time. Your response makes since and
I will give it a try.
 
Back
Top