Setup Works On One Computer, Not Another - Access Database
Jul 1, 2011
I have created a setup using INNO which puts a Visual Basic 2010 Express program on the computer to update an Access database. It works on my Windows XP computer. On the user's computer, which is a Windows 7 computer, the Access database comes up as Read Only when opened. I get an "Operation must use an updateable query" error in the Visual Basic program when I try to create a record. The database has Read Only checked off in it's properties. But when you open it in Access 2010, it says Read Only at the top. (This computer has Access 2010. The database itself is in 2002-2003 format.) How can I get this database to be updateable on the user's computer? It works on my computer/does not say Read Only when opened in Access 2007.
View 3 Replies
ADVERTISEMENT
Jul 8, 2010
I've created a small DLL, an addin for Autodesk Inventor, this addin saves some information provided by the user and the program to an access(mdb)database.The whole idea behind this is that it allows users to quickly find drawings, assemblies and so on.The DLL works great on x86 systems however it has issues on x64 because I used ado.net.In a attempt to solve it I forced .net to compile it with the target x86 CPU settings.
However using this I'm unable register the dll (C:WINDOWSMicrosoft.NETFramework64v2.0.50727RegAsm.exe /codebase SavetoDatabase.dll )It says its not a proper .net dll file and therefore cannot be registered.
is there any other access-database connection provider (like dao or ado.net) that works on a 64 bit machine? Or do I need to change from mdb databases to another type (like mysql)? because sooner or later all machines its running on will be converted to x64.Or do I need to register the dll in another way?I've also tried to replace the conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 with ACE, with no luck however
View 1 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Jun 21, 2010
I am using vb to make a hospital system which works with a access database. i am having an issue with the updating function to the database, this time round instead of hard codding the connection i used the connection/data source wizard, in microsoft visual studio 2008 and there fore most of the code has been auto generated for me, which includes the insert, delete and update funtions from what i can find and what i have read vb is ment to also auto generate this which it is not. the funny thing is that i can close the program down and reload it (as long as i haven't opened the database) and my changes are still there but if i go and open the database and it hasn't changed. also i can change the database through the use of the Dataset connections in the datasource tab but not int he program the code ive found and believe that is meant to update the database
This is running off a couple of buttons i also have a update query but have know way of accessing it
Me.Validate()
Me.TblPatientDetailsBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.PatientInfoDataSet)
View 1 Replies
Feb 15, 2011
I am writing a program that is using a access DB for the info to be displayed. However when i started making the program i started by just databinding the listboxes.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'AcskillsDataSet.Skills' table. You
[Code]....
but now that im looking at the data this is prolly only useful for simple data. Im wanting to seperate the data from queries into multiple boxes. Am i better off just manually having a connection to the database and running queries into arrays to sort the data?? The above method looks like im going to be trying to fight the databound stuff. There are two tables and the way the built in query builder is im starting to think its easier to write my own queries in variables or whatever.
View 4 Replies
Jun 21, 2010
i'm finish to develop a registration system using vb 2008 exp edition. so, i want to connect my standalone system with LAN network. i want to access database from other computer and be use in my system. i'm use crosscable to connect with 2 computer. before this, i'm just change connection string: 'server = ip address of second computer but it's didn't work.
connectionstring = "server=localhost; user id=root;password=123456;database=vrs;"
View 3 Replies
Jul 15, 2011
I have a VB.Net program which reads and writes to an Access database. I am trying to deploy the program using a setup (created with INNO Setup). Upon installation on a Windows 7 computer, Windows 7 is preventing it from writing data without changing the permission settings. It reads data but it doesn't write data. This problem doesn't happen in Windows XP. My question is: is there any way to make the Visual Basic .Net program write data to an Access database on Windows 7 from the setup without the user having to change permission settings?
View 12 Replies
Feb 14, 2012
I'm trying to access server database from a remote computer in lan-based network using this connection string "Server=192.168.10.2; user id=user; password=pass; database=sample_db" .. but it can't open a connection.. I don't know what to do, I tried searching for this but no luck.
View 3 Replies
Mar 18, 2012
I made a program that i want to run on computers at school and it utalizes a MySQL database. When i try to run it the program does not work as it cannot access the database. I open the code up on my computer at school and it has errors saying ti does nto recognize the MySQL code as it does not have it in its .Net library. So i try to download it into the library but that does not work. So my question is, will programs using any kind of database not work unless the user installs the needed add on, weather it be a .Net library add on or a java add on for MySQL? That cant be right it.
View 4 Replies
Sep 3, 2011
Can you give me some tools for LAN. I have a Program and im using SQL database and i wll access to other Computer. Im Using Visual Basic 2010.
View 16 Replies
Dec 8, 2011
I'm trying to add a string to a access database, for a column that was originally designed for numbers, i have changed the data type under the design view from number to text, yet I still get a error saying that it cannot convert the string expected int32
Input string was not in a correct format.Couldn't store in Parent_ID Column. Expected type is Int32.This is the full exception, i would have put it into code display but the option wasn't there
System.ArgumentException was unhandled
Message=Input string was not in a correct format.Couldn't store <A-238> in Parent_ID Column. Expected type is Int32.
Source=System.Data
StackTrace:
[code]....
View 6 Replies
Jun 6, 2012
Here's the code that I have:
TextBox3.Text = ""
WebBrowser1.Document.ExecCommand("Copy", False, vbNull)
TextBox3.Paste()
TextBox1.Text += TextBox3.Text & vbCrLf & vbCrLf 'This code just adds the pasted text from one textbox to another.
Question:
After I install and run the application on my main computer that I coded this app in work, but when I go to transfer/install it onto my laptop, the code will NOT copy and paste from my webbrowser to my textbox?
View 3 Replies
Feb 4, 2011
i have encountered a problem, i want to access the data coming to the computer from the in-built bluetooth module of a computer on windows platform, this data has been sent by a remote bluetooth module say a by an autonomous device (just like a bluetooth mouse connecting to the computer). The to be sent is in the form of numbers and i need these to manipulate on the computer.
View 6 Replies
Aug 13, 2008
I have the following query that works fine if I cut/pase into an SQL query in access, but when executed in VB the loop is skipped - ie, no data is returned.
[Code]...
View 5 Replies
Dec 8, 2009
I'm creating a db tool for automatic database repairs i have the following sql statement:
[code]...
Where the 'BrokenDbFile' is the location of the db where data has to come from and the 'sqlString' = the access statement.it gives a error when i put it in a try the exception is of type OleDbExceprion and de message text is "De instructie INSERT bevat een syntaxisfout" in Dutch Where it says that the syntax of the INSERT INTO is not correct. but when i paste the string from my inteli snce into access it works fine.
View 11 Replies
Dec 17, 2010
I've made a simple knowledgebase program which contains example documents. The documents are stored in a folder, and in an accessdatabase stands the information about the documents.The program also includes a simple search option. The program itself is located in a folder on a network computer.It has to be a network program for collegues can add other examples.Now it gets weird. at least in my opinion.When I run the program locally -> no problem.When I run the program from another network PC -> no problem.But when I run the program from a network Thin Client -> shaboom..At least when I enter a search option and the connection to the database is opened:"Application attempted to perform an operation not allowed by the security pollcy. To grand this application the required permission, contact you system administrator or use the Microsoft .NET framework configuration tool."[code]Now I've found a LOT of topics in this forum and many others, and it's clear that apps from another network location are run without "full trust". And the trust issue can be handled with caspol or web.config. Although caspol is a mystery to me and web.config didn't seem to work.But since it's so explicitly crashing on Thin Clients.
View 6 Replies
Jun 15, 2011
I am converting old VB6 code to VB.NET with ADO.NET (OleDB). This is my query that will create a blank table when ran in VB.NET, but then works when ran directly in Access. This code presumably also works in VB6, as I am using the same SQL:
SELECT qryAsOf.name, qryAsOf.type, 0 as opt, 0 as swap
INTO qryCon
FROM qryAsOf
LEFT JOIN qryLinked on qryAsOf.c = qryLinked.lc
I feel like this has something to do with the left join and select into being together, but like I said it is only VB that has an issue with it, Access handles it perfectly.Without the INTO line, this query returns all 600+ rows.
This DOES NOT WORK:
cm.CommandText = "CREATE TABLE qryCon (etc...)"
cm.ExecuteNonQuery()
cm.CommandText = "INSERT INTO qryCon SELECT ..." '(rest of query above without INTO line)
cm.ExecuteNonQuery
This DOES WORK:
cm.CommandText = "CREATE PROC qryCon AS SELECT ..." '(same select as above without INTO, again)
cm.ExecuteNonQuery
The CREATE PROC that does work is fine, except I need to insert data into it later, so I get errors about how I need an updatable table. I really want the end qryCon to be a table, but I can't seem to get that to work :(
*However, when I do something like this (using the stored proc (renamed) above which, if viewed in Access, is full of data)
cm.CommandText = "SELECT * FROM storedProc"
dr = cm.ExecuteReader
[code]....
This DOES NOT WORK! By the way, I removed the concatenation in the query for readability. It is correct in the actual project.
View 3 Replies
Jul 11, 2011
I was working on a MS Access database and had it complete, that is until my computer found its way to Windows XP repair and I lost everything -.- Anyways, I don't have Access anymore and I was wondering if I could use micosoft works as my database, or should I just buy MS office again? I got MS works for free, and I saw that I can make a database using that
View 3 Replies
Feb 24, 2009
When trying to get this program to filter appointments based on which doctor is selected,the code works fine with a sample database. When I try to use the database I have to, it doesn't show any appointments.
View 5 Replies
Feb 23, 2009
When trying to get this program to filter appointments based on which doctor is selected, the code works fine with a sample database. When i try to use the database I have to, it doesn't show any appointments.
Imports C1.Win.C1Schedule
Imports C1.C1Schedule
Imports System.Data
[code].....
View 13 Replies
Sep 30, 2009
Actually i have created setup but when it comes to connecton string that for access db i have written
View 2 Replies
Jun 4, 2011
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 value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Jan 10, 2011
What type of database?[code]...
View 1 Replies
May 7, 2010
I can't seem to find the correct words to search for an answer. I'm using VS 2010 so I have auto-implemented properties.I have a class and I want to access the properties by a string.
Public Class MyClass
Property Prop1 As String
Property Prop2 As String[code].....
But, I also want to be able to access the variables something like this way....
Dim MyVar = New MyClass
MyVar.Items("Prop1") = "Prop1 Value"
MyVar.Items("Prop2") = "Prop2 Vaule"
How can I setup MyClass to work both ways?
View 1 Replies
May 30, 2010
how to setup POP3 access that DOES NOT cost money! I have a program that needs to receive email.I have looked ALL over the internet for examples and have come up with NOTHING! Maybe it's about time we all pull together and finally put a solution out here for how to do it. I know it's not THAT complicated because I am a novice as is my roommate and we had an email program about 4 years ago and it wasn't that complicated then, so I don't imagine it is, however, I did not save that email program that we built so I can not refer to the coding again!
View 3 Replies
Dec 7, 2006
im making a setup project with my windows application. i have pack it but the problem is my database. how do i set there new targets once i added the mdb file. i know thats the problem but i really dont know how to reconfigure
another thing, when its already pack and when i try to run the msi, the interface has an error on the picture above. and whats the bootstraper for? why is it that clicking the bootstraper is an error.
also if my target machine doesnt have vb.net and ms access, would my project be still running in there? this is my first time in making setup projects.. im using vb.net 2k3.
View 12 Replies
Jan 19, 2012
I trained myself to program beginning in 1980 with the Basic language for Radio Shack's TRS-80 Model III.Later learned to program macros in Lotus 1-2-3, then taught myself DBase, then started Visual Basic.I've trained myself on Visual Basic up to VB 6.0.Now, as I understand it, Windows 7 and beyond will not support using VB 6.0. I have programmed many pieces of software we use in our offices.My software is Access Database intensive. I put the database on the server and we can connect from our various computers to the databases and work on the data as necessary.I've never gotten into Server/Client types of organization because I don't understand the server model and how to do that...For the sample databases one needs a server application running and I don't have one (Our server only has a standard operating system on it).
Now I was looking at Visual Basic 2010 and am totally lost.In VB 6.0 samples, I could put a break point (debug) and stop the program and examine what it is doing.now I don't even know where to put a break point..When I put one in the samples, the sample application loads and does not hit the break point...Is there anywhere I can learn how to move up to Visual Basic 2010?I don't want to have to quit my job and go back to school but it seems soooo different from VB 6.0.Just trying to figure out 'datasets' is a chore and to see how they work in the samples, I have to set up some form of database somewhere and it does not show me how.
View 13 Replies
Dec 15, 2009
1. What tools do I need to set up/create a database?
2. How do I set up/create a database?
3. Lets say I have some sort of "text" in my database. How would I get another one of my programs to connect to my database, and download the "text".
4. How would I "host" my database? I want my program to be able to connect to my database without having my computer on 24/7. must be free
View 2 Replies
Feb 10, 2012
I have written many programs and never really needed a database before. Just never came up. I am a self learned programmer. I have experience in using php and database on websites etc. I am currently writing a program in VB 2010 and need some assistance in using a database.simplest way to setup and use a database in VB. I would believe that it's better then saving "clients/data" to a file. . The software is being created only to be used on one computer and not over a network etc.
View 4 Replies
