Search results for query: *

Did you ever get an answer to this? I'm trying to do something similar.

The changes are the large part of the SQL. The ASP page generates the changing part, then passes it to the SQL Server for execution. A sample of the SQL is as follows: SELECT [a couple static comma separated colums], -- Dynamic part, generated by ASP, prints the following -- about 200 times...

In the DTS package we set up, the connection has a parameter for the SQL Query. We'd like to be able to change the SQL Query text on the fly, from ASP, before DTS exports to Access. I made an assumption (possibly incorrect) that this could be changed using a Dynamic Property. The situation is...

Our SQL server has some tables that we need to pivot (with transact SQL statements) then export to Access. We have some ASP that creats the dynamic SQL to view the results on the web page, so that's not our issue. Question is: what is the best way to get the resulting data to an Access database...

I'm having a very similar issue as Abhi was having in setting up the delete query. I've imported an Excel sheet into Access and Access has renamed all of the fields to generic Field1, Field2, etc. There is another table in my database with exactly the same structure, but different field names. I...

I have two tables with identical structures, both linked to different sources that are updated frequently. I would like to write a query that would show all of the data from the two tables as a single unified table with the same fields as the original table. e.g. Table1: name, phone Table2...

Chances are you've defined your relationships between the two tables incorrectly. Try deleting the relationship you set up between the two (in the relationships window, not the query) then run the query again as the INNER JOIN you listed. If that doesn't work, make sure there is an Index on the...

We're based in Seattle, but do much of our work remotely. If you find you don't need a local person, please request a quote from jake@consultparros.com ( http://consultparros.com/ ) Thanks, -Jake

Hi, I'm trying to put together a checklist that is flexible enough to have varying datatypes for the results of each checklist item. For example, I'd like a table structure that would allow me to create an editable query that might allow: Went to the Store: yes/no Bought Bread: yes/no Cost of...

To add to my post above, I can successfully send mail to the new recipient (and the e-mail is successfully forwarded to the internet account) if I select the recipient from the address book. But still, if I send email by directly typing the address, like "alias@mycompany.com", in the...

What I need to do sounds simple enough, I just can't get it to work as expected: I need to set up a forwarding alias on our exchange server, say newperson@ourcompany.com, so that all mail to this address is forwarded to another internet e-mail address (and is not stored on the exchange server)...

What do you mean by "user level security" (in case you have different ideas besides what I'm doing)? I already have the database set so that users have to log into both the front and back ends (and once they get in they can only go specific forms, not the datbase window, etc). But...

You probably don't actually want to set up passwords for each of the individual forms. Instead, use Access workgroup security to have users log in when the database is open. Put the names of students in a "Students" group (or just create a general "Student" account that all...

I have a front/back-end database. In the front-end, users can read/write/delete data in most of the tables in the linked back-end. How do I keep these same users from Importing the back-end tables (structure mainly) into a separate new Access database? Is there a way to set permissions on...

I have some web pages and a database on my local machine that were written by another developer that I'm trying to edit. I'm stepping through the Web Project Wizard to try to create a new Project that points at these pages (or just a blank project that I can add the existing pages to). I get all...

Hi-- I have a website that generates .rtf documents via MS Access, thereby creating a background MS Access process. The ASP code has the following segment that does this: ------------------ var access = new ActiveXObject('Access.Application'); var basefilename = reportName +...