Access DB question

[somegirl]

I've never used Access, my DB experience is all from Oracle or MS SQL.

[Monster Dave]

SQL helps a lot and it can be used also be used in Access.

Eureka!!  I figured it out!

Ok, so here's what I did: I created a form for "Edit ID's", created a query to pull a list of all the ID's listed in the main table, then inserted a subform into the "Edit ID" form that pulls the data from the query into the subform, then I created a close/save function, and voila! It works!  ID's can be changed from within the subform!  


Thanks everyone for the suggestions! I was really having a hard time with this yesterday! 

[cyrus buelton]

I've never used Access, my DB experience is all from Oracle or MS SQL.

Access is for companies that can't afford Oracle, SAP, or any other ERP system out there.


They pay consultants a god damn fortune to build complex systems to run all their accounting, receivables, etc etc etc.

It always make the beast with two backss up and the money is wasted.


my company spent north of 8 digits on Oracle and it still make the beast with two backsing sucks.

[Monster Dave]

Access is for companies that can't afford Oracle, SAP, or any other ERP system out there.

You make Access sound like it's a bottom of the barrel program though. My department runs a lot of databases and though Access does have it's down sides, it's also a very powerful tool. What I have learned is that people who have a hard time with Access are the same ones that can't understand that it's not "if" it can be done but rather "how" it can be done.

I've been impressed by my boss's work and have learned to do much of the db design and construction on my own now. I use SQL with Access because it often works better that way, but still - I've not reached an impass yet - only challenges.

[somegirl]

You make Access sound like it's a bottom of the barrel program though.

No, no, I'm sure it's a step above Filemaker Pro.

(to be fair, I haven't used FMP in about 10 years)

[Monster Dave]

No, no, I'm sure it's a step above Filemaker Pro.

(to be fair, I haven't used FMP in about 10 years)

LOL - it's funny to think of where things were just 10 years ago...

Oh wait I started a thread about old stuff: http://ducatimonsterforum.org/index.php?topic=37685.0

[cyrus buelton]

You make Access sound like it's a bottom of the barrel program though. My department runs a lot of databases and though Access does have it's down sides, it's also a very powerful tool. What I have learned is that people who have a hard time with Access are the same ones that can't understand that it's not "if" it can be done but rather "how" it can be done.

I've been impressed by my boss's work and have learned to do much of the db design and construction on my own now. I use SQL with Access because it often works better that way, but still - I've not reached an impass yet - only challenges.

It is a bottom of the barrel program depending on how some use it.

I used to work for a commercial real estate company that used Access for everything. It was a make the beast with two backsing trainwreck. They definitely should have purchased a program to meet their needs, not just use someone that new Access to create something they didn't want to invest in. Then they wondered why certain data couldn't be extracted.

I worked two summers for this large midwest commercial real estate company maintaining and fixing that make the beast with two backsing piece of shit file (can't you tell how much I like it?)

Access is viable for certain use, but when you get into complex databases..............use a real program.

Note: I despise Oracle. It is the most backasswards operating program or our BA's don't know what they are doing.



We use Access for several things, but mostly for tracking small metrics for certain departments, etc.

It just makes printing reports a lot cleaner through exporting to crystal reports, etc.


But then again, I love excel, pivot tables, and v-look up.

[somegirl]

Note: I despise Oracle. It is the most backasswards operating program or our BA's don't know what they are doing.

I think it's the latter...you need better DBA's.

[Monster Dave]

I think it's the latter...you need better DBA's.

That's what I'd say too!!

On the flip side, at least there are options!

[cyrus buelton]

I think it's the latter...you need better more DBA's.

Fixed it for you.


Oracle is a screwy program.


It sometimes does some very odd odd things that even Oracle can't explain.

It went down once for 3 days (yes, that halted a billion dollar in sales per year company from doing anything) and Oracle's programmers in India couldn't figure out the problem. Finally, someone over there after 72 hours got it working again.

Basically they did a system restore from the previous backup, so an entire days worth of work was erased since they couldn't fix the problem.

That's what I'd say too!!

On the flip side, at least there are options!

Only other option is SAP for a large scale business.

Of course you can go old school and use QAD, if anyone has ever heard of that...........


It was big in automotive mfg companies.