Mapped Drive Converted To UNC Is Slower

Nov 23, 2005

I have my database connected to a network of ten computers. I recently switched my linked tables from a Mapped Network Drive to using the actual UNC path \computerfolderdatabase.mdb

My users have started to notice it takes longer for the database to connect in order to log in. Once they have established the connection, the data transfer speed seems to be normal.

Is this to be expected? Any suggestions to speed things up for login? Or is this the downside to using UNC?

~Scott

View Replies


ADVERTISEMENT

Modules & VBA :: Temporarily Map A Drive / Copy A File Then Remove Mapped Drive

Aug 29, 2014

My workaround was to temporarily map the URL to a vacant drive letter on the local machine, then copy the file over, then drop the mapped drive again. A bit clunky but doesn't incorporate much of a delay and this download only has to happen once per day.

The good news is, the file download / copy now works every time. The bad news is that removing the temporarily mapped drive after the copy has taken place, doesn't and I can't figure out why.

Here are the functions I use to map / unmap the drive :

Code:

Option Compare Database
Option Explicit

Private Const RESOURCETYPE_ANY = &H0&
Private Const CONNECT_UPDATE_PROFILE = &H1&
Private Const RESOURCE_CONNECTED As Long = &H1&

[Code] .....

I have separate functions to check existing drive mappings on the local machine and thus determine an appropriate vacant letter to use for the temporary mapping - they work fine.

Unfortunately the UnMapDrive function returns False (even though I switch the active drive to C: and force the connection to be cancelled with the fForce flag) So the mapping always remains on the users profile.

I don't want to permanently map drives on the users' profiles, just briefly for the purposes of this daily file download.

View 11 Replies View Related

Database Does Not Open Via Mapped Drive

Oct 30, 2007

As the thread title suggests, my problem is that I have a database that will not open via the mapped drive. There are other databases stored on this drive that open fine so it is only the one database that is causing me a headache.

Any suggestions as to why only this one database would be having this problem and any ideas on how to resolve it would be greatly appricated.

Thanks

View 3 Replies View Related

How Do I Link To Backend Db Without Using Mapped Drive Letter

May 16, 2005

Hi:

I have a front-end and back-end database.
Front end is at //fserv/database
back end is at //fserv/database/administration

I have sent front end path to users and they can bookmark it to find front-end. When I linked to the backend in the administration folder I had the path mapped to drive T:

Problem is the users do not have this same mapping to drive T: They may have other paths already mapped to that drive.

The users are getting the message:"t: est.mdb is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides."

Is there anyway to link the the backend tables using just a path like:
//fserv/database/administration

Thanks in Advance!

Steve

View 3 Replies View Related

Modules & VBA :: How To Hide Mapped Drive With Code

Nov 3, 2014

So I do map drive on this way and it is successful ...

Code:
Dim FSO As Object
Dim objFile As Object
Dim objFileS As Object
Dim WshNet As Object
persistent = false
set objNetwork = CreateObject("WScript.Network")

objNetwork.MapNetworkDrive "driveletter:", "serversharename", persistent, "username", "password"

But I need to have mapped drive hidden from the client users So I red that i might be possible if put $ after the share folder

Code:
objNetwork.MapNetworkDrive "driveletter:", "serversharename$", persistent, "username", "password
"
but it does not work.. the other way is to set values in win registry, but I don't like that way...

View 1 Replies View Related

Linking A Table Using Server Name Instead Of Mapped Network Drive

May 20, 2013

I am attempting to link a table in one database to another database using the server name designation (ie.//2sxfprinff01Group) instead of the mapped network name (ie. G:). I tried relinking using the Access Link Manager. Right click on the linked table. But it does not let you edit the link.

Access 2007 does not allow this and reverts links to the G: drive. There are situations where the the IT department have set the mappings to this shared location as an H: for some of the employees. In those cases, the employee gets an error message telling them that Access cannot locate the G: drive.

An obvious solution is to get the employees remapped to the G: drive. However, one would think that MS would have allowed for mapping to the designated location and not an alias.

View 3 Replies View Related

Access DB Not Opening If Specific Drive Letter Not Mapped

Mar 25, 2015

I've inherited a few Access DB monstrosities. One of which had ODBC credentials hard coded in the MDE which I had to recently update due to some server updates. I found an unsplit version of the Access DB on a development drive (j:db...) and updated the credentials hard coded in VB and updated the linked tables from the J drive path (dev) to the K drive path (prod). I then split the DB and the MDE worked fine for me. I quickly found out that it only works fine because I had J mapped still. End users do not have the J drive mapped (development) only the K (production). Without the J drive mapped to the actual dev path the Access DB simply doesn't load. No errors.

I then tried to find any references to J in VB and fix those. At this point I can't seem to find anything else that could be referencing the J drive but still the DB will not open without J mapped.

View 3 Replies View Related

Modules & VBA :: Copying Records From Linked Table / Each Record Slower And Slower

Jul 30, 2015

I have an access db with a linked table (to Sharepoint) which contains about 15000 records. I have to copy those records to the local access db. To do this I have a bit of VBAcode. It works, but for each next record that is copied it takes a bit longer. When starting the program the records are copied quite fast, but soon you see it slowing down until after a couple of thousand records it just goes too slow to be usefull, meaning it would take a lot of days to copy all records.

What I now do is let it copy 500 records and exit ms-access completely and then start it again and let it copy the next 500 records. This works but is tedious as I have to do it about 35 times. Why this gradual slowdown occurs?

The VBA code is pretty straightforward.(I use VBA because I do a bit of data wrangling while reading in the values of the records)

Code:

Dim importdb1 As DAO.Database
Dim rsimportdb1 As DAO.Recordset
Dim i As Double
Set importdb1 = CurrentDb
Set rsimportdb1 = importdb1.OpenRecordset("2015")
Set rsMain = CurrentDb.OpenRecordset("tbl_import")

[code]....

View 3 Replies View Related

Query Has Become Slower

Oct 4, 2005

I've got a database with 1.5 milion orders. In those orders there are also customer information. Now i want to filter the customer information. In a older backup from my database when i run the query i takes about 22sec. But my new database it takes 2 min. (Both have 1.5 milion orders).

I haven't got a clue why i've got this problem. I've put some indexes on the table (didnt work) so i deleted the indexes from the table. I also put some relations to the tables.

But the strangest thing is that the status/progres bar in the leftbottom screen go's immediately to the end of the bar, and there it stops for 2 min,
The old db does this in steps...

My operating system is winxp with sp2
And access xp

I also want to know if it is possible to get clusted indexes in access. Because i cant get the integrity in the relationship diagram. (the database isn't normalised this is because i didnt make the database)

I'm sorry for my crappy English.

View 1 Replies View Related

The Higher The Database Size, The Slower The Query Process?

Jul 10, 2007

I am developing a database and testing it with dummy data. With 50,000 records, the query process using SQL command is just OK. But if I double the total records, the query process takes longer time. The query is to make recapitulation using SUM of SQL command based on certain criteria. Any idea to make the query faster?

Thanks.

View 2 Replies View Related

Need Some Help - Converted Paradox To Access

Jul 13, 2005

I am pretty new to Access, so please bear with me :rolleyes:
We have a paradox v 3.1 database that I somehow converted into Access. At least the data was transfered and I can update it via a query.

What I am having a problem understanding is the difference between the main database file (in the object viewer appears as a db, with the the tables underneath. Am I correct to assume that all of the information is centralized into this db file?

I'm also having a problem changing the field lengths. I get a message "table "name" is a linked table with some properties that can't be modified."

I'm assuming this linkage came from paradox, because I didn't do a darn thing to it!! Any ideas on how to "unlink" would be greatly appreciated.

Thanks!

Linda

View 1 Replies View Related

97 To 2003 Converted Database Size.

Mar 5, 2008

I have searched this site but could find no similar questions. SO..

I am converting an Access 97 database to Access 2003.
I have compacted the 97 database before doing anything else.

The size of the 97 database is 91Mb

I have gone into Access 2003 and performed a database utilities>convert database>To Access 2002-2003 format and it has produced an 03 database with a size of 68Mb

I have also created a blank 03 database and imported all objects from the 97 database, changed all the text/memo fields to Unicode Compression = Yes and compacted the new 03 database and the size is 90Mb

What is the Auto conversion process doing that I aren't doing when importing objects that saves it an extra 22Mb? Plus is there anything I can do to free up that extra 22Mb again?

Thanks. Dan.

View 2 Replies View Related

Can Access Database Be Converted To V Basic

Nov 16, 2004

Is there a program that can convert an MS Access database to Visual Basic?

View 2 Replies View Related

Modules & VBA :: Users With Different Mapped Network Drives

May 13, 2015

I need to make sure that all users on the network can access a specific network drive folder.

Most users don't have a problem but some users have the network drive mapped differently so when running the feature required their system can't find the file at that specified location.

I have the location of the files hard wired into the VBA code.

E.g. Z:INVDATACOMPANIESCompanyAASSETS Pty LtdPrecedents 2015STAGE 3A - COLLS-DEMS

The location is outside of the project address.

I need to be able to make sure the address of the folder is the same for all users.

View 3 Replies View Related

Queries :: Converted Desktop Access Database To SQL Server

Dec 5, 2014

I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.

Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?

View 10 Replies View Related

Modules & VBA :: Review Workflows Converted From Data Macros

Nov 11, 2013

Is there a way to review / edit the actual SharePoint workflows in SharePoint created by Access Services after a web database has been published?

View 2 Replies View Related

Tables :: Import Txt Files -> Text Converted To Number

Jan 18, 2013

I'm having a number of tables in Access which I want to populate with data from excel/txt. In my import files I have some columns which contain alphanumeric data, like 0001 or XYZ0.

I've defined these columns as text in the definition of my table, however whenever I'm importing the text file, it converts those rows that can be read as a number to a number prior to storing it in my table. Hence values like 0001 becomes 1. Which is absolutely not what I need.

How I can prevent Access from doing this conversion? Why does it do the conversion anyway? I wouldn't expect any conversion since I defined the column as text...

When I import the same txt file into a new table (created during import, where I also define those columns as text) everything goes fine, 0001 stays 0001, but I don't want to remove my table and redefine it during the import everytime I need to import new data.

View 9 Replies View Related

Text Box Set Default Value To Date Being Converted To 1905-random Month / Day

May 29, 2015

Am just trying to set the default value (on the form, not programmatically) of a text box to a date but with every attempt it either fails or sets the date to 1905-randmon month & random day.I've tried a few different methods from various online sources.

=Now() works fine.

Any attempt to set to an actual date returns 1905-Random Month-Random Day?I am trying to set it to the 1st day of the current month.Text Box is formatted as Short Date - Regional settings are set to the ISO standard numeric date format YYYY-MM-DD.

View 2 Replies View Related

Forms :: Down Arrow Key Movement Between Records Slower Than Up Arrow On Datasheet?

Jun 13, 2013

I have a pop up form with a datasheet as a sub form. We use the up and down arrows to move between records. The problem is using the down arrow is 4 to 5 times slower than using the up arrow. This becomes a big problem when we hold down the arrow to move down 50 or more records. I believe it has something to do with the way the screen is repainted because in testing if I shrink the datasheet to show only 3 or 4 records the up and down movement is almost identical and matches the performance of the excel spreadsheet that this form was based on. Is there any fix for this?

View 7 Replies View Related

Thumb Drive

Jul 8, 2005

Does anyone know if I could put the runtime and an mdb on a thumb drive and run it from anywhere? Or does install stuff have to happen... :confused:

View 1 Replies View Related

Shared Drive

Oct 23, 2007

Hello,

I have an exrternal shared drive "E:"where I put my be files (which are constantly accessed by users with fe's from different terminals). Everytime
I reboot the computer that I am working on (where the external drive is), I have to set up the permissions of the shared drive "E:" all over again, otherwise other computers have no access to E. Is there a way that I could
fix this and not having to set permissions every time I reboot my computer?
For some reason, the permissions are lost.

View 4 Replies View Related

DB On Network Drive?

Jan 3, 2008

I have a db on a network drive and the performance is terrible, it runs fine on my local machine. How can I make it run better? The db is only 2 megs so I figured it would be ok, but since my forms have numerous queries within them, performance stinks.

View 13 Replies View Related

Drive List

Jun 21, 2005

Hi,

Does anyone know if Access has a built-in control that allows users to scan the directory structure of their PC? Similar to the DriveListBox and DirListBox controls in VB6? If so, how might I get access to it?

Thanks

Davemere

View 4 Replies View Related

Drive Verification OnOpen

Oct 19, 2005

Is there a way to verify the drive that an FE is opening from and then close if it is not where is should be?

I have a frontend that gets copied to each users C: drive by a .bat file. However, some just don't care about rules and proceedures and continue to open the frontend on the network drive. Since they map their drive to a specific letter drive for the BE that is where they are opening the FE from.

Thanks
Rich

View 2 Replies View Related

How To Execute Query From C Drive ?

Sep 27, 2005

Can I keep my queries in the C drive and execute it against tables that are in the LAN network drive ? Right now the queries are also in the netowrk drive. So each time when I refresh the data into C drive, I have to import the queries too.

Is it possible to keep the queries in the C drive and execute against data in the netowrk ? Please let me know.

Thanks in advance.

View 9 Replies View Related

Different Paths For Shared Drive

Feb 2, 2006

Hello all:

I have the following code to retrieve doucments:

strPath = "G:CorpCustomer Files"

Application.FollowHyperlink strPath & "" & textbox1 & "-" & textbox2 & ".doc"

This works fine from my computer because the shared drive on my computer is saved on the G drive.

I tried using the code from a coworker's computer, but got an error because her shared drive is : "X:CorpCustomer Files"

Basically anyone can access the Corp server through any drive depends on how it was mapped.

How do I get around this so that it works from any computer as long as the user has the Corp share drive?

Thanks much.

View 5 Replies View Related







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