Showing Database Network Path???

Jul 28, 2006

I've got a database with several users and we've had two people recently who rather than creating a shortcut to the db on their desktop copied it and then proceeded to enter their data there instead of into the one on the network.

I would like to be able to add a field on the first page they see when they open it with the complete file name / path information. I know how to do it in Word by adding a field to a header or footer. However, I can't seem to figure out how to do it in Access.

My hope is that if I can display the path and then include a dialog box when the database is opened warning users to verify they have the correct version before they enter any information.

Alternatively, is there a script I could write that would have the db check that it's the V drive copy not a C drive copy?

Any and all help will be greatly appreciated. Thank you.

Charis Wilson
Denver, CO

View Replies


ADVERTISEMENT

Linking A Database To Access On Network Path Level

Apr 2, 2006

Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View 1 Replies View Related

Linking A Database To Access On Network Path Level

Apr 2, 2006

Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View 1 Replies View Related

Modules & VBA :: Simulate Link To Network Path

Sep 10, 2013

I have a front end and a back end access files.My user save the back end on a shared network folder like:a.b.comfolderName$..I wish to simulate this path in my local pc in order to set the linked table links.My problem is that I can not modify my pc name to be "a.b.com".How can I simulate this in my windows 7 pc ..so I can set the linked table values to "a.b.comfolderName$" ?

View 8 Replies View Related

Access 2007 DB Shared Through Network Folder Showing Record Lock

Feb 6, 2013

I have an Access DB shared through a network folder. It is currently frozen and showing a record lock, however, none of the users have it open. Is there a way to kill the lock so I can restore it?

View 5 Replies View Related

Using A Database On A Network

Feb 14, 2006

I have two pc,s hooked up as a workgroup network( no server) I have a database on one of the pc,s and when I open the database in the other pc it says that it is "read only". So I cant enter new records.

How can I resolve this problem??????

Thankyou in advance

View 1 Replies View Related

Network Database

Mar 11, 2006

is there any way to use a same database in a network that if i entered some entery and some body else entered another entery it will show all data entered by every people in everyone's computer ?!

thanks

View 1 Replies View Related

Distributing A Database Across A Network

Aug 2, 2005

I have a database built in Office 2000.

The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.

The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.

They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's

I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.

In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?

Many thanks.

View 4 Replies View Related

Slow Network Database

Feb 7, 2006

This problem is driving me nuts!!
I`ve just spent a fair few months creating a database to be used by our sales team, I`ve about finished it and came to trial it with the sales manager. When he is using the database at the same time as me it becomes slow.
The design has a front end with all the queries, forms etc and a back end on a server containing the tables.
The database was created using Access 2000 and was designed to replace a similair db created on 97 which has a decent speed on the network.
The other strange thing is that one particular macro that I`ve been using for the speed tests runs quite slow (about 3 secs) when 2 pcs have the db open but once the macro has run if it is run again it takes typically less than a second to run.
What would cause a db to run a macro at different speeds after they`ve been run once? I`ve tried everything I can find on the net to try and improve the speed to no avail.
Help please!!

View 2 Replies View Related

Speed Of Network Database

Jun 5, 2007

Our office runs on a pretty large Access database (v2003). We are on a large hospital network and have about 15 users for our database. It tends to run VERY, VERY slow. Are there other options?

View 4 Replies View Related

Database On Local Network,need Help

Jan 24, 2005

i have done a database for a library that enables the user to enter the information about the books and search for it, the administrator have the right to enter the info about the books and edit and search the others have more limited rights depending on which group they belong, i used for the connection (currentProject) because i did all the forms and tables in one DB
a friend from this forum told me and i think he s right, that if i want to put it on the network i have to separate the forms and the tables ie save the tables and the queries on another database that i put on the network
i have a problem
1- im not sure how to connect to another database can i do it like this
Dim conDB as ADODB.connection
set conDB=new ADODB.connection
conDB=openDatabase("the path") or not
2-i have done the result form with a record source (search-query) and then inserted the fields into the form in the design view
can i do that with a query if it was from another database or i need to write it all in code (taking into consideration that i havent found how to insert datacontrols and do the binding, because im using french access, that s why i assigned automatically a record source for the form)
thanks in advance

View 6 Replies View Related

Accessing Database On Network

Oct 7, 2014

My boss cant access the database i made on his laptop at home.

The access database (.mdb) is on the company network.

View 3 Replies View Related

Query For Current Database Path

Apr 27, 2007

I used to know how to get the path for the current database by running a query. I forgot how to do it. I am using Access 2003. I have tried querying the msystem tables without success. I have searched forums and the web without success. Anyone? Thanks!:)

View 1 Replies View Related

Modules & VBA :: Split Database - UNC Path

Jun 10, 2015

I am using Access 2010 in a split database. The intent is to place the back end and associated linked files on a server and the front end on work stations for each user. The typical user will just be searching for information in the database not altering it. My current code re-links the tables once the path is known i.e. I have to hard code it into the global constant. Is there a way in VBA or utilizing VBA to read/write to an ini file (for example) that the UNC path would automatically be updated to a global constant in my current code that can be updated automatically based on where the back end is installed.

Global Const BE_DATABASE = "192.168.2.3FMCENFMCTABLES.accdb"
Global Const BE_PASSWORD = "***********"
Global Const BE_DATABASEPATH = "192.168.2.3FMC" 'used to open files
Public Sub CreateDatabaseLinks()
On Error Resume Next 'new
Dim ws As DAO.Workspace
Dim db As DAO.Database
Dim td As DAO.TableDef

[code]...

View 5 Replies View Related

Creating A Social Network Database

Aug 7, 2006

Hi everyone, I am hoping someone will be able to help me with a problem I have. I am undertaking a social network analysis and in order to do this I need to be able to create a matrix with the following format:

Group Person
J Smith G Fowles M Jones
X 1 0 1
Y 0 1 0
Z 1 1 0

I also need to be able to store and retrieve personal and group level details. Note that people can be in more than one group and groups can have more than one person. My problem is that the data has been gathered by another institution and is only available in the following (Excel) format.

Group Person Role Group Characteristic .....
X J Smith Strategist Level One
X M Jones Supporter Level One
Y G Fowles Financer Level Three
Z J Smith Strategist Level Ten
Z G Fowles .... Level Ten

Any idea how I can go about doing this? I know how I could do it if I manually entered the data, but because there are literally thousands of individuals (and a whole heap of groups too) I am hoping hoping hoping that I can do it using Excel and Access. Any advice would be incredibly appreciated.

Thanks everyone!

View 1 Replies View Related

Database On Network Drive Won't Open

Oct 24, 2006

I was using the database when there was a network error and I had to close it. When I tried to reopen it I got the error message: Record(s) cannot be read; no read permission on 'MSysAccessObjects'. I logged off the PC and logged back on various others, but keep getting the same message. Can anyone tell me if this is terminal or is there a way around it. I do have a backup, but it's a few days old and a lot of work will need re-entering' so any help would be appreciated!!

View 1 Replies View Related

Cannot Open Access Database On Network

Oct 24, 2007

We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message.

"Microsoft Access cannot open this File

This file is located outside your intranet or
on an untrusted site. Microsoft Access will not
open the file due to potential security problems.

To open the file copy it to your machine or an
accessible network location."


Do not understand why all the coputers cannot open the same access database file. Please Help Regards Keith

View 12 Replies View Related

Access Database Secured Across Network

Nov 1, 2007

Hi,

I have an Access database that needs to be secured and I have 2 problems:

1) How do I get it across a network so all users must enter their password?

2) How do I stop this from asking for a password for every database (i.e. I only want one database to require the password)?

Please keep answers simple as I am quite new to this!!

View 7 Replies View Related

General :: Sharing A Database Over Network

Jul 30, 2012

i have made a database in access 2010 . and i have put that in a shared folder . split that into fe and be. and on my network i am using access 2010 runtime on other computer to access it . on that computer in registry settings i have trusted locations as //server/database i.e. in database folder i have the fe and be.i can open the fe but with potential security warning i.e. of trusted locations i think . and when i click open on it it doesnt open my forms those are linked with tables from navigation form and displays the error that is something concerned with location g:database which is on my server computer.

View 2 Replies View Related

Split Database: Back End File Path (via Vba)

Mar 2, 2007

Hey guys,

How can I change the tables' splitted file path via vba?

Ex.: c: ables.mdb -> c:ew path ables.mdb

thank you.

View 3 Replies View Related

MS Word File Path > Access Database, Possible?

Jun 14, 2006

Hi All,

I have been trying to figure this out for ages but I cant seem to get the code right or find any info on it.

In my database i have a mail merge on a button click which creates a new merged word document. I then need a way of when the user saves the document in word, bringing back the file path and putting it in a table called tblHistory with the correct customer ID in there too.

Any help appreciated

Thanks

Alex

View 1 Replies View Related

General :: Split Database With Not Valid Path

Nov 6, 2013

I am attempting to split an Access 2007 database. My company has two locations. From my location we are remote connecting into the server. While down there they are connecting directly. When I split the database, people in my location can use it fine. When people down there use it, they get a not valid path error.

This is because the network drives are mapped differently. I have been reading that the solution is to use the UNC for the back end file path.

View 1 Replies View Related

Moving Database - How To Change Path To New Location

Jan 10, 2013

I am new to Microsoft access. I have a database moved from another computer. it is split into the backend and the front end..

However, when i click on the forms in the front end, I get an error message. It is trying to use a path from the old computer, to the database, but its on a different computer.

So, this brings me to my question, how do i change the path, to the new location

View 1 Replies View Related

Deploy Access Database On A Domain Network

Jun 14, 2005

Might be a stupid question as I know a lot of access but it's the first time I'm doing this:
What's the easiest way to deploy an access database (mdb) on a domain network to clients?

View 3 Replies View Related

Database Over Network With User Permissions And Passwords

Dec 19, 2006

Hi guys,

I have very nearly completed designing and making a database for stock control for my company, and am now a little concerned on how it is going to be implemented. It is going to be done over a network, with only a handful of users. The idea is to have every user log in but with each person having different permissions. i.e onl;y being able to access maybe one or two forms, but also having an administrator that can view every form. Now, i am aware of the security settings in the tools menu, would this be the appropriate way, or would i have to creat an empl;yee table and set permissions thropugh vb? This is the first database i have constructed and need a little help!

The second problem is that the database will be over a network. Would i have to put the backend in one place and then have the front end installed on all the pc s and just access the backend when i its needed? Forgive me if this sounds a bit stupid but as i have said this is new to me..

Your thoughts would be greatly appreciated.

View 2 Replies View Related

Admin Issues When Copying Database To New Network

May 24, 2007

When attempting to open an Access DB that has been transferred from one network to another (via CD and aeroplane!) we are finding that the copy cannot be edited - the access is effectively read only... I believe this has something to do with Workgroup admin rights but this area is all a bit confusing for me. What do I need to do to open the copy up for editing - allowing the recipients to administrate their copy of the DB?

We're using Access 2002.

View 4 Replies View Related







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