homepage Welcome to WebmasterWorld Guest from 54.242.231.109
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / WebmasterWorld / Webmaster General
Forum Library, Charter, Moderators: phranque

Webmaster General Forum

    
access db upload
can you upload a copy without the relationships defined
click watcher




msg:378517
 5:57 pm on Jul 18, 2001 (gmt 0)

i have a low budget site that runs an access database.
the db is updated weekly and uploaded from the local machine.
however the db is quite large and several tables are not used by the website as such, they are for local admin,

could i just export the tables that are used by the website into a new db and upload that without setting up the relationships again, or do the relationships form part of the neccesairy structure, i'm using ASP to call the database and the tables are related like catagory > product etc. but i'm thinking the SQL used to call the db bypasses the need for the tables to be related formally eg if
SELECT Catagory from products
where catagory = widget
will bring up all widgets from the products table anyway, do i need to have formally stated the relationship between the 2 within the db or am i misunderstanding how access works...
or have i just gone tooo long without sleep?

thanks

 

pshea




msg:378518
 5:39 am on Jul 20, 2001 (gmt 0)

>>or have i just gone tooo long without sleep?<<

Well, it's 2 o'clock in the morning as I write this so I must have some semblance of compassion for the bleary-eyed . . .

Please do not be disheartened here but your Q is SO specific. I have done work in MS Access and I do understand the general flavor of your request, but I cannot reply to the specific. Most who frequent probably feel the same way.

There is a Site Search feature here which often is overlooked (top left side of the upper portion), search on "access database" for some responses to earlier queries which may point you in a good direction. (You will get a half dozen discussions which may be helpful.)

bmcgee




msg:378519
 2:37 pm on Jul 20, 2001 (gmt 0)

There is no need to have the relationships in place, in order to run the queries against the DB.

Of course, it is much better practice to have them. And also you will lose any cascading delete functionality between parent and child tables.

However, for SELECT queries, you will be ok. I would also suggest compressing the new database (via Access, not something like .zip) after you have exported the tables to the new database. This should help save your filesizes.

click watcher




msg:378520
 3:01 pm on Jul 25, 2001 (gmt 0)

thanks a lot for your help,

databases absolutely not my strong point, the live db doesn't have any cascading delete functions. so no problems....

to bmcgee, great i saved over 10m of space just by compressing the db i hadn't previously used the access compact function (didn't know about it... but hey its all live and learn for me!!!!)

click_watcher

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Webmaster General
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved