Excel move

[Mark Constant]

I moved a frontpage web from one computer to another by just copying
and pasting. When I got to the database result wizard and click next
after selecting record source it gives this error below. Where can I
change the setting which says \\web1? I can't find it in global.asa.
Thanks

Server error: Unable to retrieve schema information from the record
source 'Acct_Query' in a database using the connection string:

'DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/phonelistdatabase.mdb'.

The following error message comes from the database driver software;
it may appear in a different language depending on how the driver is
configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file
'\\web1\inetpub\inside.hancocklumber.com\webroot\fpdb\phonelist.xls'.
It is already opened exclusively by another user, or you need
permission to view its data.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)

 

[Mark Fitzpatrick]

If it isn't in the global.asa, have you checked the access database itself?
It could be that the phonelist.xls excel spreadsheet is linked to the actual
database itself, possibly as a lookup or import etc...

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Stefan B Rusynko]

Delete the global.asa, and any db in the fpdb folder (if there are any)
If phonelistdatabase.mdb (and Access DB) is what you are using File Import it to the root
- FP will put it into the fpdb folder and create a global.asa
Then verify it using Tools Site Settings Database Connections
If you are using Excel in your site as DB connect it using Tools Site Settings Database Connections Add



| I moved a frontpage web from one computer to another by just copying
| and pasting. When I got to the database result wizard and click next
| after selecting record source it gives this error below. Where can I
| change the setting which says \\web1? I can't find it in global.asa.
| Thanks
|
| Server error: Unable to retrieve schema information from the record
| source 'Acct_Query' in a database using the connection string:
|
| 'DRIVER={Microsoft Access Driver
| (*.mdb)};DBQ=URL=fpdb/phonelistdatabase.mdb'.
|
| The following error message comes from the database driver software;
| it may appear in a different language depending on how the driver is
| configured.
| -------------------------------------------------------
| [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
| engine cannot open the file
| '\\web1\inetpub\inside.hancocklumber.com\webroot\fpdb\phonelist.xls'.
| It is already opened exclusively by another user, or you need
| permission to view its data.
|
| Source: Microsoft OLE DB Provider for ODBC Drivers
| Number: -2147467259 (0x80004005)