Error when allowing FrontPage to create Access database

[allpoints]

Hi,

I am creating a form in FrontPage 2003. I then select the option to Send to Database. I then choose "Create Database". This results in the error 'The database column T1 is not in the currently selected database'. Has anyone been successful in having this feature actually work?

thanks

gordon
allpoints

 

[hockeylvr]

Gordon,

Did you get this question answered?
When this happened to me, I did this:

Go into "Form properties", Options For Savings Results to Database, Saved Fields and make sure that the Form Fields appear in the Database column as well.

I think this will solve your problem.

hockeylvr

 

[allpoints]

hockeylvr,

Thanks for your help. Here's the scenario:

After I get this error, I check if the MDB file was created and it fact it is, and it contains the field T1, so the error seems to be a red herring. The problem is that after the error occurs, I can't do anything more using the Form Properties dialog in FrontPage, and I have a form that doesn't work because FrontPage doesn't generate the code to map the fields in the form to the fields in the database. That's why I'm wondering if I'm missing a component or have the wrong version of something. Here are the versions:

WinXp Pro
FrontPage 2000 ver 4.02
Access 2000 with service packs
IIS 5.0, with correct extensions

Any ideas.

Gordon