Online Access Database

You will need to use ASP to make your own admin

How do I do that in Access?

http://www.viewsource.dk/cat.asp?ident=asp&page=2&catID=2

og

http://www.viewsource.dk/cat.asp?ident=asp&page=2&catID=2

Er der færdige scripts til download der viser - hvordan man opretter, sletter og redigerer online i en Access database

Jeg tror vi har misforstået hinanden, det jeg forespørger er en metode hvorpå man kan tilføje og slette tabeller (celler) i en Access Database og ikke bare poster.

what do you mean "online"? If the Access database is on a web server then you MUST use ASP or somethingsimilar to make your own administration program. I do not know of one for doing this.

If it is on a file server then you can use Access to do this.

Yes but is it possible to add tables and cells? I haven't heard of it, so I think you have to use a special program.

It is possible to Add tables and fields using ASP. You can run any valid SQL just like SELECT * .... and UPDATE ....

Could you give me an example?

the SQL for creatin a table is

CREATE TABLE MyTable (ID SHORT, TextField TEXT (40))

and to ALTER (add a field to existing table)
ALTER TABLE MyTable ADD COLUMN NewColumn TEXT (20)

Does it work in an access database? If it does, your the man...

It should work with Access

have you tried this?

It works! You have done my life much easier.....LOVE U ;)

thanks, great to hear its working