[microsoft:access] Forum Topics

How many tables we can create in a single MS Access database ? I m going for a multiuser project . I dont know how many tables I will have to make.

Hi techs... I'm currently using ASUS W5F now... and couple of days ago... I installed System Mechanic Pro 7. After the installation, i started using it... doing scan... and it found something that recognised as spyware... (i don't really pay attention to it and just clean the spyware). After that …

Hello there, i just need your opinion about this...i have now database and all i need to do is to connect it on this page..my question is..where i should put the code of connecting this page to my database that has a column of "ID" and "Password" and it has …

Hi all , i m using Ms-Access applicaion in c# bt getting error while using a datareader again after closing it. here is the code. can any one please help me?????????? if (sCl.Read()) { if (!(sCl.GetValue(0) is DBNull)) code = sCl.GetInt32(0); if (!(sCl.GetValue(1) is DBNull)) court = sCl.GetInt32(1); if (!(sCl.GetValue(3) …

I am using SQL to write to an MS Access db via JDBC. Whenever the word or word-portion "update" occurs within a text string I am trying to store, I get an error message that "update" is a reserved word, even though it has been correctly delimited (such as 'xxx …

Hello everybody,I m in new in C#. I gave password to my MS Access DB.Ms Access only requires password to set,it doesn't require user name.So I did it as they require.Now I made a very simple c# program which access the DB and retrieve some info.When I did it without …

Hi I am creating an MDI application that carries out various tasks >> Login, View Balance, Show Transactions, Request Statement. So far I have only managed to create the Parent MDI, Main menu to be able to choose a function, and login validation. Login Code: Dim str As String = …

I have recently updated from Office XP Developper to Office Professional 2007. Although I have navigated a lot in the "Help" documentation of ACCESS 2007, I could not find any instruction about how to join a Workgroup (xxx.mdw) used by my protected ACCESS 2002 Databases. Therefore I cannot open them. …

Using FileMaker Pro 8 I have a table whit a column for dates, like showing below. dates Mon, Sept 10, 2007 Wed, Sept 12, 2007 Wed, Sept 19, 2007 Mon, Oct 8, 2007 Mon, Oct 15, 2007 I want a field(s) to show all those records like this Sept 10, …

Hello, I am trying to pull the relationships from an Access database. I would like to know which fields have what type of relation with other tables in the database. Does anyone know how to do this? Thanks, Ben

How can i create a table with my desired fields in a existing access db using vb? What should be da code? Example will b appreciated.

hi.i have problem adding record into access database because these tables i've created has relationships.i need to add record (from a single vb form) into 2 different tables. these 2 tables refer to the same record id actually.but first i need to add record into the first table because then …

i need help on making a login page and register page that will be linked together using access. can anyone teach mi the step to make it?

Hi, This is my first post, so please be gentle with me. None of my desktop programs will load when clicked. I also get the error "Access to the specified device, path or file is denied" if I attempt to creat a shortcut" I can run programs from start > …

hi every one, i have an application in which i have to send email alerts to a student untill he pays his feez.we are using windows 2000 professional and outlook 2003,msaccess 2003.Iam new to using msaccess,can anyone give the detailed procedure on how to send automated emails using macros or …

I've recently wrote some code to update an inventory table within a database. The program works great; the problem is that many machines access this database at any given time, and I'm concerned that at one point my program will not be able to update the table because of too …

Hullo Members, is there any one who can help me make a VB search code in MS Access 2003, I have a First names column and Last names column but I cannot make a search criteria that suits both first and last names incase one enters either of the two …

I am using an Access Database through Visual Basic 6. Is there any other way to access the database excluding the following code. Set CNN = New ADODB.Connection str = "\\SYS8\DATAX\EMP.MDB" CNN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str + ";Persist Security Info=False" CNN.CursorLocation = adUseClient

Hi I am creating an MDI application that asks the user for a User ID and Password to be able to show personal details once verified. Details of user ids and passwords are available in a MS Access Table1. There is another table2 for user details, and another one yet …

I just found an easiest way to save your documents. It can then process this data as well to create quite complex filing systems.[URL="http://www.awgarstone.com/product.php?item=activefiler"]Activefiler [/URL]could be easeasily be used from any Office program, or any program that can call a DLL as it exposes a full API.You will need to …

I am using MS Access database by a vb6 program for multiuser environment. In the program I have written code for autogenerating employee_id which is primary key in the table. When entering records simultaneously from two or more workstation, It gives a problem Run time error The changes you requested …

Hello everyone, im new in vb.net..as of now im using msaccess as my back end.When i run the program in my pc..it run ok..but when i try to map so that other user can user the database..it cannot save..message is read only..any suggestion on how to use the msaccess for …

Hi 2 all, im a newbe in alot of things, 1st I just registered @ this cool site, 2nd I am learning to wright and develop programes, I just started in MS Access, cause it`s easy to create tables, forms and so forth, my boss use`s .NET (way to hard …

Hi all Newbie to visual basic. I need to create an application to read and write in information into database. It is a prototype that y i choose to use Access as my database. I am having problems connecting database to VB. I choose Microsoft Access as data source. It …

Can someone tell me why this SQL Command at the end is not working? I am a noob, but I have tried everything I can think of and I am getting nowhere. There is no literature on how to do something like this... It would have to be my first …

Hi, I have seen this problem before, I cannot find a solution. I am using ASP with an access database. I have a form that is has a combo box called resno displaying school names and resno IDs the Resno is the stored value and is a text field. FormCode: …

Logfile of HijackThis v1.99.1 Scan saved at 5:15:28 PM, on 10/8/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16512) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Sygate\SPF\Smc.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Alwil Software\Avast4\aswUpdSv.exe C:\Program Files\Alwil Software\Avast4\ashServ.exe C:\WINDOWS\system32\LEXBCES.EXE C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\LEXPPS.EXE C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe C:\WINDOWS\system32\igfxtray.exe C:\Program Files\Microsoft Hardware\Mouse\point32.exe C:\PROGRA~1\ALWILS~1\Avast4\ashDisp.exe C:\Program …

Hi people, I'm having a small problem in ASP.NET + Microsoft Access. Here is my problem: 1) I have a table (item_table) with 3 fields 2) f1-ID, f2-Item, f3-Total 2) In my asp page, I am having 1 dropdownlist (DropDownList1) and a button (btn1) 3) DropDownList1 contains values from 0-10. …

Hi I have used three combo box in VB 6 form one for selecting date one for month and one for year. If the selection is say 12/07/2007 then I need it to be converted as 12/07/2007 under one field i.e date field of access database. So how can I …

hi all, i have problem creating queries in access.this is because i do not know how to call the value from a variable in vb into the query in access. let say in vb i've created : [code] Public booking_date As Date Public fac_type As Integer . . . . …

Hi, Can anyone help me with this..!!! I found an error stating that "Unrecognized database format" How can I solved this..I am currently using VB to link my MS access 2000 database using DATA object, Please help me..Thanks..

have a nice day everyone. please help me....how to make data report. now i already make data environment.. but i'm stuck in data report. how to import from access to data report?...please...

How is the best way to back up Outlook 2003 Contacts. I want an external back up that I can transfer contacts to another computer and do it daily if need be.

Hi All, I'm developing an application using VB 6.0 & using MS Access 2000 as backend. How many records can I store in a table? Is there any such limit?

Hi, I'd really appreciate some help from the access/db gurus out there. I've got an access 2000 database, on a WIN2K machine, which has linked tables to a Sybase db, connecting through a Sybase ASE ODBC driver. I find that everytime i try and get data from the linked table …

hi all, i built outlook plug_in to change the numbers in contact list.when i tried the application for small contacts list ,it did the functionality i want. but, when i used the application for large contacts . it did not change all the contacts item . Is the problem in …

Hi guys, can you please help me. Is it possible to get data from NOTEPAD,Store each data into a new table of MS-Access, Thanks..God bless

Hello, I have been struggling for awhile now to get my website up and running. Here is some background: Website development: Dreamweaver 8 Dynamic Programming language: ColdFusion MX 7 Database software: MS Access 2002 Type of website: Recipes returned from database input (by user) Goal: To have website visitors use …

Hello out there! I've tried lots of editing in this code yet I still receive the following errors. 1. Every time I press the Update button to update a record, I usually receive this error message[COLOR="red"] [B]“Syntax error in UPDATE statement”.[/B][/COLOR] 2. When I press the Save New button to …

Hello out there! I've tried lots of editing in this code yet I still receive the following errors. 1. Every time I press the Update button to update a record, I usually receive this error message [B]“Syntax error in UPDATE statement”.[/B] 2. When I press the Save New button to …

hello Can any one please help me in the following..... I making a database with Access and ASP. I have created a search option where I have a text box and a submit button. the result to this search is displayed in the same page. all i want is a …

...sorry, posted the same question. ...still getting the hang of things.

I created a Microsoft Access 2003 database that conatin photos stored as Long Binary data. I want to be able to merge those photos into a Microsoft Publisher 2003 document as a photo. Just don't know how or if I can. Can anybody give me advise?

A friend recently approached me to transfer her Filemaker pro data into MS Acces03. That was easy enough until she asked me to duplicate the same "find mode" capabilities in MS Access. Searching various forums and sites, it seems like it can't be done. the closest i got in MS …

Should be simple but my brain is about to explode. My database has a form frmPets. I am simply trying to take a field (text) from that form and populate other related forms without actually having to open those forms right away. After 2 weeks of searching and banging my …

Please help...I am new to Access and VB. I have created a form that selects certain records from a table into a recordset. Now I want to have all the records from the recordset into a report . How do I do this?

Its' quite a long question but I've explained it the best way I know how I have two subforms within a main form. Each of the subforms are not directly related at the table level. one subform is for project payments, the other is for the project bank details. Because …

Hey, i am having trouble with a project i have for school. The problem is as follows: I have one database(access), and it contains the specifications for 3 PC's( will be more but not atm), i have added a column stating the specification of the pc. I have an adodc …

hi... am using access 2003 databse in my application. i want my databse to be on the 1 pc in the LAN. and my application created in c# will be on the all machines in the LAN. So in that application i have made connection string as " Provider = …

My computer is running slower than normal and I'm not sure why. I have lots of room left on it. Livejournal is especially slow and when I'm typing up a post or comment I won't be able to see everything as I type-it'll have lots of the "text" line and …