Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-30-2002, 01:21 PM   #1
DocD
Junior Member
 
Join Date: Jan 2002
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
DocD
How to distibute an updated backend database?

I'm writing a database which several friends can use (as a personal database). It will be split into a backend (.mdb) and a frontend (probably a .mde). I can then update the frontend and distibute this easily to overwrite the older version.

How can I distribute the newer backend? Each person will have their own data. If this was php/mysql I could write a php script to update the tables and add new columns, but I'm not sure how to do this in access.

Does importing a table (structure only) overwrite exisiting data? or is their another way?

Thanks.

DocD is offline   Reply With Quote
Old 12-01-2002, 12:01 PM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Look up ALTER TABLE which is probably what you would use with mysql.
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 09:18 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World