create table using access 2000 connecting to SQL Server 2000

MS Office Access


  • 1. Expression Queries
    Are you using the query grid (view) to build the query or are you doing so in the SQL window? Can you post the SQL text (View: SQL) of the query that works? I suspect you are using an "totals" (aggregate) query and have not included GROUP BY clause for any fields you are not aggregating. -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . "Engels" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ... > > I have a query that uses an expression to add and multiply several fields > in > the same table. > > ie [Table1] ((Field 2 + Field 3) * (Field 4)) > > This workks fine except i am unsure how i now use this data > > I can't include anyother fields to group by in the query (ie to sort by > Field 1 the Primary Key) or it will not run and produces an error msg > saying > "You tried to execute a query that does not include the specified > expression > ('as above)' as part of an agregate function > > I want to use the result of the query to display on a form based upon a > select from this query on a field in the same table that this query runs > from. >
  • 2. Can I append to 2 different tables?
    I have a database where the salespeople enter general info regarding a new order. They then click on a button that runs an append query which appends the data from the current order into a table located in a separate database. Is there a way that the append query can append data to 2 separate tables, i.e., some fields would be appended into tblOrders and some fields would be appended into tblMfgData? I don't think that's possible, so if not, how can I accomplish this? Would I need to create a button that runs 2 distinct append queries - one to append data into tblOrders and another to append data into tblMfgData...or is there a better/easier way to do this? Thanks for any help, Darrell
  • 3. Current date less 2 months
    Our current function is ... EndDate() >= Date() ... which is used to screen out any results prior to today's date. We would like to modify this so that instead of today's date we would use the date 2 months prior to today's date, so that, for example the EndDate() on 1/22/07 would be 11/22/06. Would appreciate help on the format for this. Thanks in advance! Rick
  • 4. Query with multiple fields and search combinations
    I assume you will be creating a form with fields for A,B,C etc. that the user can fill in their query criteria. You would need to construct a query with all the notNull field strung together with AND clauses Select * from Table1 WHERE A="x' AND C="y" AND F="z" "LTrahan" wrote: > I want to create a query (if possible) that would search one table for fields > A,B,C,D,E, & F. A user will enter the values for these fields. Not all > fileds will have a value entered, they will be null. An example may be a > search for A, B, AND C (where each record contains values matching each--not > one record with A&B, then another with only C, etc...). Another for only E. > Another for A & F, etc... > > Would creating a query that would: pull all records matching A, then a > subquery pulling all records out of that initial query that matches B, then > another subquery that pulls records from the first subquery to find matches > for C, etc... work? > > I am stumped!
  • 5. Difficulty in downloading Eboot.bin using Jump code
    I have difficulty in downloading Eboot.bin to SMDK2440 using Jump code. The downloading address which i provided in Jump code (to copy to SDRAM and to flash) is same as that in Eboot.bin Image start in WINCE. Is there any difference between .bin file generated in WINCE and Code Warrior. Because Jump code i developed using code warrior. I also have doubt whether i hv to download Eboot. bin in WINCE thro Ethernetonly to target device.

create table using access 2000 connecting to SQL Server 2000

Postby Q2hyaXM » Sun, 13 Jun 2004 02:41:01 GMT


I have created an Access 2000 database which links to all the tables on a remote SQL Server 2000 database.

How do I write the sql statement (or modify the sql statement generated in the query design mode) so that in a create table statement the table is created on the server?

currently any unmodified create table statement will create it on the local acess database.

I'd appreciate how to create the tables on the actual server and have the linked connection automatically be generated. Is this possible?

or should I be developing in Query analyzer or the query builder in enterprise manager?

any other suggests to a development architecture would be appreicated, thank you

Similar Threads:

1.Access 2000 connected to a SQL Server 2000 Database


I have an Access 2000 application which uses tables on a SQL Server 2000
database.  I am having a problem, where the main form is not automatically
generating a primary key when I enter a new record.  I need it to do it
automatically as controls on associated subforms deoend on this happening.

Does anyone know why this is happening, and what I should do to rectify it?
And if so, could you point me to an article that shows me how to fix this.

Thanks in advance.


2.Using Access 2000 .adp with SQL server 2000 database problem

I have an Access 2000 .adp file that is connected to a SQL Server 2000 database.  When I try to create a new view or table, I get a "You do not have exclusive access to the database at this time, your changes will not be saved."  Or something very similar.  The thing is, I am the only in the database, except maybe the administrator access on the server.  Is that the problem?  Or is it something else?  It seems like I should be able to create a view without a problem.  Any thoughts/recommendations would be appreciated.  I have tried the KB and nothing is there.  Or even is there a better place to ask .adp questions.  Thanks!

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 2 guest