Search Results

Search found 37031 results on 1482 pages for 'ms access'.

Page 33/1482 | < Previous Page | 29 30 31 32 33 34 35 36 37 38 39 40  | Next Page >

• OLEDB connection to Access database using DSN

  - by somu

  Hai i want oledb connection using Dsn. I used the following code 'Dsn Create dbRegBase.RegisterDatabase("GEMINI", "Microsoft Access Driver (*.mdb)", True,DBQ=D:\Gemini\GEMINI\database\paints_01_2008-2009.mdb Description=Greenchip Technologies ODBC Database File Path OemToAnsi=No UID=admin PWD=XXXXXX conection code…

  Read the article

• OLEDB connection to Access database using DSN

  - by somu

  i want oledb connection using Dsn. I used the following code 'Dsn Create dbRegBase.RegisterDatabase("GEMINI", "Microsoft Access Driver (*.mdb)", True,DBQ=D:\Gemini\GEMINI\database\paints_01_2008-2009.mdb Description=Greenchip Technologies ODBC Database File Path OemToAnsi=No UID=admin PWD=XXXXXX conection code…

  Read the article

• How to operate access with PHP?

  - by Mask

  I have no experience with access. How to do update/insert/delete/select statement with and without $rs = new com("ADODB.RecordSet"); ?

  Read the article

• Access MDB: Is it possible to monitor and log the activity of an Access MDB?

  - by Craig Johnston

  Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed against it), in the same way as you would use SQL Profiler for the SQL Server?

  Read the article

• Crystal Reports from Access DB in FrontPage (plus RealPlayer integration)

  - by Jason

  Hey guys, My boss has some interesting requirements for his next project and insists that we try to implement some Crystal Reports on our Access database (on his computer) into a FrontPage document (for ease of maintenance). After that, he wants an MP3 to be embedded using a RealPlayer widget because that's the…

  Read the article

• Fixed number of rows In Access Report

  - by Pronek

  Hello All, I am having tried a access 2007 report with fixed numbers of rows (records) per page. For example, I like to fix total number of records (rows) to 10 per page while underlying query might have 5 records in some criteria or 15 records in some case. If any idea, please share me. TIA ProNek

  Read the article

• access: read CSV file into table

  - by every_answer_gets_a_point

  is it possible to programmatically have access open a certain csv file and read it into a datasheet and set parameters like what time of delimiter, TEXT QUALIFIER etc, including all the steps that one takes to manually import a csv file into a table?

  Read the article

• make field a dropdown in access 2007

  - by Crash893

  I'm creating a HR database in access 2007 I have a main table of employee info and several tables that relate to that table ( education for example) that list the acceptable elements that can populate that cell in that row When i create a form it was created as just a plain text field which is constrained but…

  Read the article

• Access MDB: Is it possible to monitor and log actual queries made against an Access MDB?

  - by Craig Johnston

  Is it possible to monitor what is happening to an Access MDB (ie. what SQL queries are being executed against it), in the same way as you would use SQL Profiler for the SQL Server? I need logs of actual queries being called.

  Read the article

• Access MDB: do access MDB files have an upper size limit?

  - by Craig Johnston

  Do access .MDB files have an upper size limit? Will, for example, applications that connect to an .MDB file over 1GB have problems?

  Read the article

• Find and replace table/field names in Access?

  - by richardtallent

  I've been handed a rather large, old, and crusty Access 2000/2003 database to clean up. I'll need to rename a number of tables and fields, but need to do so in a way that doesn't break existing queries. (Fortunately, there are no macros, forms, or reports to worry about.) I've heard there are some commercial…

  Read the article

• Conversion from Access 2010 to 2007

  - by ivan

  Is there a way to use a database created with Access 2010 in 2007? I keep getting the "unrecognized format" error...

  Read the article

• Integration Services Throws an Error Reading Access 2007 Table

  - by Eric Flamm

  [Participant Table [1994]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "I:\My Documents\Flamm Consulting\Migrations.accdb" failed with error code 0xC0209303. There may be error messages posted before this with more…

  Read the article

• Combining multiple queries in one in Access

  - by Arlen Beiler

  I have two queries that I want to combine into one in Microsoft Access 2003. SELECT AttendanceQuery.AttendDate, Count(*) AS Absent FROM AttendanceQuery WHERE (((AttendanceQuery.Present)=False)) GROUP BY AttendanceQuery.AttendDate; SELECT AttendanceQuery.AttendDate, Count(*) AS Enrollment FROM…

  Read the article

• "Invalid Column Name" error thrown by Access Reports?

  - by badpanda

  I am attempting to sum over a detail grouping on a specific field in Microsoft Access, and assign that sum to a field in the general grouping. When I try to run the report, I get an "Invalid Column Name" error with the detail field getting the error. Has anyone previously encountered this? If…

  Read the article

• Block committing changes to Microsoft Access database

  - by controlfreak123

  Is there a way to write a hook that will run before changes are committed to an Access DB? I'm looking for a way to block changes if a specific process is currently querying the DB.

  Read the article

• Issues querying Access '07 database in C#

  - by Kye

  I'm doing a .NET unit as part of my studies. I've only just started, with a lecturer that as kinda failed to give me the most solid foundation with .NET, so excuse the noobishness. I'm making a pretty simple and generic database-driven application. I'm using C# and I'm accessing a…

  Read the article

• exporting code from Microsoft Access

  - by arcticpenguin

  Is there any way to bulk-export Microsoft Access code to files? I see I can export one file at a time, but there are hundreds and I'll be here all day. It there no "Export All" or multi-select export anywhere?

  Read the article

• running query and putting result into a variable ACCESS

  - by every_answer_gets_a_point

  i am running a query from vba editor access: "select max(somerow) from sometable" i want to put the result of this query into a variable. how do i do it?

  Read the article

• Access 2007 - Display text fields in drop down list while bundling to an ID

  - by Omar A.

  in Access 2007 how can I display text fields in drop down list while bundling to an ID? not while selecting (we can do this by plying with the width field. but what I need after selecting? Do we create a hidden field that stores the ID? http://websitedesignandsupport.com

  Read the article

• access: getting create table string

  - by every_answer_gets_a_point

  i have a table in access and i would like to get the SQL string from it that will generate the table like: CREATE TABLE example ( id INT, data VARCHAR(100) ); is there any way to do this?

  Read the article

• Access 2007 Show Full Screen

  - by Spazzer

  Hi, Can anyone tell me how I can show the full screen on a Form in Access 2007 so that there are no Toolbars etc open, so no one can tamper with anything ? Cheers, Nick C

  Read the article

• Reporting. MS Word templates population required

  - by Andrew Florko

  Application we developed fills MS Word templates with data from Database. Customers require to have ability edit Word templates via MS Word (change style, font, layout e.t.c) with no additional software to be installed and no training. AFAIK, Sql Reporting Services and Crystal…

  Read the article

• VB.Net: exception on ExecuteReader() using OleDbCommand and Access

  - by Shane Fagan

  Hi again all, im getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file 'to make it simple to access the db connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data " connstring += "Source=" &…

  Read the article

• Looking for a .NET data access layer

  - by Luke101

  Hello, I am looking for a data access layer for ado.net. I am not interested in linq, EF, NHibernate or any other ORM. Currently, I am using the data access layer from umbraco. The DAL is very good but they stopped developing it so i am looking for a different one. Does…

  Read the article

< Previous Page | 29 30 31 32 33 34 35 36 37 38 39 40  | Next Page >