Optimize Ms Access On Network?

Nov 1, 2010

Is it possible to use a string as an array? I mean:' I have several arrays

Dim a10() As Integer = {530}
Dim a15() As Integer = {370, 231}
Dim a20() As Integer = {305, 176, 126}

'I declare a variable as a string and I assign the name of an array to it

Dim tablaalfa As String = "a10"

'I retrieve data from the array using the name of the variable instead:

lbl1.Text = tablaalfa(2)

I guess it doesn't work in this way?

View 3 Replies


ADVERTISEMENT

VS 2008 Network App - Send Message Or Network Package To Some Of The Clients In The Network

Aug 18, 2009

Here is my idea so far: I have a bunch of computers connected in a local network. One of them is a MySQL server, one will have a vb.NET program wich will act as a "second server" and the rest will be different clients. What I want to do is that the "second server" will send out some kind of message or network package to some of the clients in the network, and they will execute a code based on what message it is, or what kind of package it is. I'll give you a simple example:

[Code]...

View 6 Replies

Access Form Across A Network?

Apr 18, 2009

In my app, I need two separate items. I need one item to be the administration panel that can edit information being shown on a remote computer, and I also need another item that will display the information. How do I get my program to talk across a network to edit the information being shown on computer 2? I'll also need to know then how to make the installer ask which part of the program it needs to install, and then install the appropriate part.

View 1 Replies

Network Access Is Denied?

Jun 4, 2009

Using either VB6 or VB2008.I'm try to run a "Ping" program. In VB6, I'm using "IcmpSendEcho". In VB2008, 'm using "System.Net.NetworkInformation.PingReply".Both have worked on the same machine before.Now I'm getting "Network access is denied": Error: 65.I can ping 127.0.0.1, but not my actual IP address. I can run a CMD line PING xxx.xxx.xxx.xxx and it works every time.Can someone assist as where and what I need to change to get these to work properly?The VB6 version works on another machine. (haven't try the 2008)The OS is XP Pro Sp2 TIA

View 2 Replies

Trying To Access A Network Folder Via UNC

Jan 20, 2012

i am trying to access a network folder from my ASP.NET Intranet web application.[code]How can i enter my username and password in order to make it work?

View 2 Replies

Access Network Files Authentication?

Jul 16, 2009

I'm writing a program to examine logs of various servers on our network..they're not on our domain but i can map a drive to them by authenticating each time from my LP (which is on the domain)

my question is... how do i perform that same authentication with VB..

[Code]...

i'd like to either have a pop up box to auth as i would when i browse to the remote PC... OR be able to set it statically in the code (the servers all have the same admin login + password)

View 1 Replies

MS Access Slow In Network Share

Dec 26, 2011

I have a .NET application (VB.NET) that runs against a MS Access database. Every data request connects to the access database, runs and returns the query and closes the connection back again. I placed the database on a windows xp 32-bit machine. I have two clients on which I installed the .NET application. Both clients are running windows 7 professional 32-bit. Now I have a performance problem with this.

When I use the first client it runs fine. All data is shown very fast. When I than use the second client, it takes some 10 seconds to connect to the database, fetch the data and close the database connection. When i ask for other data on that second client, it all runs fine, until I request data from the first client than back again. Than it takes again 10 seconds on the first client before my data is fetched.

View 2 Replies

Network Shared File Access And WCF?

Oct 1, 2009

I wrote WCF method that check whether file is available or not. File is on the network drive. "\orl-avqaAVIPHist_Images2009h010109000379.fim"When I am checking file is available or not. Web service is returning me "file not found"let me know what should I do to fix it.

Public
Function getFileExists(ByVal fileName
As

[code]......

View 12 Replies

Use My.Computer.Network.DownloadFile In An Access Db?

Mar 24, 2012

I'm trying to download a file from the internet by clicking a button in MS Access.

I'm trying to use My.Computer.Network.DownloadFile as described here: [URL]

Private Sub Command2_Click()
My.Computer.Network.DownloadFile("http://www.example.com/temp/xml_test.xml", "C:xml_test.xml")
End Sub

but the 'Microsoft Visual Basic for Applications' IDE that I'm typing this into seems to have no idea what I'm talking about (text just turns red).

Can I just not do this through the built in VB editor or can I simply load a library or something to make it work?

Sorry but I'm very new to VB and to Access so search results are not specific enough for me to understand - lord knows I've tried.

I'm using Access 2010 but the DB was created in an previous version - not sure if that matters.

View 1 Replies

Intercept File Access On A Network Share In .NET?

Feb 24, 2010

I am looking for a way to possibly intercept the point that a file is being accessed on a network share. Specifically before it is determined whether the user has access to the file or not.The goal will be to grant access to that file if the file request is coming from a specific process and that user currently does not have access.

View 1 Replies

Access 2003 Network With Multiple Users

Apr 30, 2012

I know my Question was asked maybe 10000 times before, but i really did not take the chance to search the forum coz i really short of time.
I have *.mdb DataBase with 20 tables each table have more than 10 fields, i'm trying to automate the MDB file from a network like that 5 PCS + One vb.net exe program (5 users) working on the same time on the exe that is connected to the database , my questions are :

1) How much risk is it to put the database into one (shared) folder and connect it to the program ?

2) What is the best way to establish this method ?

3) Is there any alternatives ?

View 4 Replies

Connect MS Access Database From A Network In 2005?

Jul 6, 2009

I want to connect an access dabase from a central server using vb.net 2005.

View 1 Replies

MS Access Database File On Local Network

Jun 22, 2010

I am working on a project based on networking. My problem is that database on server (time to time updated by clients Application) is available in shared folder sometime any client delete that database file from shared folder then project stopped working. So give me process for accomplish this problem is there any way through which is database on server work invisibly and client unable to delete that file. I tried read only attribute on shared folder then my project unable to insert record in that database file.

View 1 Replies

VS 2010 Network Access And Manipulate XML File?

Mar 4, 2011

How i can access and manipulate XML file in server from client application over lan network ?

View 3 Replies

Communications :: How Could Access A Webcam On Another Computer Withing Network

Oct 29, 2009

I'm trying to figure out, how I could access a webcam on another computer withing our network. It could be P2P as well.

View 1 Replies

How To Access Network Drive Through Usual System.IO Classes

Feb 28, 2010

My software handles multiple operations on files, and I have now finished writing the related functions, using the System.IO classes. I now need to add support for network drives. Using a mapping works very well (although Directory.GetFiles is a bit low, and I don't know why), but I'd now like to be able to deal directly with paths such as \192.168.0.10Shared FolderMyDrive. Is there any way to handle this type of paths other than mounting the drive to an available drive letter, using the newly generated path, and then unmounting?

View 4 Replies

Mysteriously Lost Access To A Mapped Network Drive?

Aug 5, 2009

I had a basic text file reader/writer program that wrote and read from a mapped, shared drive up and running for a couple weeks. I wanted to add just a couple more things that shouldn't have effected the program (the ability to write another text file), and now the program can't find the shared drive. The error I get is: Could not find file '<file location>' with <file location> filled in with either the mapped name of the drive (X:) or the unmapped name (\servercomputer). Both are copied directly from windows explorer, so I know the path is right. I'm a bit of a beginner, but I'm pretty sure that all the required permissions are in place, and all users have access to this drive.

To further complicate things, it is not consistant. Some commands appear to have no trouble reading off the mapped name, but don't read the unmapped name, and vice versa. Others won't take either. Sometimes the code will execute perfectly up to the middle of the code (accessing the shared drive a couple times), and then it will give this error. If anyone could point me in the right direction,

View 1 Replies

Network Program With Access Works On PC But Not On Thin Client?

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

Possible To Have An Access Back-end Database Available For Multiple Users On The Same Network?

Nov 5, 2011

I am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?

View 2 Replies

VS 2008 Connect To A Database On A Big Corperate Network (access Db)

Mar 3, 2010

I'm trying to connect to a database on a big corperate network (access db). I can not load my application and DB on a shared network drive as it does not have the correct permissions. How else can I try connecting to a db of some sort and allow users to insert/edit/delete rows? as it's a network drive I can not install a DB such as SQL Server on it.

View 4 Replies

Optimize Waypoints For More Than 25?

Sep 10, 2010

I need to order lists of up to 100 addresses in optimized order. Is there a way to do this since getdirections is limited to 25? i don't se any way around this 25 limit. Is there one I'm missing?

No I'm trying to use MapPoint object model but it crashes as well with this many waypoints. Here is my example proof of concept code from Excel:

Sub OptimizeRoute()
Dim objApp As Object 'New MapPoint.Application
Dim objMap As Object 'MapPoint.Map

[Code]....

View 2 Replies

Way To Optimize My Algorithms

Sep 28, 2009

I had been working on a project that would generate a loan schedule.

But, It needs to factor in specified holidays and weekends.

Now, when running with a small 'term', it seems to work fine.[code]...

View 14 Replies

Will The Compiler Optimize This

Mar 8, 2012

Consider this

bar = 1
foo = <1 or 2, depending on previous code>
if foo=1
while bar <= 5

[code].....

What I want to know is, is the compiler smart enough to optimize away the (apparently) repeated tests for "foo = 1" since foo is not modified in the body of the loop?If so, I might use the second construct since it is semantically equivalent (I think!), takes less code and reduces indentation levels.

View 6 Replies

Your Network Access Was Interrupted - To Continue Close The Database And Then Open It Again

Nov 23, 2009

I have an access 2007 database that I have been developing a front end for in vb.NET for the past 3-4 weeks using vs2008 in a Windows 7 enviroment. Yesterday I started getting an error of "Your network access was interrupted. To continue close the database and then open it again." This happens in the Form Load on the line:

gotData = Me.LeaguesTableAdapter.Fill(Me.LeaguesSeasonsPlayersDataSet.Leagues)

I can go into access 2007 and view all the data fine and in vs2008 I can view the server explorer and browse the tables. However, under data sources if I try and preview the data, I get the same error message as before. What confuses me the most is that the database is not stored on a server is just stored in My Documents. It was origionally stored on my desktop pc but has been copied to the My Documents on my laptop. But as I mentioned previously it has been working fine and has just all of a sudden started throwing this exception by my Try Catch routine. FYI I have tried creating a new DB and importing the tables from the old DB but this hasn't solved the problem either.

View 4 Replies

Optimize Linq Contains Method

Apr 1, 2012

I need a list from OldGuids that are not in the NewGuids, so I used the Contains method, the problem is that it is already running more then half hour, is there a faster way? or how much longer would it take about? [code]

View 2 Replies

What Are Things Vbc.exe Does When /optimize Switch Is Used

Mar 6, 2012

vbc.exe has something called /optimize switch right. If I enable that what are the optimizations the compiler can do for me? The MSDN documentation just curtly says 'does various compiler optimizations'. Where can I find the complete quantified view of the different optimizations that actually goes into.Here is the thing I am pursuing this route. One of the code blocks in a module I am leading has a lot of delimited array manipulations. I believe this is going to be a heck costly in terms of string memory handling. I am looking to see if I can retire them by way of simple properties or methods so that the compiler can internally do something like our c++ inline functions making a best win-win offer in terms of both memory and processing time. I admit when the compiler translates them as inline function, the JITed code might be big in size right?

View 7 Replies

Access A Web Server To Download A File But My.computer.network.downloadfile Not Working

Dec 27, 2011

I'm trying to access a web server to download a file, but when I run the statement gives me the following WebException:

[Code]...

View 7 Replies

Error In Getting Installed Software On Local Network Systems Access Is Denied?

Mar 26, 2012

Dim wmins = ("//192.168.1.5/root/cimv2")
objOS = New ManagementObjectSearcher(wmins, "SELECT * FROM Win32_OperatingSystem ")

[code].....

View 1 Replies

.net - Optimize This Simple But Horrible Implementation?

Jul 27, 2011

I basically want to remove the formula from the cells but want to retain the calculated values.

SO, I implemented it easily and it works great but REALLY SLOW. (About 2 mins for 1800 cells)

I have : Dim col As Excel.Range = getRange()For Each cell In col cell.Value = cell.Value Next

I tried to do this to the first cell and then autofill the rest, but that copied the value of 1st cell to the rest of the cells in column.

View 7 Replies

How To Optimize Simple But Complex Looking Implementation

Jul 28, 2011

Want to dump a fetched table to a excel sheet. [code] I am new to data fetching and ADO.Net concepts and just got it working.But. This seems to be very inefficient and lame to me. So, can you help reducing the complexity and may be improve performance ? A totally different (Better) implementation is most welcome !

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved