1,597 Topics
 | |
 | I have two access database, one was old access from 2000 and the other is 2007. the problem is there are some feature that are in 2000 but not in 2007. so, i want to merge the two database together so that i can use both the old features and …  |
| | Hey everyone can I get some help please. I read through a few threads with the same problem as me but i can't seem to get the answer i'm looking for. I'm doing a school project and I need to save a Access DataBase that I have created in C#! … |
| | Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way? |
| | I'm not sure if this is the right place for this, but I'm having an issue I'm trying to solve for a customer, and it's not going well. Searching online I'm seeing this has been a common problem for many people, but there aren't really any solutions that I can … |
| | Hey every one i need some help please! I am trying to save a Database through c# but cant seem to crack it. I read a few threads but every one explains how to save an existing DB. In my program I am creating a new DB in c# then … |
| | i can't use vba in access because when i write: Dim db as[space]->error it seem error space . how do i fix it ?i reinstalled it already but it's not working . thank you |
| | hi i have some question to ask everyone . 1.How make open form in full screen ? 2.Example: I created two completed forms,frmLogin and frmStudent and saved it name "Student".what i want is when i open saved file,i want it only show frmLogin auto(full screen) without choose a form from … |
| | Hello, I am working on a program for school and this is my first experience with arrays of objects. I am passing the array of objects into a function, and from within that function I am running another function that takes an individual object from the array as an arguemnt … |
| | i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE. the first table contains (username, password, first name, last name). the second table is only one field (manager, admin, agent). there are two forms (administration, login), the administration form adds a new user, the login form makes user …  |
| | HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify … |
| | hi, im working on a small project on access 2007, i have a form that contains multiple textboxes ,and a save button. these textboxes are related to tables, so what i need is a code for that button to save the records in the textboxes in the tables and then … |
| | Hello, I got a problem, I can save my data to access database and in the access database field I set it to date/time. But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00 How to get the … |
| | Hi I have a access database that contains foreign characters(Hebrew language). How can i search the values in the column by using c#? This is my code: SELECT * FROM "table name" WHERE column_name LIKE '%שגל%' I'm getting this error: Syntax Error in SQl statement Can anyone please afford your … |
| | Good day guys, anyone here who knows how to easily access image pointers stored in a database in JSP?... here's my code =) ... it already works in retrieving data other than the image... my database contains petid, petname,birthdate,image,petprice.... [CODE] <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/store" user="root"/> … |
| | Hello! I am working with an Access Database (Access 2002) that contains a form that is supposed to import a CSV. However, because some of the integers contained in the CSV are too large for Access to handle (regardless of the number format I select for the field), I'm going …  |
| | Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open … |
| | Hi, I am working in the program which is written in Access 2003 database with developer extension. It looks really similar with vb6. It is quick and it does the job, but we would like to upgrade it into vb.net considering that the technology might "abandon" it. So, we try … |
| | HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in … |
| | Hi i'v recently bought a 2 year old packard bell easy note ALP-Ajax C3 laptop with windows vista, i have seen this laptop working and connect to bt broadband and go online before i bought it, but when i brought it home and tried to connect it to my virgin … |
| | Hi, sorry my title isn't very explanatory. What I need to do is to access a variable from a main function, in another function without using a parameter to do so. Based on the nature of the problem you might see why I would do this. (if there is a …  |
| | Hi, I am trying to come up wit a database design for a small school. it works this way: in AC-Year, there are 3 terms with each term having 2 semesters. New students get registered at the start of each term. A student may take entrance exam. if he fails, … |
| | Hello, I need help saving data into an access 2007 database from a program created in vb 2008. I am making a basic "game" that allows you to move a "robot" up,down,left, right and will save the movements/positions into an access 2007 database. I already have the basic movement created … |
| | Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : … |
| | hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks |
| | hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to … |
| | Hi, I'm doing the following code to connect to Access Db. The db1.mdb is placed in c:\db1.mdb. It giving me error "couldn't find file" [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System; using System.Data.OleDb; namespace CustomerDB { class OleDbTest{ public static void Main() { //create the database connection … |
| | I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … |
 | Hey I am trying to do a project on Test Engine. I need to retrieve random rows of questions from access database. I did the following code, but every time I once close and run it again, the sequence of questions is same. How can I change the sequence every … |
| | hi how to do insert ignore in access? is access support this function? [CODE] CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")" [/CODE] or how can i do a search for duplicate record first before insert? … |
| | hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you |
The End.