Ken@Work (4/6/2010)

---

I use MSAccess for our front end. Most application have direct access to the server but a couple can run from laptops without a network connection. It...

Ken@Work (4/6/2010)

---

This is off topic and I apoligize.

I see that you created an SQL query on the fly and executed it.

Would you know where I can find a good (complete)...

I generally use a Tabbed form with single buttons for opening the forms and reports.

Each tab is used to group the reports and/or forms by classification.

Just as I thought.

Access is a great frontend development tool.

I have been using Access with SQL 2000 for over 7 years.

I have developed several applications using Access mdb's and mde's...

When you are using your Access 2003 ADP Frontend connected to the SQL 2008 server:

1) Can you create a view from the Access Frontend?

2) Can you modify an existing view...

Sorry.

What I was trying to say is:

To my knowledge there is no version of Access that can connect to SQL 2008 using ADP.

Access 2007 can connect to SQL 2005 using...

Which version of Access are you using?

If you are using SQL 2008, I am not aware of an Access version out yet that uses ADP.

Just a thought. Do you have access to SQL Reporting Services? If so, you can create a report and have it distributed on a scheduled basis.

sentiant (10/20/2008)

---

It sounds like M$ is giving us another hard boiled egg. I'm very disappointed in 2005 to begin with, as 2000 had features that aren't even native to...

Jeff Moden (12/14/2009)

---

Heh... no they won't... no one will give anyone the time until they actually become a problem, at which point, it...

Maybe this will work?

@query_result_separator = char(9)

Another great web site with "How To" examples is: http://www.rogersaccesslibrary.com/index.htm

Also check out the "Other Developer Libraries" link on his home page.

If you have questions on How To do something in...

Helen Feddema has written several books on Access Automation and she has a great web site with her articles and code samples.

Try going to this link and then search for...

DougGifford (11/13/2009)

---

Markus Jägerskogh (11/12/2009)

---

If you need to do it by dynamic code you are boulding the parameters for sp_executesql incorrectly.

Short example:

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

DECLARE @CountSQLQuery varchar(30);

SET @SQLString = N'SELECT...

Markus Jägerskogh (11/12/2009)

---

If you need to do it by dynamic code you are boulding the parameters for sp_executesql incorrectly.

Short example:

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

DECLARE @CountSQLQuery varchar(30);

SET @SQLString = N'SELECT @result...