I am creating a VB.NET application with the back-end of MS-Access. I have created manual backup of database.But now i need the help to create an automated backup of the database in the same application.
View 1 RepliesI 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 RepliesI'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
My boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form. How can I achieve this?
View 2 RepliesMy boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form.
View 4 RepliesIs it possible to access Application Properties of my applicaiton in run time ? Please refer the below attached image (I want to access the Title and Category properties in my application)
View 5 RepliesI am developing a project in which i have to access datagridview's value into my application
Now i am able to get the handler of window
i am also get able to handler of datagridview.
i am used findwindow & findwindowex functions
Now i want some guidelines :-
1.How i can access Column Count
2.How i can access row Count
3.How i can access values of datagridview
for listview there are built in class in win32 named as syslistview32
Is there any class for Datagridview?
Or By which Window class handle datagridview?
Or tell any other way to access datagridview values of Third Application By My Application.
I need to be able to interact with an application's GUI within another application. Basically, I would like to run an application and have it's GUI appear in a MDI-style Form in my application. Is such a thing possible? The reason I need to do this is because I need to access an application remotely without having to use Remote Desktop or similar tool. Any questions on this, feel free to post.
View 2 RepliesI've trying to access an appsettings key value in my vb.net 2.0 web application.I've put the key in the app.config file:
<appSettings>
<add key="DownloadURL" value="http://<myURL>/" />
</appSettings>
I've followed the instructions here, and it says that I need to access this key like so:
URL = System.Configuration.ConfigurationSettings.AppSettings("DownloadURL")
But I get the following message:
Public Shared Readonly property
AppSettings() As
'System.Collections.Specialized.NameValueCollection'
[code]....
I tried to replace the old method with the new one, but it does not exist.Strange, since I've done a similar thing with a web app and it did exist there.
im trying to update access from vb.net application. when excuting im getting this error: the microsoft.jet.oledb.4.0 source="c:...."provider was not registered on the local machine. when i go and run cmd to register ddl files. i was able to register msjet40.dll and msjetoledb40.dll with the other dll a box pops up: the module "c:..." was loaded but the entry point dllRegisterServer was not found?
View 2 RepliesI'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.
I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.
Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?
What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.
We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.
I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.
So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.
I have a web service that I will need to add as a web service reference in my vb.net application which is a plug-in to Outlook. I initially tried adding the reference by right clicking on the Project and selecting "Add Service Reference". In the box that pops up, I type the web service url in the address field and the namespace name and click ok.
Warning 2 Custom tool warning: Cannot import wsdl: portDetail: There was an error importing a wsdl:binding that the wsdl: port is dependent on.XPath to wsdl:binding: //wsdl:definitions[@targetNamespace='http://tempuri.org/']/wsdl:binding[@name='IAConnectServiceHttpGet']XPath to Error Source: //wsdl:definitions[@targetNamespace='http://tempuri.org
[code].....
I have sqlserver database in my server folder c:data How can i access this data from other computer with my vb application?
View 8 Repliesi am developing a vb.net application my question is how can i access a folder inside my application ?? for example i created a folder Myfold where i store some .doc files and i want to read them from my code.
View 1 RepliesI'm trying to print a barcode using the following code in Lightswitch Application[code]...
View 1 RepliesI have an application which is grouped in a MainApplication and serveral Modules (DLL's) The Main Application is basicly a Form with a NavigationBar on the Left Side (like in Outlook 2003) and an MDI-Parent. There is also a Simple Login Routine on this Form. I store the UserName after Loggingn to a Property. The DLL's holds functionallity and Forms for various Sections for example there is a Employee.dll which holds functions and a form to show all Employees.
On Loading of the Main Application I loop trough all dll's in a "Module"-Folder and extract NavigationItems from them which I add to the MainForms NavigationPanel. I don't have a reference to the Modules because I want to make it as flexible as possible so that it is possible to delete a Dll form the Module directory in order to remove the functionality from the MainApplication. The Modules could work also without the MainApplication if they are Complied as an exe insted of DLL of course. This works fine so far.
[Code]...
I need to check and see if I can access a file(the file is in use) So When I try to access it the application crashes. When I can access the file without the application crashing I would like a msgbox to pop up.
View 3 RepliesI need access to very precise timing in a .NET application. I need microsecond precision. Is there an easy way to do this in .NET?
View 5 Repliescan I have access to anivirus codes.
View 3 RepliesI am using following code to add my application to StartUp of Windows. It works well in XP but gives error in Vista that you donot have permission to edit registty file.[code]
View 1 RepliesCurrently following is the setup of my wifi connection.
Laptop 1 ------> Wifi Router <------
Laptop 2
There are about 5 laptops which connect to the wifi router to access internet. Network is password protected so anyone with a valid network key can connect and access internet.
I am planning to develop a local website which will be having a list of username and passwords. I will also remove the password of the wifi network so that anyone can connect.
If a connected system tries to access a web page in the internet then redirect them to a Login page (in the local website) and ask them to login. Once successfully logged i,n the mac id should be added to "Allow" list and monitoring starts. Internet should not be available for those who don't have a valid username and password.
I was thinking about developing the application to block/allow internet access though a vb.net/c# application.
I am okay with the website part. What I would like to know is
How I can block/allow internet access through the .net application. Is it possible in .net or should I be going for an unmanaged code development? If it is possible where is the best place to start? I have experience in winforms development but not much of network programming. Will there be any change in my current wifi setup? May be a new webserver/proxy server which will host the website and the windows application?
[URL] the CodeContextObject property returns a reference to the object from which the currently executing macro or VBA procedure was called. This may or may not be the active object.What's the equivalent in C# or VB.NET ?
View 1 RepliesHow can i connect my vb.net application to MS access database
View 3 Repliesi want to connect access 2007 database with vb.nett 2008 application ?
View 2 RepliesI have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
I am building a simple windows form application in Visual Basic 2010 with two tabs. It's a program that will allow a business to enter contact information for display to an end user client.
One tab displays the business contact information for the end user client, which I have the data filled from a App.config file.The other tab acts as a settings page. The business fills in their contact data on the settings tab for the App.config file.
Once the business contact information is entered into through the settings tab, I want to be able to restrict the end user client access to the settings tab.It doesn't need to be highly secure, just a way to prevent the average end user from getting into the settings tab.
I'm working on this project and i need to retrieve data from my access database and display it on my vb.net windows application
i tried the code below..but there are still some errors on it..
[Code]....
I need to launch a Microsoft Access 2010 application from within a vb.net program. My vb.net will need to pass the database password and I'm hoping to be able to have the user see the Access startup form and take it from there.[code]...
View 2 RepliesI have vb.net windows application. I want this app to be protected from being used remotly.Means some users on my network are using this app with remote desktop, some on internet use VNC viewr, team viewer or log me in to access this application.
I want to restrict this kind of access to my application. But I these users must be able to operate other functionality regularly. So can I write anything in my application so that i does not go over VNC viewer or team viewer or remote desktop
I am using attempting to create a connection to an Oracle database via entity framework in Visual Studio 2008. I am running 64 bit Vista Ultimate.At first, I had difficulty even making a connection to the db through Visual Studio, but eventually got things working by installing 10204_ vista_ w2k8_x64_production_db AND ODTwithODAC1110720, but only the minimal parts needed to interface via Visual Studio.I am completely new to this setup, so it's likely I have already made a mistake, but installing both packages is the only way I could create a connection via Visual Studio.I made the connection, and used the wizard to create a . edmx file. The model and associations were created perfectly, and I thought things were going to work well. I used the default name "Entities" as the reference name.[code]How is it that I can connect to the oracle db at every point except when I'm running the application?
View 2 Replies