Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok I have an Access database working in my site. Today I added a new table
and tried to post the update, a message came asking if I wanted to over write
the file and I said no think that it was talking about the data that was
already on the site not the new table. But after looking I see my new table
was not posted. My question is how should I be working with the database on
web server and the one on my local machine. Since the data will be changing
on web server compared to local machine.
 
Bill said:
Ok I have an Access database working in my site. Today I added a new
table and tried to post the update, a message came asking if I wanted
to over write the file and I said no think that it was talking about
the data that was already on the site not the new table. But after
looking I see my new table was not posted. My question is how should
I be working with the database on web server and the one on my local
machine. Since the data will be changing on web server compared to
local machine.
Click to expand...

Hmmm,

I am still learning about databases, but why not try this:
1. Remove the link to update the data base on the server (just comment it so
that it is easy to restore)
2. Download the DB to local
3. Update the DB on local
$. Upload the DB to server and say yes to overwirte
4. Restore the link

This way nobody can update it while you are adding the table
 
Back
Top