Access limitations

[Guest]

Hi,

Currently I hava a site thats using MS Access database - build using
frontpage. For our purposes, it was working fine, until one modification.
We were trying to modify the database while it is "live" and were unable to
do that.

Wondering if there is any work around it? Or do we have upgrade to MS SQL
to achieve this....I haven't dealt much with MS SQL, so not sure what would
be the process involved if upgrading to MS SQL would be the only option.

Any help will be greatly appreciated!!!!

Thanks,

Shikha

 

[Andrew Murray]

You should be able to edit the database off line, in MS Access and republish
it.

Otherwise, there are utilities around that allow you to edit "live".

I have used this in the past - you can edit practically any type of db
including MSSql, Access, Oracle.
http://www.restfuldevelopment.net/1clickdb/

System requirements are a Windows server, and ASP (classic) enabled.

Just upload the files and run the default.asp. You will get a box to
connect to your database and you just type in the path to it.
Eg the path to a DB on a frontpage web would be something like
/fpdb/yourdb.mdb
it's that simple; If you protected your db with a password, you also need
to enter that to open the db file online.

You are then presented with a list of tables etc, so click on the one you
want and it opens a form so you can edit the records. - very basic, but it
seems like what you need.

The above site has a demo of how it works, so check that out first:
http://www.restfuldevelopment.net/1clickdb/demo/

If its just to update a database online, the above suffices; if you're
looking for a content management system, try http://contentseed.com

Hope this helps.
I'm sure you can run it on a secure server (https://) but otherwise I don't
know how "secure" it really is - it is probably adviseable to protect the
database with a password, or as you say, move to MS SQL