Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Protection 1st I want to thankyou for all the help. I have a computer that 3 different people use. When I log on I can use my data base to update and export data to excel. when the other 2 people log on they can updat the data base but they can't export the data to excel. Is there any way to take all the protection off this data base so that anyone can import or export data? -- Arthur Bourgeois Jr ... 2 04.05.2006 09:59:48 Getting message "Could not update, currently locked" I have a database that uses several tables. Two tables, based on a parent/child relationship, is set up in one form. This has been in production for about one year with multiple users. Today the user's received a message "Could not update, currently locked". This message is produced as a user tries to add a new child record. Editting of an existing child records is no problem. This... 1 03.05.2006 17:36:02 mde queries I have 2 questions concerned to deployment 1. Can I supress the "Security Warning" dialog box when I open an MDE file.I want my first form (Login form) to be opened directly when ever I open the exe file.(I selected Display Form/Page as login form (frmLogin) in Tools - Start up option) 2.Can I supress the default menu while making an MDE file. I don't want any menu bar,neither do I w... 2 02.05.2006 19:38:26 Unrecognized database format ? No solution, data lost!! Hi, I have a multi-user database file, which was being used by 30+ users at anytime for about 6 months, and it has now got corrupted possibly..I have tried all possible options, to compact, repair, tried to open it a thousand times, cant even import. Could someone please help, how i can retrieve the data? Cheers Sunny ... 7 28.04.2006 14:47:27 Filtering in a form I have a form which displays user comments. On the Load event, I apply a filter in VBA using the following code: '''''''''''''''''''''''' Me.Filter = "StudentID = " & Me.StudentID & " AND PracticalIDNumber = " & Me.PracticalIDNumber & " AND PractCatID = " & Me.PractCATID & " AND InstGrader = " & Me.InstGrader & " AND UODeduction > 0 AND UOComments is null" Me.FilterOn = True ''''''... 3 28.04.2006 14:04:02 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 27.04.2006 14:31:50 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 27.04.2006 11:54:26 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 26.04.2006 22:52:47 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 26.04.2006 19:52:48 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 21.04.2006 13:36:06 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 19.04.2006 22:53:43 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 19.04.2006 14:33:49 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 19.04.2006 03:10:58 Determine path of my Backend How can I determine path to my Backend Access2003 database? Something like "CurrentProject.Path" usable for frontend?... 3 18.04.2006 15:52:02 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 17.04.2006 18:55:33 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 16.04.2006 18:25:03 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:37 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 15.04.2006 04:04:48 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 12.04.2006 10:09:47 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 11.04.2006 16:04:42 Îʺò ÄãºÃ£¬ÄãºÃ£¬ÄãºÃ ... 1 11.04.2006 01:51:35 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 08.04.2006 15:25:10 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 05.04.2006 04:43:34 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 01.04.2006 04:40:07 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 01.04.2006 04:35:55 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13