[Genome] Hello UCSC Genome browser staff

[Hiram Clawson]

Good Morning Erez:

Please note, our database is normally used within MySQL.
We are unaware of the complications of loading it into
the MS-ACCESS database.  Also our tables are *not* constructed
with foreign key relationships.  Our structured relationships
are stated in a special text file all.joiner:
	ftp://hgdownload.cse.ucsc.edu/apache/cgi-bin/all.joiner
which is used by our table browser to enable structured queries
into the database.
	http://genome.ucsc.edu/cgi-bin/hgTables

Also, our database is available via a public MySQL server:
	http://genome.ucsc.edu/FAQ/FAQdownloads#download29

--Hiram

On 2007 Feb 28, , at 10:21 AM, Brooke Rhead wrote:
> ארז ליבנה wrote:
>> Hello UCSC Genome browser staff, Hello Brooke,
>>
>> I would like to download UCSC genome annotation database into an 
>> MS-ACCESS
>> infrastructure.
>> Following your instructions, I have FTPed to hgdownload.cse.ucsc.edu.
>> However, I can not proceed from there due to a requirement of a 
>> Username and
>> Password.
>> What is the best way for me to download the database and it's 
>> relational
>> structure?
>>
>> Thank you in advance
>> Erez Livneh
>> Hebrew University