Database error when publishing with Frontpage2000

[sarah]

We have set up an Access 2000 database to load to our website using
Frontpage 2000.

When it is published what comes up on the page is a message saying

"Database Results Error

The application is listing arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another"

I've used a number of different databases including one used on another
site - any idea what I am doing wrong?

Sarah



--
Clyne Farm Centre
Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK.
Tel: +44(0)1792 403333 Fax: +44(0)1792 403339
http://www.clynefarm.com
Self catering and outdoor activities- home of the muddiest assault course in
the world!

 

[Stefan B Rusynko]

Check the DB you haven't used before against your code, and your DB connection to make sure you are using the correct DB/table




| We have set up an Access 2000 database to load to our website using
| Frontpage 2000.
|
| When it is published what comes up on the page is a message saying
|
| "Database Results Error
|
| The application is listing arguments that are of the wrong type, are out of
| acceptable range, or are in conflict with one another"
|
| I've used a number of different databases including one used on another
| site - any idea what I am doing wrong?
|
| Sarah
|
|
|
| --
| Clyne Farm Centre
| Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK.
| Tel: +44(0)1792 403333 Fax: +44(0)1792 403339
| http://www.clynefarm.com
| Self catering and outdoor activities- home of the muddiest assault course in
| the world!
|
|
|
|

 

[sarah]

Have checked the connections and they appear Ok.

The path is 'fusion' and it leads to 'fpdb/fusion new.mdb'

The page is www.gphadenandassociates.com/fusiontwo.asp

Sarah

--
Clyne Farm Centre
Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK.
Tel: +44(0)1792 403333 Fax: +44(0)1792 403339
http://www.clynefarm.com
Self catering and outdoor activities- home of the muddiest assault course in
the world!

Check the DB you haven't used before against your code, and your DB

connection to make sure you are using the correct DB/table

 

[Thomas A. Rowe]

Remove spaces from all folders and file names within the web, make sure the tables and fields names
within the database also do not have any spaces as well.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[sarah]

Have taken spaces out of field names and folders, set up a new connection -
fusion2 - and have the same result!

Sarah

--
Clyne Farm Centre
Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK.
Tel: +44(0)1792 403333 Fax: +44(0)1792 403339
http://www.clynefarm.com
Self catering and outdoor activities- home of the muddiest assault course in
the world!

 

[Thomas A. Rowe]

1. Have you had any database work on this site, if not does you host allow you to use Access?

2. Can you paste your database code into a message and post here?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[sarah]

I've sent an email to ISP as we haven't used databases on the site before.

It is a Virtual Host on a Linux machine and they say it is compatible with
Frontpage 2002 and has Sun ONE ASP.

I can paste the code but isn't it easier to look at it on the site? The page
is www.gphadenandassociates.com/fusiontwo.asp

The path is 'fusion' and it leads to 'fpdb/fusion new.mdb'

Please let me know if you need any more information.

Sarah



--
Clyne Farm Centre
Westport Avenue, Mayals, Swansea. SA3 5AR. Wales. UK.
Tel: +44(0)1792 403333 Fax: +44(0)1792 403339
http://www.clynefarm.com
Self catering and outdoor activities- home of the muddiest assault course in
the world!

 

[Thomas A. Rowe]

Sarah,

You only use Access databases on a Windows IIS server with ASP. It will not work under Unix/Linux
OSs.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================