|
|
| Author |
Message |
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
 Posted: 05/02/03 - 15:58 Post subject: Database App
|
|
|
Greetings 
I want to mess with creating a database for my office...I don't have the MS app tho. Openoffice. org doesn't offer a db app and I looked at mySQL and it is beyond my capabilities :p
Anyone have a copy of the MS one that I can FTP to?
|
|
|
Back to top
|
|
|
|
 |
khrath
RealPoor Master of Posts
Joined: 11 Oct 2002
Posts: 8750
|
|
Posted: 05/02/03 - 16:02 Post subject:
|
|
|
|
If I can figure out mysql, anyone can.
|
|
|
Back to top
|
|
|
|
Are you skilled mage or a hardboiled warrior in search for most suitable guild to join?
Or if you're already guild member ready to share some real PvP experience…
» Join the Guild Wars forum now! «
|
|
|
|
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
|
Posted: 05/02/03 - 16:07 Post subject:
|
|
|
heh, Khrath, my talents lie elsewhere :p
I can't even figure out how to start using it..it looks like programming stuff, tho..and while I did take c++ and datastructures as electives a few years back, I can't remember a f*****g thing about them 
|
|
|
Back to top
|
|
|
|
|
khrath
RealPoor Master of Posts
Joined: 11 Oct 2002
Posts: 8750
|
|
Posted: 05/02/03 - 16:15 Post subject:
|
|
|
|
I have no training in coding at all =p
|
|
|
Back to top
|
|
|
|
|
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
|
Posted: 05/02/03 - 16:20 Post subject:
|
|
|
oh sure..make me feel like a blonde now...<sigh>
FINE..I will read the docs this weekend...and then when I post on Monday that I still can't figure it out, I don't wanna hear shit :p
|
|
|
Back to top
|
|
|
|
|
Bait Masterson
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3842
|
|
Posted: 05/02/03 - 16:33 Post subject:
|
|
|
|
you can create a database in access that behaves like any other SQL database, not too hard.
|
|
|
Back to top
|
|
|
|
|
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
|
Posted: 05/02/03 - 16:42 Post subject:
|
|
|
/bonk Bait
I don't have Access, that's the problem. And..I've never used it, but from what I have heard, it's easy enough...
|
|
|
Back to top
|
|
|
|
|
Bait Masterson
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3842
|
|
Posted: 05/02/03 - 16:51 Post subject:
|
|
|
|
use your extensive connectiosn to get a copy, the copy protection on office 2000 is just a CD key.
|
|
|
Back to top
|
|
|
|
|
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
|
Posted: 05/02/03 - 17:09 Post subject:
|
|
|
:p
I am trying....heading up to Harvard next weekend for Mother's Day...worst case, I can likely procure one up there...
|
|
|
Back to top
|
|
|
|
|
Kurel
RealPoor Sensei
Joined: 11 Oct 2002
Posts: 1877
Location: Cali
|
|
Posted: 05/02/03 - 20:46 Post subject:
|
|
|
Someone had office xp up on r00tus's ftp.
You can also make one using VB (about the only thing VB is good for is databases).
In reality it only takes a whopping 10 clicks to make a DB in VB, it isn't too difficult, even for blondes. 
|
|
|
Back to top
|
|
|
|
|
Occulis
RealPoor Jedi
Joined: 11 Oct 2002
Posts: 13293
Location: Moral Relativity Central
|
|
Posted: 05/04/03 - 12:59 Post subject:
|
|
|
Spending 4 hours learning SQL syntax (which you'll end up learning to mess with MS-Access anyway) will pay off one hundredfold.
I'm going to type this next part in all caps, because it's true:
MS ACCESS LOSES RECORDS
MS ACCESS IS NOT BACKWARD COMPATIBLE 99% OF THE TIME
MS ACCESS ADDS "EXTENTIONS" TO SQL WHICH DESTROY DATA
MS ACCESS LOSES RECORDS
MS ACCESS FORGETS RELATIONSHIPS
MS ACCESS WILL KEEP YOUR DBA UP TILL 3AM ON A FRIDAY NIGHT, UNPAID, OVERTIME.
ARE YOU THE DBA?
Sincerely,
Elavis Q. Rumplebuns
|
|
|
Back to top
|
|
|
|
|
eqchanter
RealPoor Sensei
Joined: 04 Dec 2002
Posts: 1543
Location: tennessee
|
|
Posted: 05/06/03 - 08:15 Post subject:
|
|
|
| Dunn wrote: | Spending 4 hours learning SQL syntax (which you'll end up learning to mess with MS-Access anyway) will pay off one hundredfold.
I'm going to type this next part in all caps, because it's true:
MS ACCESS LOSES RECORDS
MS ACCESS IS NOT BACKWARD COMPATIBLE 99% OF THE TIME
MS ACCESS ADDS "EXTENTIONS" TO SQL WHICH DESTROY DATA
MS ACCESS LOSES RECORDS
MS ACCESS FORGETS RELATIONSHIPS
MS ACCESS WILL KEEP YOUR DBA UP TILL 3AM ON A FRIDAY NIGHT, UNPAID, OVERTIME.
ARE YOU THE DBA?
Sincerely,
Elavis Q. Rumplebuns |
have never had that problem. any of them. i have close to 35,000 records in my database at work. thats not to big considering companies like fed-ex are in the millions and use ms access without those problems.
the thing about access loseing records it dont have a good undo. so if you make a mistake or dont know the program very well it can be a pain in the ass. also alot of times access may look like it dont have the records but even the slightest fuckup in your filter/form/qry etc can filter everything. access has tools to prevent this from happening to.
access wont forget a relationship unless you do something to alter the key fields or alter the field relateing to your other form. creating a one to many relationship for example then adding to the one will make the relationship f**k up
if you want a free access just dl it from kazaa
|
|
|
Back to top
|
|
|
|
|
Bait Masterson
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3842
|
|
Posted: 05/06/03 - 12:13 Post subject:
|
|
|
|
You using MS Access the polish version elavis?
|
|
|
Back to top
|
|
|
|
|
principessa
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3149
|
|
Posted: 05/06/03 - 12:20 Post subject:
|
|
|
hehehe...
I want Access so I can try my hand at creating a database for my office is all. The school district I work for won't fork over the money at this time of year, unfortunately.
I don't have a ton of information to put into it just yet. Would be less than 200 records, each with about 20 fields of info right now. I am thinking it would make MY life easier.
And yes, Elavis, it would be worth it, I suppose--will consider looking at it again....
|
|
|
Back to top
|
|
|
|
|
eqchanter
RealPoor Sensei
Joined: 04 Dec 2002
Posts: 1543
Location: tennessee
|
|
Posted: 05/06/03 - 12:25 Post subject:
|
|
|
access is really easy to use. even the vba stuff.
data entry is easy to. you can make froms to enter from or even do it in excell and import it.
just out of curiosity what kind of database are you using. are you makeing reports and query all the time or just storing data. for 200 entries id just use a spreadsheet for now untill you are using multiple data sources and have lots of entries. or need reports ect.
i would upload office xp but with my luck i would get caught
|
|
|
Back to top
|
|
|
|
|
Smin
Luke Warm
Joined: 11 Oct 2002
Posts: 163
|
|
Posted: 05/06/03 - 13:06 Post subject:
|
|
|
|
I use Access also and haven't had any problems with it yet.
|
|
|
Back to top
|
|
|
|
|
Tempors
Can't Stop Posting
Joined: 16 Oct 2002
Posts: 512
|
|
Posted: 05/06/03 - 18:44 Post subject:
|
|
|
| eqchanter wrote: | | Dunn wrote: | Spending 4 hours learning SQL syntax (which you'll end up learning to mess with MS-Access anyway) will pay off one hundredfold.
I'm going to type this next part in all caps, because it's true:
MS ACCESS LOSES RECORDS
MS ACCESS IS NOT BACKWARD COMPATIBLE 99% OF THE TIME
MS ACCESS ADDS "EXTENTIONS" TO SQL WHICH DESTROY DATA
MS ACCESS LOSES RECORDS
MS ACCESS FORGETS RELATIONSHIPS
MS ACCESS WILL KEEP YOUR DBA UP TILL 3AM ON A FRIDAY NIGHT, UNPAID, OVERTIME.
ARE YOU THE DBA?
Sincerely,
Elavis Q. Rumplebuns |
have never had that problem. any of them. i have close to 35,000 records in my database at work. thats not to big considering companies like fed-ex are in the millions and use ms access without those problems.
the thing about access loseing records it dont have a good undo. so if you make a mistake or dont know the program very well it can be a pain in the ass. also alot of times access may look like it dont have the records but even the slightest fuckup in your filter/form/qry etc can filter everything. access has tools to prevent this from happening to.
access wont forget a relationship unless you do something to alter the key fields or alter the field relateing to your other form. creating a one to many relationship for example then adding to the one will make the relationship f**k up
if you want a free access just dl it from kazaa |
Access does have problems , the ones Dunn describe.
It was never made for high end database use.
(Fedex does not 'use' access. They link tho it, to MS SQL 2000.
Many companies do this, because for long time there were working controls in Visual Studio 6, or CystalReports. That has changed with Visual Studio .NET tho)
Access normally falls apart around 70-80Meg range. Depends on amount Tables/records , version.
You get to around that size, and it will do what said Dunn.
Just put a small MS sql server.(personal version) Make the tables. Link it into Access. You're back in business.
For what principessa wants to do. Access will do just fine. She doesn't need to learn mysql or any other SQL servers.
Just grab it from any filesharing thing. Like kazza or whatever. Scan for virii first tho. MS Office XP Pro. is best to get.
|
|
|
Back to top
|
|
|
|
|
eqchanter
RealPoor Sensei
Joined: 04 Dec 2002
Posts: 1543
Location: tennessee
|
|
Posted: 05/07/03 - 08:53 Post subject:
|
|
|
|
maybe ive just had good luck then. but have never had any problems with it
|
|
|
Back to top
|
|
|
|
|
|
|
