Frontpage 2003 database acccess

J

Jdean

I have several Microsoft Access databases on my club website and am unable to
open them remotely with FP 2003 but can open all of them with FP 2002. I am
receiving this error message when trying to open them with FP2003.

Microsoft Access cannot open this file. This file is located outside your
intranet or on a untrusted site. Microsft Access will not open the file due
to potential security problems. To open the file copy to your machine or a
accessible network location.

Thanks for your help.
 
K

Kathleen Anderson [MVP - FrontPage]

You need to do as it says: copy the file to your PC (File | Export) and open
it from there. You shouldn't open databases from within your web site; it
will create a .ldb file and lock your users out.
 
J

Jdean

The reason I choose to open it on the server is that once a month I need to
open it and delete the 100 or so records so that it will be clean for the
next month. I have a dialup connection and it is faster this way instead of
downloading it making the changes and uploading it again. It only takes a few
mins. this way. I have been doing it for a year or so this way. Is there any
way to continue this with FP 2003? Thank you for your time.
 
R

Ronx

If you could get FP2003 to open the database directly on the server,
it would download the database to the FrontPage temporary files
folder, open the copy in Access, and when you have finished editing,
upload the copy overwriting the original (this is how FP2002 does it).
It really is just as fast, and is safer, to download by exporting, and
upload again.
 
M

MikeR

How about creating database admin pages to do this? Password protected of course.
MikeR 1st
 
P

p c

True. Look into an Acess DB admin soltion with ASP. Also, try a compact
page to compct your DB after many deletes. All of these are done at the
server, without download/upload.

I have used Generic DB and my own ASP based contraptions. But there are
many free solutions. Google for "ASP Access database management."

...PC
 
A

Andrew Murray

You can do that through ASP Pages.

Check out this handy tool: http://1clickdb.com/ for editing online. Uses
standard ASP.

Download, the Zip file, unzip the asp files to your web, publish all the
files and you're done. Simple & easy to edit the major types of db
files/systems including MySQL, Excel, Oracle, Access, SQLServer.

If you're on dialup this could be a bit slow; it might be faster to download
the access file, open in access, delete the records and reupload afterall,
even though you've said this is not an option for you.

The site has help files/support if you need it.

Very handy for anyone that doesn't have MS Access.
 
Top