Topics Search

Make application run on network computer not on local computer

Make application run on network computer not on local computer
Views: 12
What I would like to do is click a command button on a form that would open an application, "RealPlayer", on another network computer and play a .wav file on that computer. I currently have a command button on a form with a macro RunApp and the argument "[LINK]" "[LINK]" however it opens up on the local machine and plays the wav file.

The formprints out to the network printer beside this network computer, and this would give the person an audible signal that the form is printed and ready to be looked at.
Sponsored Links:

Similar posts...


Windows 7 scheduler

Windows 7 scheduler Icon
I recently migrated a local SQL Express database to a network SQL Server. I re-did the links to my Access program and everything was running correctly when I was working with it. I tested all the functions and procedures and everthing was running correctly, but the scheduler that I had been working with on windows 7 is now no longer running.

The code works just fine when I log in and run the the scheduler and has been running correctly for month's on my local computer.

The problem seems to be that when I try to run on a scheduler in Windows 7 there are no network connections.

Anytime I try to connect to a folder on the network the procedure fails when running on the Windows Scheduler.

split/link/synchronize what the deal

split/link/synchronize what the deal Icon
I’ve worked far too many hours to say and am now ready to put into action. I have multi uses that will use the db on our in-house network. So I plan to split the db.

However I have other uses that must use the db that can not access the network.
1. split the db
a. Main be on the network
b. Make multi copies of fe for all the others including off network. 2. Make replica for the off network db from the be on the network drive.
3. Copy to offsite computer and Re link the off network db with the replica | db.
4. Copy the replicas to the network drive daily and synchronize with the be on the network. (our network is to slow to work online)

Recordset not updateable : one of the computers on the network has read-only access

Recordset not updateable : one of the computers on the network has read-only access Icon
I am having a problem with a network computer unable to update data in any linked tables. I recently separated a database into a frontend and backend, linking tables from the backend mdb files to the frontend mdb file.

The problem is one of the computers on the network has read-only access to the frontend mdb file whereas a different computer on the network as well as the host computer have full access to the database.

At first I thought the problem was read/write permissions for the computer on this network drive, but that is not the issue. I can add/delete/modify files on the drive from this computer.

VISTA and Jet Access problems...

VISTA and Jet Access problems... Icon
I have an app that has run on my XP computers for years. Not a single problem at all. Well, I just added a new computer to the network, and it is running 32 bit VISTA. The program accesses a database over a wireless network, so all computers share the same database through the network. the time I change a couple records from the VISTA machine, the database gets corrupted somehow.

I then have to go in to access and compress and repair the database. This will then work on the other computers, until I go use the VISTA computer again. I can't figure it out for the life of me.

1. Has something changed with VISTA and JET support?
2. Could there be a network issue with VISTA that is crashing the data?

Problems with network rights and Access

Problems with network rights and Access Icon
I am developing an application that will be used on a network with Windows XP as the OS. We will be upgrading to Windows 7 soon. I am having issues with the network security. I get thewarning for a non trusted location and a major part of the application uses Word merge documents which don’t work on the network.
If I logon to the local PC with Administrator rights the program works fine. If I logon on to the local machine with “Power User” rights – it fails. I have given myself Administrator rights while logged on to the network – fails.

I have removed runtime as a factor but it doesn't’t matter. I have tried everything I can think of with Trusted Documents – it doesn't’t matter. Nothing I have tried with Trusted Documents seems to fix the problem.

Why will my database work on some computers but not others?

Why will my database work on some computers but not others? Icon
I have created an Access 2010 database and packaged it to run on Access Runtime Viewer 2010. When I install it on some computers, it works fine. On others, it doesn't work. But some of the computers that don't work and do some things but not others.

So far I have gotten two different error messages. First I get a "Unknown function 'Date' in validation expression or default value on 'tblACHFiles.DateEntered'." Then later I get another error message that says "Execution of this application has stopped due to a run-time error.

The application can't continue and will be shut down." The part that stumps me is that it works on two computers.

At first I thought that there was something on my computer that allowed me to make it work so I installed it on another computer and it worked.

One interesting note is that the two computers that I have gotten it to work on are in a workgroup while the computers that it doesn't work on are part of the network domain.

The back-end of the database is stored on a server in the domain. I checked the permissions on the folder containing the BE and it gives Read/Write/Execute/Modify permissions to everyone involved.

Linked table structure idea

Linked table structure idea Icon
Just something that occurred to me as I was working, more of a discussion that a problem.

We use a frontend to backend connection. each copy of the frontend is held on each users local computer (in the D: drive), and has linked tables pointing to a folder on a file server(nothing special, just a normal server for holding documents).

We do have 60 users adding and amending records. At times (such as logging out time) the database grinds to a halt due to network traffic (as the users computers are restricted by the server being held up).

If the backend files are made local (as I often do when developing) the speed is massively increased.

Rather than link to the server for the backend, the key tables (the ones doing most of the adding and amending of records) are duplicated on each local computer. When the user loads theprogram in the morning, all tables are updated.

Validate User Current DB Version against Network DB Version

Validate User Current DB Version against Network DB Version Icon
I am in the process of attempting to create a means to automatically check to see if the user's local DB is the same version as the network DB. This is for my Front End DB only. Currently, we use a Run.mde file to copy the current database from the network location and then opens the local DB after copied.

This is to ensure that our users have the most current DB each day incase there are any changes (doesn't require me to notify everyone when a new DB is available for download).

The problem is that my Front End database is looming around 40 - 50 mb in sizeand is taking some time to download.

I plan to keep this Run.mde database in place but am trying to set it up to compare a .txt file on the local pc vs. a .txt file on the network location. The filenames of the .txt fileswould contain the database version number, for example: 2.0.00.DBVer.txt

Close the Access DB present in network quickly.

Close the Access DB present in network quickly. Icon
I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.

I have a local copy of the access app. When I close the app, it takes only a few seconds. But when on a network drive, it is taking 2 mins.

I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.

Introduction lesson-1

Introduction lesson-1 Icon
Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage all data, or in an enterprise to communicate with servers.