SQLRNNR (1/7/2015)

---

Stefan Krzywicki (1/7/2015)

---

Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the...

Wayne West (1/7/2015)

---

It's always interesting, starting out like that and learning new things. Access is a good tool and I use it a lot as my front-end to talk...

Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the outage" I'd be...

IncidentalProgrammer (1/6/2015)

---

Grant Fritchey (1/6/2015)

---

IncidentalProgrammer (1/6/2015)

---

Along with a schedule of backups, I got this from the big DBA at corporate, so I think I'm set on backups:

"The full backups would be...

The link I gave you for the data types is part of Microsoft's Book On Line for SQL Server. That and TechNet are two great resources for you, but they...

Happy New Year everyone!

Who, like me, is at work today?

IncidentalProgrammer (12/29/2014)

---

Stefan Krzywicki (12/29/2014)

---

IncidentalProgrammer (12/29/2014)

---

Stefan Krzywicki (12/29/2014)

---

I've dealt with Access databases that reach that 2GB limit. You're going to want to switch long before you reach that limit since Access...

GilaMonster (12/30/2014)

---

IncidentalProgrammer (12/29/2014)

---

Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that to restore,...

IncidentalProgrammer (12/29/2014)

---

Stefan Krzywicki (12/29/2014)

---

I've dealt with Access databases that reach that 2GB limit. You're going to want to switch long before you reach that limit since Access starts to slow...

IncidentalProgrammer (12/29/2014)

---

Thanks so much for all the help! I've added links to my favorites, and am going to pick up some of those "accidental DBA" books (my cube is turning...

I just thought of something else.

You might want to be doing some of the initial development/testing in SQL Server 2012 instead of in Access. It'll make it easier to learn...

When you switch Access to SQL Server and let the tool do the transfer, you can get really weird formatting of your TSQL. You might want to allocate some time...

I'd like to add that I got my start in IT by building small systems in Access or some programming languages while I was a secretary. That said, it was...

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now....

farrukhhameed786 (12/23/2014)

---

Hi

Thank you

I removed the join hint form the statement by replacing below. The application having no breaking or fault.

1.

2.

...