Microsoft Access

• Topics

  Started by

  Posts

  Last post

• MS ACCESS Delete records exist on the other table with condition

  I have table ZAC ZAC EDArrivalDateEDArrivalTimePNOZACMRNO 201007210918100001694ZAC|9|2010072…

  Frances L

  1 replies

  14 years, 8 months ago

  By: Pete23Mid

• erratic "Data provider could not be initialized. (MSDataShape)" opening ADP file

  Hi everyone, I have deployed a MS Access ADP file that accesses a SQL Server 2005 database. Most us…

  Eric Mamet

  4 replies

  14 years, 8 months ago

  By: Eric Mamet

• Insert into syntax

  INSERT INTO [Advision Changes AD] [ ( advertiser_name [ , advertsr_number [ , primary_address1 [ …

  varunkum

  5 replies

  14 years, 8 months ago

  By: andrewd.smith

• Access field doesn't allow data entry

  I've got a subform with 2 fields: FIELD_1 is a list field with 3 values (1,0,-1, numeric type in th…

  a_ud

  6 replies

  14 years, 8 months ago

  By: perech8

• Server: Msg 7343, Level 16, State 2, Line 1

  I am trying to insert data in remote server which is an sql server 2000 database . while inserting…

  manish_2127

  2 replies

  14 years, 8 months ago

  By: Imran Ashraf-452633

• Access 2007 Linked Table Manager giving the famous ODBC Call Failed command

  I have been working now on an Access 2007 database which links to SQL Server 2008 to import data fo…

  Rayven

  5 replies

  14 years, 10 months ago

  By: Rayven

• Alter multiple Table

  Hi, Is there anyway to alter multiple tables within the same database like generating script or so…

  aparnasantoshnair

  1 replies

  14 years, 10 months ago

  By: Lowell

• convert string in a line feed with repeat characters into array

  how to get this line into arrays; ZB5|BONEBONE|SDES|20081121|1536|||ZB5|NONE|SREQ|20081121|1536||| …

  Frances L

  7 replies

  14 years, 11 months ago

  By: Chris Quinn-821458

• create table and indexes in the same command

  how do i create the table and indexes in the same command... create table employees (emp_number int…

  roy.tollison

  6 replies

  14 years, 11 months ago

  By: Philipp Post

• Find out whether a column is identity

  Hi, I have a SQL Server table that is a linked table within Access 2003. How can I find out in vba …

  Alexander G.

  1 replies

  15 years ago

  By: WILLIAM MITCHELL

• Help With Modifying this Code

  Hey guys, I'm new here. But I hope you can help me with modifying this code (in regards with the Ce…

  rikku0801

  9 replies

  15 years ago

  By: rikku0801

• SQL Query

  Hi all! Please help with modifying this code. SELECT query1.* FROM (SELECT bookid, Count(*) AS orde…

  call4ljw

  16 replies

  15 years ago

  By: call4ljw

• Help for MS Access homework

  For our homework in our Computer science class, we were tasked to research by asking expert advice …

  tanishantan

  4 replies

  15 years ago

  By: LutzM

• join 2 text fields

  i have made a db contain these table with these values CREATE TABLE tblCompeditors (CompID AutoInc…

  emailcooney

  2 replies

  15 years ago

  By: emailcooney

• Security in Multiuser environment (Ms Access Project or Ms access database)

  hi, Iam developing a database with Access as front end and Sql Server 2005 express as back end. It …

  kiranmai.gompa

  4 replies

  15 years, 1 month ago

  By: Rayis Imayev