Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Trouble importing from Excel to Access Hi All, I'm a little new to Access but am managing to use it pretty well. Anyway, I'm having a problem with importing data from checkboxes in an excel file. I managed to get everything else just not the checkboxes. Any ideas how to get this data into access -- rodmasters23Posted from - http://www.officehelp.in ... 1 27.11.2005 23:58:31 ShowUserRosterMultipleUsers I am using A2K and the 'ShowUserRosterMultipleUsers' procedure from MSKB to establish who is logged in and using the backend data file on network. It works fine in my office LAN using Windows XP Pro, but fails when run on a client network over TS using Windows 2003 Server (and A2K). It fails on the line: Set rs = cn.OpenSchema(adSchemaProviderSpecific, , "{947bb102-5d43-11d1-bdbf-00c04f... 2 25.11.2005 03:15:21 Access 2003 Security workgroups Hi there, I've created a secure db in access 2003. When I join the the workgroup security.mdw, the security I've put in place works all right. when open it asks for password, doesn't allow the user level to modify, etc. however when I try to open a different database the security window appears and the security rutine restarts, which would be fine if I'd be the only one to work with acces... 2 25.11.2005 01:33:27 How can i modify a form, while someone else is using database? Hello, Dzien dobry! (Good Morning) Having to update a db frequently can be frustrating when i have to wait for people to get out of it. So i have a secured db, can i do something so I can update whenever i want? i have heard of something, i think it can be done, any suggestions? TIA ~K -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-mu... 2 22.11.2005 23:25:54 ÎҵĵÚÒ»¸öÓʼþÐÅÏä ÎҵĵÚÒ»¸öÓʼþÐÅÏ䣬 ... 1 18.11.2005 12:36:32 Who is using the Access file? I have an Access Database on our network, and I want to be able to see who is currently using the Access File. The users login to the network, but do not login to the Access Database. We use Windows XP Professional and Access 2003. Is there a possibility to see which users (user-id's) are using the Access File? Thanks in advance, JeroenM.... 3 18.11.2005 10:20:07 Users sharing a Computer & Access - What's the answer? I have a client who is a manufacturer and an Access application is used down on the shop floor where they have PC's in each production area. Currently when a transaction is entered the worker just selects their name from a drop down list but the problem with this is that they can select any name not just their own. There is currently a generic login for each PC e.g. Line1, line2. Acce... 5 17.11.2005 15:16:30 How to get NT Login ID from User's Credentials? Hello All: First off: Thanks for everyone's help in these newsgroups. Your help is truly appreciated. Here's my latest project roadblock: Having read ALOT of these articles, I plan on using a Back-End MDB for the data, and 3 Front-End MDBs for the users as well as another MDB for someone to run reports. This is all going to happen in Access 2003/Windows XP on a corporate network... 3 17.11.2005 07:56:06 Auto FE Updater - .mdw files Hi all, Seem to be having the same problem, has a work around been found ? Dom N.B. I already posted this problem on a other group but users told me I had more chance to run across Tony Toews in this group. Sorry for the duplicate. I hope to have support this time since every topic I found on the same subject has no answer. Thank --------------------------------------------------... 1 15.11.2005 23:35:48 Access XP Deployment I have an access xp app that I want to deploy to several countries but when I try to package it using the packaging wizard and include access runtime I need to create the new set of access components for the language selected. Is there a source for these components other than purchasing microsoft office for each of the languages required? Or alternately is there another way to package a... 1 14.11.2005 19:19:03 Wireless LAN I have a customer who recently added a wireless laptop user to his group of users that are using an Access 2000 database application I developed. All has been working great until the wireless user has come on-board. However, now the database corrupts. I'm thinking that accessing the database over two different network environments (LAN and WLAN) is causing the problem. Also, perhaps ... 2 14.11.2005 19:00:40 dialog box to link table I am creating an access database named "stale dated checks" and when the user opens the database I would like a dialog box to come up and ask which Excel spreadsheet the user would like to use as linked table. I would like the linked table to be called "tblOriginal". I am new to Access and VBA so any help you can give would be much appreciated! ... 2 12.11.2005 19:08:42 Sharing DB across the State I have developed a db that is currently split into a fe and be. My co-worker and I share the db in our office over a LAN (fe installed on our desktops, be on server). However, we would like to share the db with other offices throughout the state (we work for the state gov.) I would like someone to explain where the backend would reside and on what, and how users would access it if the db ... 2 11.11.2005 01:40:09 ldb msldbusr.dll Is it ok to use msldbusr.dll with 2003. What exactly is "suspect state"? What if the user name is blank when using ldbviewer.exe? Where can I find a copy of ldbview.hlp?... 1 10.11.2005 21:16:02 Access application slow to start after first 2 or 3 users have started our application Hi, some of my customers have the problem where the 3rd or 4th users take much, much, much longer to start our application. There is a front-end mde file and a back-end data file (both in Access '97). The front-end mde file is started under Access runtime. This seems to happen when running the back-end data file on a network server under Windows 2000. This has been a real brain teaser. ... 2 08.11.2005 23:50:51 cannot rename report on multiuser DB I have a multiuser database that runs some code to print a report to a pdf file using Acrobat Distiller. Distiller is configured to NOT prompt for file name & always overwrite any existing file. This DB has just been converted from 97 to 2003. This process worked great in 97, I would rename the report to a field from a recordset, then open the report using the same field as the filter & ... 2 04.11.2005 23:05:53 Delete lock file when no body is in use will cause trouble later? We have an Access database Sch.mdb in the shared driver S. I want to make a change to the form and the code. However one user is always login to that database and I am unable to make such a change. The utility LdbView found that a computer named 1X23Y45 is login to the database Sch.mdb all day long for three days. The user might forget to close the database and left for a vacation, or there ... 4 04.11.2005 18:24:21 Records sometimes go missing...can you help? Hi everyone I have a database that around 4 folk may be using simultaneously. A few times now, one of the staff has reported that when she comes out of the app and then goes back in: a) a further instance of Access is still remaining in Task Manager b) some of the records keyed immediately prior to exiting have disappeared I use a small bit of code to automatically link the front end that... 1 04.11.2005 17:26:05 no permissions to macro object MS Access 2K Split database - which was working in an WinNT, Office 2K3 Access2K3 environment This is a remote site so i am unable to look at the dbs All was working until today when the site attempted to give the user access on a different desktop Now the FE still opens using the shortcut and vba runs behind a cmd button. i.e the vba relinks the FE/BE , does a lookup on C drive, runs sev... 1 04.11.2005 01:29:16 Allowing only one session of an application Is there a way in microsoft Access VBA, that you can restrict a user of starting my application only once. Basically when he tries to run it again while there is already another instance of the app running a warning pops up saying "Sorry only one instance of the application is allowed." Thanks... 2 02.11.2005 14:17:23 SLOW Windows 2000 machine This is a home networked computer - all other machines on this network are fine. The slowness is in booting up through the login procedure (8 minutes after the wallpaper color changes until I can begin to open a window). Then it may take from 20 seconds to 1 minute for a new window to open. The menus from the menubar also take 17 seconds to appear. This problem developed all of a sudden ... 2 02.11.2005 14:13:41 Corrupt vba when installing .mde on Front End Hi All Using Access 2003 I have a front end/back end application which I install on my client's machine. I install BE (.mdb) in a central location and FE (.mde's) on each person's machine. It seems that when I try to install the .mde on one of the machines, each time I run the application (after I have relinked the tables, etc), I get a "corrupt VBA" error. To avoid this, I have to i... 2 02.11.2005 08:25:59 Access Client/Server issue Hello, I have designed many Access Client Server Applications before where I have the 1 MDB file on the Hard Drive & the data MDB file on the server & have the Tables Linked. For this one client when I do the same when 1 user logs in they are fine. But when anyone else does they freeze & they have to End Task out of Access. So basically it is only allowing 1 user to log in. So that i... 2 01.11.2005 10:41:15 Multiuser database with common front end I have a database that requires two separate groups of users -- one will have read-only access, the others will be able to change data. Furthermore, the forms in the front end will display differently depending upon the user group of the person signing in. The shortcut to the app contains the workgroup and path, as well as the userID of the person logging into the app. However, they... 3 01.11.2005 04:34:44 multiuser problem - error message Hi I keep getting the follwing error 'You do not have exclusive acess to the database at this time. Your design changes will not be saved.' I want multi user access to the forms. When this happens no one is in design mode. The settings are set to shared - no locks. I just cant understand it, any ideas?? baz ... 2 29.10.2005 04:40:39 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13