Search Results

Search found 37152 results on 1487 pages for 'shared access'.

Page 35/1487 | < Previous Page | 31 32 33 34 35 36 37 38 39 40 41 42  | Next Page >

• 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

• 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

• sql to compare two strings in MS access

  - by tksy

  I am trying to compare a series of strings like the following rodeo rodas carrot crate GLX GLX 1.1 GLX glxs the comparision need not be case sensitive i am trying to write a sql where i am updating the first string with the second string if they match approximately. Here except the second string all the other examples match. I…

  Read the article

• compare/merge two ms access databases

  - by sprugman

  I've got two ms access .mdb files that I need to compare/merge. Any good tools out there for this? Any way to easily export both to ascii sql where I can use something like Beyond Compare?

  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 I wanted to create a dropdown that…

  Read the article

• How to compact an MS Access database, while the database is open, using vba

  - by tksy

  I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB. Is it possible to compress the database at regular intervals while the code is running?

  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

• MS-Access: TableAdapter UpdateCommand for table without primary key

  - by Steven

  What is the syntax for an Update query for a table without a primary key? Disclaimer: Frustratingly, adding a primary key is not an option. My program is a small program in a much larger system with poor data management. My development time does not include rewriting the other software. Note: The database is Microsoft Access.

  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 tools to make this job easier, but…

  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

• Access Database Integration with website

  - by Ahmad

  Hi i'd like to have my website be automatically and continuously updated with information from an access database, but im not sure how to do so? Any suggestions?

  Read the article

• How to specify blob type in MS Access?

  - by Firat

  How to specify blob type in MS Access? I have office 2007 installed. I am using jdbc, but this should not matter for the SQL query I am passing. Tried to pass a length to it, or FILE type, did not help. CREATE TABLE mytable ( [integer] INTEGER not null, [string] VARCHAR (255), [datetime] DATETIME, [boolean] BIT, [char] CHAR, …

  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 information on why the…

  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 AttendanceQuery GROUP BY…

  Read the article

• MS Access question

  - by Scott Jackson

  I've an access database table with 3 fields : Purchase date Warranty time Warranty expiry Warranty time has 1, 2, 3, 4, 5 in it which corresponds to years. How can I auto-populate the 'Warranty expiry' field (which is a date field) by looking at the 'Purchase date' and then adding on the 'Warranty time' (warranty…

  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

• ms access negative page numbers

  - by FrustratedWithFormsDesigner

  I have an access report that generates 36505 pages (un filtered, and about half of each page is taken up by group headers and page headers) , though the footer at the bottom of the report page says "36505 of -29031". This looks like an overflow problem maybe, though I'm confused how it got the current page number of…

  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 so, any ideas what…

  Read the article

• MS Access query for time

  - by nisha

  following data and using MS Access with VB6 UserID UserName LogTime LogDate 1 S 9:00 21/5/2010 1 S 10:00 21/5/2010 1 S 11:00 21/5/2010 1 S 12:00 21/5/2010 1 S 14:00 21/5/2010 1 S 17:00 21/5/2010 …

  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 Microsoft Access 2007…

  Read the article

• 'EXC_BAD_ACCESS' When trying to access a variable?

  - by Nick Brooks

  I get an 'EXC_BAD_ACCESS' error when trying to access variable in a function other than the one it was set in: NSLog(@"Commening search (%@)",sessionID); // This causes it The variable is set in the 'awakeFromNib' function: //Retrieve Session-ID sessionID = [self getSessionID]; The variable itself…

  Read the article

• ms-access: displaying column as "something else"

  - by every_answer_gets_a_point

  i have the following access sql statement: SELECT * FROM (SELECT [Occurrence Number], [Occurrence Date], [1 0 Preanalytical (Before Testing)], [Cup Type], NULL as '2 0 Analytical (Testing Phase)', [2 0 Area], NULL,NULL FROM [Lab Occurrence Form] WHERE NOT ([1 0 Preanalytical (Before Testing)] IS NULL)…

  Read the article

• What are the appropriate uses for MS Access?

  - by Patrick Cuff

  It's the Office app everyone loves to hate ;) I admit that it's often abused or misused, but it does come in handy on occasion. So what do you think? Are there appropriate uses for Access, or should MS jetison it from the Office suite?

  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

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