[microsoft-access] Forum Topics

Hi, i am currently doing a system for the rental video. I am new to java coding.. Problem is how to add data to access database using java coding in method? Thank you.

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 …

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, …

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

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes, …

I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a …

hi all hope some one can help me out im a php guy and ive got an application i want to make that will run on windows and ive never program for desktop before and i really need some advice. here is the scenario iv got my website with a …

i wonder it possible or not to put video in access form ? if anyone know please answer if not, what about flash ? if can please tell me too . thank you very much