I can't figure out how to add another instance to SQL 2003 Standard. The only "instance' I see...

Dick Schroth (4/14/2006)

---

I'm thinking that the problem may involve finding the correct name for the SQL Server instance. It would make it easier to troubleshoot if you can install the...

GilaMonster (7/23/2008)

---

A full new instance with a different instance name, separate services, etc?

You install SQL again and when it asks for default or named instance, you give it the name...

~paul hewitt (6/11/2008)

---

Weird! I've never noticed that happening before, maybe because I usually work with linked sql tables rather than Access tables. I guess you can just delete these automaticly...

~paul hewitt (6/6/2008)

---

I think that if Access spots fields with the same name in two tables it helpfully decides to join them for you. If your primary key fields are...

jeffrey,.

I appreciate your response. Is there a command, however, that will give the product name? Like SQL 2000, SQL 2005, SQL 2008, etc.? I ran the command on what...

Where is the article?

What are the product technical differences between SQL 2K and SQL 2005 ? For example, I have recently learned that the product version of the SQL Instance I'm running is...

Scott MacCready (5/2/2008)

---

I think I mentioned earlier (not sure if in this thread), no you can't count on the ACCESS Upsizing Wizard or the SQL Server Import Wizard to capture...

Scott MacCready (4/30/2008)

---

I believe that msg is telling you that your destination database must be hosted on an instance of SQL2005. If you are trying to connect to sql...

Mitchell,

Absolutely positive reply. I appreciate you help!

2 questions:

1: Is this VBA Code? (sorry, not a programmer per se)

2: Where is the code run? on the CL? Where do...

Jorge.G (4/30/2008)

---

I see...You are right then, the documenter will not show you whether is a query or a table, may be this is the reason that seasoned developers add prefix...

Jorge.G (4/30/2008)

---

The documenter will give the record source of your reports...

If the Recod source is a query then you have to see the query definition that is pointing at.

I am...

Robert O'Byrne (3/7/2008)

---

I would start the process with the Access upsize wizard utility. Since they want to end up with an Access viewer, the upsize wizard wizard will give...

I forgot to ask about my other important question:

SQL SERVER MIGRATION ASSISTANT! (SSMA) YEAH!

Using SQL 2005 I try to run the SSMA to migrate a local .mdb with 3 tables...