# Anybody here good at 2007 MS Access? **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [June 1, 2009, 5:51am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573 "2009-06-01T05:51:29Z")\ **Posts on this page:** 11\ **Page:** 2
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 5, 2009, 8:49am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/21 "2009-06-05T08:49:50Z")
ya i figured that one out… but thanks man… when i need the relationships made (properly), and forms and whatnot, i might need some assistance by one of you more experienced fellas ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 5, 2009, 11:36am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/22 "2009-06-05T11:36:35Z")
> [@duck](#): > > part of my job is building access databases to be used nationwide. > It is on the share drive and yes, dozens of people go in at the same time and update it without problems. > > as far as the original post. a mail merge is for exporting a table into forms, letters, or envelopes. > If you want to import your excel table into access, then go to the table section of access. right click. choose Import. change file type to Excel. bam. No duck, you’re wrong. boxxa has 3 years of schooling on Access and it has no place in a professional environment. > [@boardjnky4](#): > > lol @ people still coding in VB … or maintaining code. You don’t have to write an app from scratch all the time, ya know? Also… not everyone needs to use [VB.net](http://VB.net)… especially if the application is simple and is meant to stay that way. All the code would transfer over anyway (I believe). ---
**Author:** ![boardjnky4](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@boardjnky4](https://forums.speedlife.net/u/boardjnky4)\ **Post date:** [June 5, 2009, 11:37am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/23 "2009-06-05T11:37:18Z")
> [@Jack](#): > > … or maintaining code. > > You don’t have to write an app from scratch all the time, ya know? stop making sense making fun of people is way funner ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 5, 2009, 11:44am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/24 "2009-06-05T11:44:52Z")
😛 I just finished a couple thousand lines of code. it was so easy… and pretty… and did stupid tedious stuff. ---
**Author:** ![duck](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/duck/32/7183_2.png) [@duck](https://forums.speedlife.net/u/duck)\ **Post date:** [June 5, 2009, 12:03pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/25 "2009-06-05T12:03:01Z")
> [@Jack](#): > > No duck, you’re wrong. boxxa has 3 years of schooling on Access and it has no place in a professional environment. no argument there! Access has no place as a database that needs to be used on a medium to large scale. I just make the best with the tools we are given. I’ve been trying to get a SQL server for years. We finally had a guy with a server and developer we could use. then he quit and now we’re stuck with Access. yay red tape. I feel like I’m pulling rabbits out of a hat doing VBA and Access for this stuff, but I’m using every trick I can think of to keep it running with all of the features we need. ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 5, 2009, 2:17pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/26 "2009-06-05T14:17:29Z")
> [@duck](#): > > no argument there! Access has no place as a database that needs to be used on a medium to large scale. I have anywhere from 20-150 people in these apps at a time. Thats not a large scale, but it isn’t an office with 8 people in it either. Its just so quick. ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 5, 2009, 2:44pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/27 "2009-06-05T14:44:15Z")
> [@Jack](#): > > Its just so quick. The IT statment of the year. Quick does not always mean right. If you want someone in a small business to have a small database on their computer to keep track of info, fine. Access it is but if you are still using Access to build databases for medium to large comsumers, you really need to learn SQL. MySQL, Oracle, MSSQL, etc. ---
**Author:** ![boardjnky4](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@boardjnky4](https://forums.speedlife.net/u/boardjnky4)\ **Post date:** [June 5, 2009, 4:23pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/28 "2009-06-05T16:23:16Z")
If it is an application, Oracle is usually (but not always) the database of choice. If it is a web development project, MySQL is usually (but not always) the database of choice. ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 5, 2009, 8:09pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/29 "2009-06-05T20:09:23Z")
Our shop doesn’t use Oracle. .NET, VB,SQL, Sybase, IQ… etc. Hell, we still have Foxpro apps running. Access is one of those apps everyone has Access to. Licenses for this crap isn’t free… ---
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 8, 2009, 5:58am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/30 "2009-06-08T05:58:55Z")
thanks guys… next question is… how do i make a link between tables in the same file, so every time i update 1 (or the corresponding other) field, it does so respectively in the other. also, is there a way to do this between an access and excel table? thanks ---
**Author:** ![duck](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/duck/32/7183_2.png) [@duck](https://forums.speedlife.net/u/duck)\ **Post date:** [June 8, 2009, 6:42am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/31 "2009-06-08T06:42:42Z")
> [@turbo ls1 ss](#): > > thanks guys… > > next question is… how do i make a link between tables in the same file, so every time i update 1 (or the corresponding other) field, it does so respectively in the other. also, is there a way to do this between an access and excel table? > > thanks this is access 101 Tools\>Relationships drag table 1 field to table 2 field. Change joins if necessary and/or do this in each query I’m sure you have primary keys set up in the tables… If you have keys, then you wouldn’t be duplicating fields across 2 tables, so there would be no need to update the same data across another table. You can import excel tables, but I’m not so sure you can link an excel table in realtime. And you certainly can’t input data back into the excel table. [Previous page](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573.md?page=1)