Microsoft Access

• Topics

  Started by

  Posts

  Last post

• how to get data PostCode last two after two space sql server

  i have following query i want only highlighted post code how to get this please help me i want resu…

  mr.addikhan

  6 replies

  8 years, 3 months ago

  By: shepherd.online10

• Issue Linking to SQL Table with too many Indexes / Appending from Access into Non-linked SQL Table

  I am working with a small manufacturing company that uses a shop system with an SQL database to kee…

  jonathane 8802

  1 replies

  8 years, 3 months ago

  By: WILLIAM MITCHELL

• Access DSNless connection issue.

  Hello all: SQl server 2012, Access 2013. I have been using a file DSN to connect and link tables. I…

  Kurt Wimberger

  1 replies

  8 years, 4 months ago

  By: Kurt Wimberger

• editing table 6 million rows

  I have a sql table with about 10 columns. I link the table to an ms access application. When I op…

  GrassHopper

  7 replies

  8 years, 7 months ago

  By: GrassHopper

• Export Access DB Table

  Hi all, I would like to know if it's possible to run an export command (command prompt or powershel…

  ram302

  12 replies

  8 years, 7 months ago

  By: ram302

• Open Transaction in tempDB From Access Connections

  We have an Access application that uses SQL Server linked tables to populate forms and these connec…

  Chuck Hottle

  3 replies

  8 years, 8 months ago

  By: Eric M Russell

• Is there a way of listing Access only as a database on a resume?

  I've used MS Access before as a database in some applications I've written. But I've never learned …

  Doctor Who 2

  7 replies

  8 years, 8 months ago

  By: pietlinden

• Access SQL to SQL

  Hi all, I have some code that works in Access but now I want to forward the code to our IT departme…

  wrightyrx7

  9 replies

  8 years, 10 months ago

  By: Ken McKelvey

• access / sql connect query from a noob.

  I don't know access but I have an access db that somehow interfaces with an old SQL database I need…

  snomadj

  1 replies

  8 years, 10 months ago

  By: WendellB

• Controlling SQL users from Access

  Hi all I'm designing a database front end to help us with user administration (and it looks better …

  richardmgreen1

  2 replies

  8 years, 10 months ago

  By: richardmgreen1

• Date field showing as text when linked from Sql Server Table

  I have a strange problem. when I link a table with date field from SQL Server to Access 2013. The d…

  rangu

  1 replies

  8 years, 11 months ago

  By: WendellB

• ODBC Communication Link Failure - Connection Lost : MS Access to SQl Server

  Hello I have an MS Access Application running on users desktop, which connects to Sql Server Back e…

  rangu

  4 replies

  8 years, 11 months ago

  By: WendellB

• MS Access - Sql Server conversion

  Hello. I am in the process of migrating Ms Access tables and queries to Sql Sever. I am keeping the…

  rangu

  10 replies

  8 years, 11 months ago

  By: rangu

• Repair MS Access database without having program installed

  Does anyone know of a program/option/tool to repair a microsoft access database that can be run fro…

  MarkLam123

  5 replies

  8 years, 11 months ago

  By: rangu

• Help with time -(hour(create_dtim) >= 22)+ (minute(create_dtim) >= 15)

  Hi, I need help please, This statement work but the system only see the hour not the minute: (creat…

  jcachado

  14 replies

  9 years ago

  By: bgalway