Deploy Access Database On A Domain Network
Jun 14, 2005Might 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?
ADVERTISEMENT
General :: Deploy Access DB To About 8 PCs In A Domain
Dec 10, 2013I need to deploy an Access db to about 8 PC's in a domain.I use the "Linked Table Manager" to set the connection details to MS Sql Server using an ODBC data source.My problem is when I have it running on 1 PC in the domain I thought I could just copy it and put it onto other PC's and it would just connect to the database with no issues, but I get an ODBC error and I need to re-create the ODBC source again on that PC.
How can I deploy the Access DB with out having to do the ODBC settings again.
General :: Deploy And Split Database
Apr 8, 2015How to deploy a database project to others who are not in my organization and then have it split itself once it installs onto their network.
View 1 Replies View RelatedCannot Open Access Database On Network
Oct 24, 2007We 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
Access Database Secured Across Network
Nov 1, 2007Hi,
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!!
Linking A Database To Access On Network Path Level
Apr 2, 2006Hi 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.
Linking A Database To Access On Network Path Level
Apr 2, 2006Hi 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.
Modules & VBA :: Record Locking Multi-users Over Network Split Database / Access 2007
Aug 5, 2015I have designed a database which I intend to split for multi-users to access from one front end icon on a shared folder at work. I have designed a form bound to cmr record table and on it a subform to another table where cmrs activities will be saved. The form has buttons to and blank controls.
User can create a new activity entry by typing into the blank controls and pressing the save button which saves to the activity table. the edit button extracts a selected records details (selected on the subform) from the activity table and populates the blank field for a user to edit and then hit save to save changes. The delete button deletes a selected record from the activity table. I intend to have multi-users either accessing, viewing and a possibly editing the same customer at the same time. The simultaneous viewing is essential but the simultaneous editing, though not desired is inevitably going to occur.
What I would like to know is:
1. Can you lock an individual record in a table or does the whole table have to be locked. E.g If Colleague 1 is editing Cmr A's record in Table1 can he lock it so Colleague 2 can view and edit Cmr B's record in Table1
2.Can Colleague 1 access/read Cmr A's record in Table1 to retrieve details toe the form controls if Colleague 2 is viewing or editing Cmr A's record in Table1
3. If record lock is possible, how can I initiate it in my example code below.Edit activity record Code
Code:
Private Sub Edit_A_Click()
'Get Data to text box control
With Me.R_P_Data_P_Subfrm.Form
Me.txtrID = !rID
Me.txtrID.Tag = !rID
Me.txtrefNo = !refNo
Me.cmbrpc = !rPC
[code]....
Access Security And Domain Login's
Sep 21, 2005All,
I tried my damnedest to find something about this elsewhere in the forums but drew a blank.. so i figured I'd see what asking the question direct yeilds.
I would like to initiate workgroup level security to my database. but have no password required because i want to tie it to the username that is logged into the computer when the user logs into the domain initially? any thoughts?
Login Problem With Access 2003 On Domain
Feb 7, 2007:confused: Hi all,
I have a user that cannot open .mde files on a share
that he DOES have access permissions to. He gets this Access error on his desktop when he tries to hit the share:
Not a Valid Account name or Password
I can log onto the resource with his username, and password from my
desktop with no problem.
What am I forgetting ?
Thanks,
Scott
Using A Database On A Network
Feb 14, 2006I 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
Network Database
Mar 11, 2006is 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
How To Deploy?
Dec 30, 2006Well, I've got my DB ready to go. Now what?I need to host it on our Win2003 server. How do clients use it?I think im getting more confused as I try to figure this out. We are a small company and I just want to be able to have everyone here use the database at the same time without too much fuss. Do I just have to have access on each machine and let them open it from the server, or is there more to it than that? I just don't want them to be able to get into the DB itself and modify things, just add entries and pull up reports.Thanks!
View 1 Replies View RelatedDistributing A Database Across A Network
Aug 2, 2005I 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.
Slow Network Database
Feb 7, 2006This 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!!
Speed Of Network Database
Jun 5, 2007Our 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 RelatedDatabase On Local Network,need Help
Jan 24, 2005i 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
Accessing Database On Network
Oct 7, 2014My boss cant access the database i made on his laptop at home.
The access database (.mdb) is on the company network.
How To Deploy My Design Changes
Mar 29, 2006hi,
i've never done any MS access application before, but i am tasked to enhanced an existing MS Access application.
I have a local copy of the production db and i'm just concern how i can deploy or refresh the production database with my updates.
Also, the clients is using a linked copy of the database.
Thanks for any help :)
Showing Database Network Path???
Jul 28, 2006I'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
Creating A Social Network Database
Aug 7, 2006Hi 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!
Database On Network Drive Won't Open
Oct 24, 2006I 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 RelatedGeneral :: Sharing A Database Over Network
Jul 30, 2012i 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 RelatedDatabase Over Network With User Permissions And Passwords
Dec 19, 2006Hi 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.
Admin Issues When Copying Database To New Network
May 24, 2007When 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.
Multiple DataBase Working On Local Network
Jan 14, 2008Hi! I work at a company where a same DB is being opened by more than one user, is there any way to allow many users be working on a same DB?
Actually I cannot even open it if its already opened. It appears another file with a "lock", which seems to be protecting the DB. :confused: