Speed Up Remote Access

Oct 4, 2006

I have a database on a server that is accessed by mobile clients using laptops (broadband)
when out of the office. They use'virtual private network service' to do this.
(I did not set this up, I just design and program the front and back ends)
However some report a slow response time when retieving data from the database file.

Would 'Active desktop' be any quicker?
Any suggestions on how they might speed things up, would be most welcome
'Replication' comes to mind but I think their data must remain up to date at all times.

View Replies


ADVERTISEMENT

Remote Access

May 18, 2005

We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband.

I have been trying to find out the best way to achieve this over IP as we do not want the considerabe expense of leased lines. Originally we tried VPN but access seems to be very slow and appears to prohibit that route.

We were advised by our PC support company for one branch to use Terminal Services. However we do not currently have a powerful enough server to support these. We have a price for a server upgrade and it seems OK. I have since been advised by the PC support company at another branch that because of the upload speed on broadband (256Kb) Terminal Services would not be sufficient especially if we were using HTTP and VoIP over the same connection.

Looking at the various posts on this site it would seem that VPN and TS are suitable for some. Is there an easy way of calculating whether or not TS will work at our site? Has anyone gone down this route and found it not to work?

I'd be grateful for any feedback.

Thanks.

View 2 Replies View Related

Remote Access Through ADODB

Nov 8, 2005

Hi everyone, I'm just a newbie in DB programming and I'm having a trouble:

I have a database located in my IIS server: "c:inetpubwwwrootwebapplication1dbs1.mdb".

I'm also developing a VB6 app in another computer which will access to my IIS server to get data in my database. I'm using ADODB, but I don't know how to establish the connection as well as to get the data from the server (remote machine).

Can anyone in here help me by showing an example in VB6 code?
Thank you very much, any sugestion is welcome
Reply With Quote

View 3 Replies View Related

Trying To Speed Up Access Database

Jun 24, 2005

I have a database that is split into a FE / BE with the BE running on a server and users are accessing thru a dial up connection. This is working very slow do to the fact that I have combo boxes that users select data from that are based on different tables and every time you click on a combo box it takes several minutes to open deponding on the number of records. At 1st I thought that maybe converting to SQL would help solve this but the more I read the less I think that will do the trick. Could someone please advise me on the best solution here.

Thank you

Jim

View 10 Replies View Related

Remote Access To Database On Server

Sep 23, 2005

I have an Access database on my server. My client does not like the idea of having to download the db, make changes, then upload it back. In the past, he has dealt with SQL databases, where you can create an access data project, that will give you a desktop shortcut straight to the database. I was wondering if there was any way to do something similar with an Access database. There is FTP setup for the site and all required permissions are setup. Is there any way to create a desktop shortcut, so he can edit the database in real-time, without having to download and upload? Thanks for any help.

View 3 Replies View Related

Sharing Access With Remote Users

Jul 29, 2007

I have developed an application for a friend. We live about 100 miles apart in the UK. The database (Access 2007) works perfectly for us, I input data from various sources and he views the reports I've designed that show him exactly what he wants to see.

Now I want to move to the next phase which is I enter data from my PC at home and he then views the reports on his PC at his home.

Any advice on how I can do this, at low cost,

View 2 Replies View Related

ACCESS 2003 & SPEED Ferret

Jun 29, 2006

We have SPEED Ferret 4.1, but we've upgraded ACCESS 2003 which 4.1 does not support. Does anyone know if a new version's coming out? Does 2003 have its own enhanced find and replace functionality?

View 1 Replies View Related

Remote Access To Access 2000 Database

Feb 20, 2008

Hi,

I am doing some computer work for a company that has an Access 2000 application. This app is split up between a program database that contains the forms, reports, etc. and a data database. Both the program database and the data database are located on a Windows 2003 teminal server. There are usually two or three remote users logged into the terminal server, but this number is about to increase to 6 or 7. I am concerned that these user's will all be running the same copy of the program database. I have read that this can lead to performance problems.

I was wondering if anyone hear thought either of the following would be an improvement:

1. Put a separate copy of the program database in each user's profile on the terminal server.

2. Rather than keeping the program database on the terminal server, put a copy of it on each of the remote client pc's. Then set up a VPN connection to the server and use this to link to the data database.

If anyone could tell me if either of these options would lead to improved performance, I would really appreciate it.

Thanks in advance,
Paul

View 2 Replies View Related

Remote Deskptop Connection To Access DB On Server

Apr 10, 2007

HiI currently have an Access Database in a BE/FE, server/client LAN architecture at a single office location. My client would like to allow one user to 'add new records' to the database on the weekends (i.e. after hours), without needing to come into the office.From my research, it seems I can setup Remote Desktop to connect from the client's home PC directly to the server PC, across the internet, using Windows XP Professional on both computers. Is it that simple, or should I be considering other things?

View 5 Replies View Related

How To Get Data In Access Table From A Remote SQL Server

Jun 10, 2007

Good evening,
my web site (in hosting) stores data in a SQL Server database.
Now, I've and import these data in an Access application and, of course, I've no direct access to SQL Server instance.
I thought about using Web Services. Does anybody know how to do, or has an alternate way?

View 1 Replies View Related

Downloading A Report From Access On A Remote Computer

Jul 15, 2015

I have a database on a remote computer that has several reports that can be generated. Is there anyway to create a PDF of one of those reports and download it to my main computer?

View 4 Replies View Related

Connect An Access Project With A Remote MDB Or SQL Server Database

Jan 28, 2007

Hi,

I am finishing an Access database for a customer that may want, in a later stage, to have a website(probably ASP) that would connect on the same database. Is that possible? I mean can an Access project on a pc connect to remote database(mdb or SQL server) used by the website?

If so can you give me some quick steps to do so or a good article on it?

Thanks.

View 6 Replies View Related

General :: Split Database Sharing And Remote Access?

Aug 4, 2013

I've just split a database into the front-end and back end components. But how to distribute it further.

Additionally, I need people who have the front end to access the database from their homes, not just from work.

What would I need to use?

Is there anything available for free?

View 3 Replies View Related

Hosting The Access File On A Server And Having Multiple Remote Users

Jun 4, 2007

I am making a database to coordinate the activities of my band (how rock and roll!)...

Is there a way I can somehow host the file remotely, and have users (4 total) access that file through their own computer using access, so they can write, edit, delete records?

We have a db at my work that we use like this, accessing from multiple computers, though this is on a network drive.

View 2 Replies View Related

Mdb On Remote FTP

Jul 11, 2006

I've been looking around and it seems to be impossible to connect to an mdb file on an ftp (for Access 2002 and below). I'm using Access 2003 so does anyone know if it's possible in this version?

View 3 Replies View Related

The Need For Speed

Oct 18, 2005

Hi,

I have a growing Access database in a multi-user environment over a 10/100Mb network. The database is all in one file at the moment, on a shared directory of our XP-Pro 'Server', and the workstations have a mapped drive to it and are W98SE machines. All the machines are 1.2Ghz Fujitsu Siemens machines.

It is still under development, but is also in constant use, and I therefore have to develop on a copy, then get everyone out so I can copy in the changes. I would love it to be a client/server setup and split the db to Tables only backend on the server and progams on the client, but when I tried, the result was a dramatic slow-down in the system...it became unusable.

I do have a budget for this, and could get a proper 'server' or maybe an Ethernet Disk, but what is the best config for speed and admin purposes. Anyone doing something similar??

Thanks

View 14 Replies View Related

Speed Of Calculation

Apr 5, 2007

Hey,

I noticed something strange in access 2000: sometimes it takes a long time to calculate a report and other times it goes rapidly. I don't see any process taking a lot of CPU %.

When i do the same thing in Access2003, it goes rapidly every time.

Can anyone help me?

Rik

View 1 Replies View Related

Query Speed

Nov 2, 2005

I have a number of queries which build two or three Union queries which looks at 35,000 records, and when you open the Union queries or run reports it takes forever for them to open.

I have indexed all the tables which have the common fields to see if this speeds it up the queries, but there still slow. The table they look at are in two different tables which are linked into a front end where the queries are!

View 2 Replies View Related

Query Speed

Mar 24, 2006

I query against a table with 380K records and growing.

There are approx 14 fields in the table, but I only retrieve 7 in my query. Does having those extra fields in there slow the query down, or does the query ignore them?

Just trying to figure out ways to improve speed.

Thanks.

View 3 Replies View Related

Speed Question...

May 23, 2007

Which is faster, placing a calculation
ItemNumber: IIf([MANITEMNO]<>" ",[MANITEMNO],[ITEM])
in a query or placing
=IIf([MANITEMNO]<>" ",[MANITEMNO],[ITEM])as a Control Source in a text field on a form or report :confused:

View 12 Replies View Related

Dlookup Speed

Dec 19, 2007

I was brought up to believe in Santa Claus and that DLookups were slow. I browsed last night and found many threads mentioning speed issues with DLookups.

My latest project consists of upgrading a database written at a Client Site that is chock full of (you guessed it) DLookups. My normal inclination was to replace them with parameter queries. But before I did, I ran some benchmarks of DLookup vs Parameter Query speed. In all cases (table1 = 11 records, table2 = 1,143 records) the DLookup was faster.

My test was to lookup a field based on the recordset's primary key. In table2 I tested a record mid way down and the last record. DLookup is the winner hands down.

Should I also stop believing in Santa Claus. Too bad because I have a new notebook on my wish list.

Thanks for your wisdon.

View 1 Replies View Related

Database Speed

May 24, 2005

Can anyone offer suggestions as to why, when I split my db, place the backend on the server, and open Form2 my front end grows from 2.25MB to 3.95?

I was using macros to filter the data for each type of project and that does not affect the db size nearly as much as this does.

I am using the following code on the On_Click event of the "View Projects" button on Form2 to build the criteria for the records to appear on my "Projects" form.

Private Sub cmdOK_Click()
Dim varItem As Variant
Dim strSubtype As String
Dim strStatus As String
Dim strSubtypeCondition As String
Dim strSQL As String
Dim strSortOrder As String
Dim cat As New ADOX.Catalog
Dim cmd As ADODB.Command

For Each varItem In Me.lstSubtype.ItemsSelected
strSubtype = strSubtype & "," & Me.lstSubtype.ItemData(varItem)
Next varItem
If Len(strSubtype) = 0 Then
strSubtype = "Like '*'"
Else
strSubtype = Right(strSubtype, Len(strSubtype) - 1)
strSubtype = "IN(" & strSubtype & ")"
End If

For Each varItem In Me.lstStatus.ItemsSelected
strStatus = strStatus & ",'" & Me.lstStatus.ItemData(varItem) & "'"
Next varItem
If Len(strStatus) = 0 Then
strStatus = "Like '*'"
Else
strStatus = Right(strStatus, Len(strStatus) - 1)
strStatus = "IN(" & strStatus & ")"
End If

If Me.optAnd.Value = True Then
strSubtypeCondition = " AND "
Else
strSubtypeCondition = " OR "
End If

'Build the sort order

If Me.cboSortOrder1.Value <> "Not Sorted" Then
strSortOrder = " ORDER BY tblProjectDetails.[" & Me.cboSortOrder1.Value & "]"
Else
strSortOrder = ""
End If

'Build the SQL statement

strSQL = "SELECT tblProjectDetails.* FROM tblProjectDetails " & _
"WHERE tblProjectDetails.[subtypeid] " & strSubtype & _
strSubtypeCondition & "tblProjectDetails.[status] " & strStatus & _
strSortOrder & ";"

cat.ActiveConnection = CurrentProject.Connection
Set cmd = cat.Views("Query1").Command
cmd.CommandText = strSQL
Set cat.Views("Query1").Command = cmd
Set cat = Nothing

DoCmd.OpenForm "Projects", , "Query1"

I have cleaned up my code, compact and repaired, compiled, got rid of unneeded tables, queries, etc. and no change.

I have read up on all of the possible causes/solutions and can't seem to narrow it down.

Thanks for any help,

Toni

View 2 Replies View Related

Speed Issues

Dec 27, 2004

I am making a internet-game. It has for every register player quite some variables stored in a database.

On nearly all pages the database is accessed, modified and closed again. Let's say each player has 20-25 variables stored in the database. Would this cause speed problems? Any ideas to solve this?

View 2 Replies View Related

Creating Unique Id On Remote Pc

Aug 21, 2005

Hi all,

Got my job database going quite well, at the moment, it generates a job number form the first 4 letters of the customers name, and the ID (autonumber), so for example mr smith's job number would be SMIT0012 (assuming the 12th entry in the database)
Now this works fine, tables are linked and the database access the tables via a mapped network drive for other pc's (2) to use. But the problem is, if the database user were to be at a remote location with a laptop, how could this work? I could use a local copy of the tables but then of course the ID's wouldnt match! Can anyone offer any ideas on this?

Thanks

View 3 Replies View Related

Set Linked Tables On Remote PC

Nov 6, 2007

I have an Access database which we inherited and it has linked tables (2 database files, one with data tables and one with forms, queries etc) - the links being set to a path on our local company server. We are in the process of opening another company office in another part of the country and we want to use the same database system. I have taken a copy of the database, cleaned out all the existing data out and now need to send the blank database to the new office. Is there a way of forcing the database to reset its table links when it runs in the new location (or pre-defining the paths before it is installed)...rather than my physically having to go to the new office to use the Link Manager when in situ.
I wondered in fact whether was a way of holding the required path statement in one of the tables so that the links could be easily reset on any future installation. I do not know how to code anything like this or set it up - I am new to Access databases
Could anyone advise please.

View 2 Replies View Related

Local Query - Remote Db.

Oct 10, 2005

Ladies and Gentlemen,
I'm sure you gurus have an answer for me.

I have a MDB (MS Access 97 db) on a shared drive. All my data resides here.
I have a local MDB (MS Access XP db) on my hard disk. Currently, I have queries located on the shared MDB that puts out a table. I then execute queries on my local DB, linking to the table I have on the shared db.

My requirement is this.
1. I want to be able to run queries against the shared db from the local db.
2. When the create table query is run, I would like it to create the table in the local db. I can live with creating the table in the shared db, but local would be better.

I'm sure that this can be done. I've seen it. But, that has always been a client/server system.

Thank you.

View 1 Replies View Related







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