Make Small Databases Then To Use Access Or Sql Server?
Oct 11, 2009Are there any other ways to make small databases then to use access or sql server?
View 1 Replies
ADVERTISEMENT
Make A Small Program For Ticketing On A Parking For A Small Hotel?
Aug 27, 2010I need to make a small programm for ticketing on a parking for a small hotel.So i have 2 Printers pariking In (for delivery of the tickets) and 2 Readers PArking Out.Both Printers and REaders are working Serial.So i need to poll the serial ports of the printers and readers every second.The data is stored on a SQL database so i need to read and write in the database.Can i do this with 1 PC and 1 programm or 1 PC and 4 programms that are runnning at the same time ?
View 2 RepliesCreate A Small Application That Can Make Small Calculations?
Feb 1, 2010On form 1 , i have a number of buttons that open up different websites.What i want to do is when i click a button on form 1 , i want forum 2 to show ( Form2.show() ) , Form 2 will have a list (Buttons) of internet browsers.
View 4 RepliesCompare Two Access Databases With Two Fields Each And Write The Results To A Third Access Database?
Apr 22, 2010I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
Best Way To Set Up Server That Could Hold Multiple Databases
Apr 5, 2010connect my vb.net application to a remote sql server database, so every one who installs the application would be able to connect to the same remote database. the application would obviously require the internet to run.i also want the option to add more databases in the future, preferably one for each business who would use my software.i am wondering the best way to set up this server that could hold multiple databases. i would think i have two options:
1) set up the server myself on a dedicated computer
2) pay for some type of service that host sql server dataases
so how would i go about executing these options? i dont know the first thing. which option is better?i do however know how to connect to a remote database so thats not what i am asking.
Show Sql Server Servers And Databases?
Sep 9, 2010I want to display a dialog that has 2 dropdown combo's. The first combo display a list of the available SqlServer servers. The second combo displays the list of available database once the user has selected a server. how to populate the combo's?
View 2 RepliesSql Server :: Join Two Different Types Of Databases Together?
Nov 14, 2011Right now, inside the access file, the mssql tables are set up as linked tables so queries can be written using tables from both databases. (e.g. "select * db1.table1 where db1.table1.somevalue not in db2.table1", or select into tables like that one)These queries need to be moved into a VB.NET project, but still be linked to the access file.ng loops or something?
View 3 RepliesUsing MS-Access Databases In .net?
Jun 14, 2012I'm trying to get going with using MS-Access databases in vb.net. In my case, I have a list of MS-Access database paths as strings that I want to talk to. I don't want to add the databases permanently to my project, since there are many of them (hundreds, actually). To start off, I have something like this:
Public Sub main()
Dim conn As New OleDbConnection
conn.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
[code]....
If I run this, it fails at " Dim rdr = cmd.ExecuteReader", with the error:
"Record(s) cannot be read; no read permission on 'MSysObjects'."
however, I can open the same database using the MS-Access client and run the same query without a problem.
Insert The Excel Data Into Sql Server Databases
Aug 4, 2006I would like to import the excel in to the sql server using vb.net. how can i do it? Another question is how can i execute the DTS using vb.net
View 6 RepliesSync 2 Sql Server 2005 Express Databases
Feb 23, 2010I have a client that has the basic database on a server(sql server 2005 express database) and wants to work on his laptop from his home, so i guess that i can install the software on his laptop but how will the 2 databases be synchronized, having same data. the synchronization will be made once a day in the morning when he returns to his office. How can this be accomplished?
View 2 RepliesDatabases : Moving Away From MS Access?
Apr 5, 2010I've been using MS Access for the database in many of my programs (they're always local databases, copied to the user's computer) and as is no surprise to anyone here, it's a horrible choice but it's what I knew and so I've just defaulted to it.What is the best one to use? How do I go about buying/getting it? Does it allow royalty-free copies? Can I import my existing Access databases into this? How do I deploy it?
View 1 RepliesImporting Databases From Access?
Jun 26, 2011If I import an access database into vb.net windows application will the included queries also be imported and will they continue to function correctly ?
View 7 RepliesOleDbCommand Access Databases?
Aug 7, 2010created a database and I am able to read from the database into VB and also able to create a new set of feilds. I do needte a set of records, can't seem to find the right code.The access database has 4 columns one of which is a unique code (column name is 'code') that relates to each different item so I would have the user put in the code to the textbox and then the programme will delete the set of records corresponding to that code
View 4 RepliesConnect To Previous Other Databases Such As SQL Server, Oracle. But Getting An Error?
Jul 5, 2011I am trying to Connect my VB.net Window Application to IBM_DB2 Database.I have used the same method to connect to previous other databases such as SQL Server, Oracle. But getting an error in DB2.
Dim cn As New OdbcConnection("dsn=Sample;uid=db2admin;pwd=password") 'Sample is DSN
cn.Open()
Dim da As New OdbcDataAdapter("Select * from Employee", cn)[code]......
IDE :: VS Server Explorer Close Databases Connections While Debugging?
Jul 27, 2009Every time I execute my application and the app try to access the database I received an error message telling me that the user cannot login into the database. This is because the VS Server Explorer have the connection opened. What I need is that every time I debug (F5) my app the Server Explorer close the connection with the database so I do not have to stop the execution and manually close the connection. Is this is possible? Is there any way I can setup the debug or the Server Explorer to do this?
[Code]...
Best Way Of Accessing Microsoft Access Databases
Jan 24, 2012I use Microsoft Access databases for my big project but I find the performance is very hit and miss. I time the processes and sometimes there is some serious lag. Here is an example of the code I use:[code]I was told that this is a very old method of accessing databases, which doesn't surprise me since it's the same basic code I was using back in VB6 about 8 years ago.
View 39 RepliesCan't Read Access Databases In 32 Bit Mode
Mar 4, 2011I see, to my supprise, when I tried to installed the Access Database Engine drivers that you cannot run both 32 bit and 64 on the same machine (I have Office 64 bit installed). If SQL can do it? So I have this nice new 64 bit machine with 64 bit office and my hands are tied... Can't correct code in 64 bit mode, can't read Access databases in 32 bit mode. I just have a hard time with 64 bit being out since XP, that this it just not fixed yet. Humm the Behemoth that is now Microsoft. Want to use OLEDB?
View 2 RepliesCompact And Repair Access Databases?
Oct 22, 2010I am looking for some sample code to use in VB2008, in order to compact and repair Microsoft Access MDB files and ACCDB files.
View 1 RepliesConnecting To Access Databases 64bit?
Mar 10, 2012I am using Visual Basic Express 2008 64bit on a Windows 7 64 bit computer. It is running Microsoft Office 2010 University Edition, which only comes in 32 bit so far as I know. I am able to connect to my access .accdb database from within Visual Basic, which I wasn't able to do until I came across this: [Code]...
Beforehand, I had recieved a "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." error, and after applying the above fix worked fine. However, now that I am trying to publish my program, I am returned with the same error, no matter what target CPU I select. The program works fine on 32bit machines, however on my 64bit laptop it is unable to connect to the database. I have tried compatibility mode, downloaded many different add-ons from the Microsoft download page, but to no prevail. My understanding is that it is not actually compiling the published version to x86, simply running it as such when I build it in Visual Basic, and because there is no apparent way to set target CPU for compiling,
Create Access Databases Programmatically?
Jun 7, 2010I need to make an application that from a master database creates a number of access database files (tables of a larger db), then these are manually given to users who fill in data, the database files are emailed back to a user who, through the application, combines them again.The only part of this that I am unsure about is problematically creating the access db's. I have read that through Microsoft Jet OLE DB Provider and Microsoft ADO Ext I can create them (the tables and data), but I also need forms.
View 1 RepliesInsert Data Into 2 Different Access Databases At Once?
Sep 21, 2011I'm doing a little project on the side and was wondering if it was possible to enter data from text boxes on a vb form into two different tables in the same database? [code]
View 3 RepliesJoin 2 Tables From 2 Different Access Databases?
May 22, 2012I am tying to build a COMMAND that joins two tables from two different access databases in vb.net,
View 4 RepliesQuery To Access Data From Two Databases
Oct 27, 2011I have used two database (1) party (2)partydup.[code]In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error. Please let me know what is the mistake i have done.[code]
View 8 RepliesSwitching Between Open Access Databases?
Mar 25, 2010simple coding procedure or recommend a resource for switching between two or more open Microsoft Access databases within a VB.net program, while keeping the same indexed place in each database? The purpose is to iterate through the databases conducting comparative analyses of field values, and writing the results of the analysis to the same databases or another database.
View 7 RepliesTransfer Data Between Two Access Databases?
Nov 12, 2009I am in the process in developing a new version of my software. I have changed my design of my database slightly (added a few new tables and new fields to existing tables). The issue is that my users have user data in the old Db that I would like to transfer to the new Db. Both Db's are access 2003. Because my software is distributed over a wide geographical are it would not be possible to do this manually
I have appended data between two different tables in a single Db, but not between two separate Db's.
Make Different Databases For Each Employee?
Oct 20, 2010I am developing an application for employee goals and management. The application has a login screen that when a employee successfuly logs in takes him to main screen that contains a table to enter Items, Accesories, Insurance,ect. and will also allow the employee to see data from previous days. Now my question is how do I make this table that is on the Main Screen present data that belongs to only to the employee that is log in? And also How do I let this employee enter the sales for the day, update
and record into this database? Do I have to make different databases for each employee?
Cant Change Column Properties On Access Databases?
Aug 23, 2010I create an Access database in runtime, but when want to change the column properties I can't,the IDE tooltip say: "Property 'Item'is'ReadOnly'".I have a VB6 application with an Access 2003 database and not have any problem to manipulate to many properties like OrdinalPosition, ValidationText and others.
View 2 RepliesFinding A Record Across Multiple Access Databases?
May 3, 2010At my company, product is boxed and then placed on a scale/label printer set up in order to be weighed and labeled. The application running on the PC also records a record of each box in an MS Access Database which is then transferred to the main server. There is a separate access database for each scale PC and currently the only way our shipping department can print out a manifest for each pallet (which contains a list of all the boxes and their weights) is to open the correct access database and print out the report by entering the pallet number. Since there are six printer scales and the shipping person has no idea which scale it will be on just by looking at the number, she has to find the correct database through trial-and-error.
What I've been asked to do is create an application where she can simply type in the pallet number, and it will search each individual database for the number, then open the correct one where she can then print out the report without having to guess where it is. I've already figured out how to make the application open the database and report, but I don't know how to make it find which database the pallet record is contained in.Basically I want it to search a number of databases for a particular number in a field, and the return a value when it finds it of which database it is so that I can plug that in later. I have no idea how to do this and my searches online have proven fruitless.
Looking For Microsoft Access Cites Databases Names?
Dec 7, 2010I'm looking for Microsoft access cites databases names
View 3 RepliesManipulate MS Access 2000 Databases Via The DAO 3.6 Library On Win XP
Dec 15, 2010I have been using VB6 to manipulate MS Access 2000 databases via the DAO 3.6 library on Win XP. I have recently acquired Visual Basic Express 2010 and I have not been able to port my VB6 code. I can not find any sample code to use MS Access 2000 from VBE 2010. Is it possible to access MS Access 2000 from VBE 2010?
Here is my VB6 code:
Sub Main()
Dim dbJobCPD As Database
Dim rsJob As Recordset
[Code]......