Threads Replies Last Post 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19   Split DB BE question If you have a DB split using a FE and a BE can you put a password on the BE db? Or will that cause the FE /BE not to work? Basically I don't want a user to be able to open the BE db and see the tables, values ect. The FE is already an mde application. Thanks in advance. .. ... 8 4/27/2006 2:31:50 PM SQL Server or Terminal Server? Hi, I've recently deployed an Access 2000 database over a 100 Mbps WAN. When you try to connect to the back-end from a computer in the same office (same building) everything works fine. When you try to open the back-end from other building the connection is painfully slow, making it unfeasable. I've heard plenty times about MSDE/SQL Server or installing Cytrix Metaframe/Windows Terminal Se... 2 4/27/2006 11:54:26 AM Linked Table Manager Problems with Access 2003 Network Database - newbie help,, thanks Hi All, I'm doing IT for a small office using Microsoft Access and a distributied database. A winXP fileserver is storing the BE of the database on a mirror raid system and 4 client computers access the data via a small fixed IP microsoft network. Intermittantlly the users are missing data from their view of the database and are told by the 'developer' of the database that they hav... 11 4/26/2006 10:52:47 PM SQL Server or Terminal Server? Hi, I've recently deployed an Access 2000 database over a 100 Mbps WAN. When you try to connect to the back-end from a computer in the same office (same building) everything works fine. When you try to open the back-end from other building the connection is painfully slow, making it unfeasable. I've heard plenty times about MSDE/SQL Server or installing Cytrix Metaframe/Windows Terminal Se... 3 4/26/2006 7:52:48 PM newbie help - refresh forms Hello. I'm sure that this is a common issue, but I was unable to find a good solution. I have a multiuser (~3 users at most) database which has a Welcome form. This form has comboboxes to Add and Edit records. If one user Adds a record, and another has already selected the Edit Combobox, the 2nd users Edit Combobox will not refresh on click to show the new record. I figured I could Requery On... 6 4/21/2006 1:36:06 PM Switchboard problem in a split database How do you modify the switchboard in a split database? I am using Access 97 and have the front end on everyones c drive and the back end on the network. Thanks for all your help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200604/1... 2 4/19/2006 10:53:43 PM Changing path between FE and Password protected BE Hello, I have a database that is split into FE and BE. The BE is protected with Password which the FE is providing when connected, using VB code. the users' path to the back end may differ from the path I used when setting up the front-end/back-end link. How can I let the user to change the path, without giving him the password to the BE? thanks, AviA -- Message posted via Acce... 4 4/19/2006 2:33:49 PM Application won't open I split my database and on my front end, which is located on everyones c drive, I have a form with an application that when you click the button it opens an excel spreadsheet. It works on all of the computers in the network except one. I cannot find the problem - using Access 97. Any Ideas? Part of the Private Sub Dim stAppNmae As String stAppName= "Excel.exe \\xxxxxxxxxxxx\xx... 2 4/19/2006 3:10:58 AM Determine path of my Backend How can I determine path to my Backend Access2003 database? Something like "CurrentProject.Path" usable for frontend?... 3 4/18/2006 3:52:02 PM Read-only users I don't have very detailed needs for user security, but occasionally want a particular user to be able to look at the database only, with no mod capability. Made a security group with read-only priveleges . . .problem is, one lookup drop-down does a Record Save before loading and displaying the selected record. The read-only users get an error on that function, and can't continue. Which... 4 4/17/2006 6:55:33 PM good technical ref for mutliuser? What do people consider to be good manuals on setting up and maintaining Access for many users? I've seen some good online references, but if one exists, I'd like a paper reference. Thanks. Kevin -- ... 7 4/16/2006 6:25:03 PM for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 4/16/2006 1:28:37 PM Characteristics of ADE I have a general question regarding Access ADE files. I've recently adopted some Access applications and have questions regarding multi-user behavior. I've noticed on the MDE application that multiple users can be in the same file located on the file-server at the same time and no read-only errors occur(on opening). I've recently created an Access ADP and moved the same access table... 4 4/15/2006 4:04:48 AM how can i get my front ends to talk to each other? I need front ends to be able to pass information between each other. The front ends can obviously save information into a common BE but each FE needs to know that there's information waiting for it. So I need a way to trigger an event on an application on another machine. I've come up with 2 options so far: i) a hidden timer form checks a table for messages adressed to itself. I don... 2 4/12/2006 10:09:47 AM we have an access 2002 db shared over a wan not split Some users have been upgraded to windows xp/ avccess 2003. The db started crahing hard; 5 times last week. We had to step through all the error messages for each table and copy and paste the data into the backup.We banned 2003 users until everyone is upgaded. It seems to have settled down knock on wood. Would a split db help with the different versions not crashing? Thanks. Lewie ... 2 4/11/2006 4:04:42 PM Îʺò ÄãºÃ£¬ÄãºÃ£¬ÄãºÃ ... 1 4/11/2006 1:51:35 AM delete rights to folder means people can delete mdb too?? I'm a big believer in Access and have been using it mostly with the powerful built-in GUI tools and wizards for years, recently getting more into VBA. I've built an Access 2000 front end back end lease tracking application that has only a handful of users. Our IT dept created a folder specifically for the back end database file (front end on each person's PC), and at first they did not give ... 7 4/8/2006 3:25:10 PM Access Upgrade Looking for a solution to move FROM an Access DB to something bigger and which can be multi-user. Currently uses a local Access DB (not networked) that is copied to the network so the next user can Access. Has anyone upgraded from Access to something more multi-user friendly? ... 3 4/5/2006 4:43:34 AM BE database Name Using Access 2002 in a multiuser enviroment using FE/BE config From the FE would like to be able to get the BE database name, for entering into a log, what would be the best way to achieve this? TIA Tom ... 4 4/1/2006 4:40:07 AM Split Database using Access Runtime I have split my database from the application to accomodate a multiuser environment. At the site, they will be running the app using the Access Runtime from the Access Extensions. I installed the database.mdb on the server. When I attempted to install the app.mdb, I realized I had no means to link the app to the database as that functionality is not available in the runtime. I'm thinking... 3 4/1/2006 4:35:55 AM Multiuser db with users in different locations - advice? Hi, I have developed an Access application to administer competitons for a photography club. Now, because of the workload entering all the data, I am looking to make it multi-user. That, in itself, is not a problem, and I have done such apps in the past. However, thie issue here is that the whole thing isn't in a single office, running over a LAN, or at separate offices with a leased l... 3 3/31/2006 10:54:00 AM Another user logged in? Hello All I have a split FE/BE a97 mdb, with 4 PCs on a peer-to-peer W2k network each with their own FE, and a BE on a fileserver running w2kserver. Whenever I try to do a compact/repair on the FE on my PC I get "The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time". But this is not true - there is defini... 2 3/30/2006 2:55:00 AM shared over network - mapped drive vs. sharename Which is faster, if any, when accessing a backend from a local fronted over a network - mapping the share to a driveletter og just using the sharename? Does it matter? Jesper ... 6 3/30/2006 2:52:40 AM Multiser Access-Data Entry I'm using Access 2003. I have a database that I want to allow all users to view, and print reports, some users to be allowed to enter all of the data, and finally some of the users to be limited to entering data in specific fields. Is this possible? The form is tabbed. Thanks, -- Bob... 2 3/28/2006 1:19:56 PM Server Questions - Hardware advice I will be splitting my database in the next month or so after more input and testing from management. I will have access to a SQL server.... So here are my questions. 1. If the database is going on a SQL server, are there additional steps I need to take or does it just work like a file server? 2. Should I really be asking management for a dedicated file server to hold the access databas... 4 3/27/2006 3:21:54 AM 19 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19