Robb
Exact error messages would be good at this point and it may be possible that
their version of MySQL may not fully support the command you are trying to
perform although with an UPDATE TABLE I would hope this unlikely.
I think you probably need to provide:-
SQL statement you are trying to execute that you think is causing the
problem
URL to the script trying to do the job
Exact error that you are getting
My first guess is something about the export of the Access DB is screwing up
or set to read only or somehow the grant permissions are screwing up, but
that really is just crystal ball gazing without some more info.
If you have any possibility at all of using personal web server of better
still NT/2000 to test on your own box then I think that would be ideal, but
lets see what we can do with some more detail.
Andy
----- Original Message -----
From: "Robb Meade" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 6:23 PM
Subject: Can anyone help with this please?
> Hi there...
>
> Very new to Databases....
>
> I have been learning ASP over the last few months and have no come to
start
> using databases....
>
> My web host is WebFusion, who use a MySQL system for their database, where
> as I at home use MS Access2000...
>
> I've got it all set up so that I can export from home to the server and it
> updates the database, and also I've got a test page that allows you to
enter
> some info and it updates the database from the web - so that side of
things
> is kinda working...
>
> I've added a table this evening, as I wanted to set up a special one for
> people who register on my site, I've come across a couple of problems, and
> I'm not sure what to do...
>
> 1) Once I've exported the table, I dont seem to be able to change the
> structure of it, ie add more fields, or remove some, or what ever, I just
> get an error if I try...
>
> 2) Fields set to 'autonumber' and 'yes/no - true/false etc' are changed to
> 'number'...
>
> 3) I dont seem to be able to remove a table from the database....so now
I'm
> getting loads as I'm testing stuff, and i want to remove them...
>
> If anyone can help me at all I'd be very greatful, I appreciate this is
> probably not quite the usual sort of question you get here...
>
> Oh, and as I'm kinda new to this, if you could explain things kinda
'newbie'
> clearly, that would be great :)
>
> Thanks in advance for any help
>
> Respectfully
>
> Robb Meade
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
