Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Question on Slow Speed on Access to run SQL
- I've designed an Access project, by Access + SQL Server 2000. In the project, I've written several stored procedures. But one problem is: when I try to run the stored procedure in Query Analyzer, the speed is quite fast; while when trying to run the SQL query in Access, the...
- Tags: access project, hunter_jn_cn@..., Microsoft Access, programming, SQL
- Discussion threads 2007-01-03
- Question on domain user logon
- We have a LAN with domain controller. I hope to let users log on to the domain, not "this computer" when they start up computer. Is it possible to hide "this computer" when they start up system, only domain, for example, change settings in registry?
- Tags: domain, computer
- Q&A 2006-09-05
- Question on an Excel file
- I have an Excel file from others. When trying to open it in Excel 2003, it prompts that "This workbook contains links to other data sources. If you update the links, Excel attempts to retrieve the latest data; if you don’t update, Excel uses the previous information". But no matter...
- Tags: Excel 2003, hunter_jn_cn@..., Microsoft Excel, software
- Q&A 2006-09-05
- Question on Access Sub-form total
- I’ve just designed a database file, with Sub-form inside; a textbox in main-form displaying sum of quantity of the sub-form. But after copy to another computer, the sub-form total can’t be displayed. What might be the reason? (The Access in my computer is English version; while on another computer is...
- Tags: Databases, computer, Chinese Version
- Q&A 2006-06-27
- Question on convert data type in Excel
- Now we have an Excel file, I need to convert one column of data into Text format. Originally, the column is in custom format "000000-00", looks like 060414-26; how can I convert it directly into Text with exactly same result. I’ve tried to change the format of cells directly into...
- Tags: Text, Microsoft Excel, hunter_jn_cn@..., software, cell
- Q&A 2006-06-19
- License for number of users of OS and DB
- We are proposing a project using Windows server 2003 and Oracle 9i; the customer suggests Windows server 2003 standard edition with 5 users license; Oracle 9i standard edition with 10 users license.What is the real limit of number of users in OS and DB? Will the 5 users conflict with...
- Tags: hunter_jn_cn@..., operating system, Oracle Corp., windows
- Q&A 2005-12-27
- Question on ASP + IIS in Windows XP
- We have a local application system based on ASP + SQL Server 2000; the computer as server is using Windows XP, Internet Information Service.Previously the application server was another computer using Windows Server 2000.Now a problem: on the new server of Windows XP, users can not input new message.But on...
- Tags: computer, hunter_jn_cn@..., Microsoft ASP, Microsoft IIS Server, Microsoft Windows, Microsoft Windows XP, server, windows
- Q&A 2005-12-07
- Question on Drop-down List in Excel
- In Excel 2000, User can create a drop-down list from a range of cells, for example, "Europe", "Asia", for Column "Continent", so that operator can only select from the predefined list. Now we want to create two columns, for example, one column "Continent", another column "Country", hope to realize the...
- Tags: Continent, hunter_jn_cn@..., Microsoft Excel, software
- Q&A 2005-11-23
- SQL Server connection problem
- I’ve installed SQL Server 2000 on my computer, also built an Access project to connect it. In SQL Server Enterprise Manager, I set up a new user, for example, "user1"; but from the Access project file (.adp), cannot use user1 to connect with database.I just set up in Enterprise Manager...
- Tags: database, Database Access, hardware, hunter_jn_cn@..., Microsoft SQL Server, server
- Q&A 2005-08-31
- Prompt a message before save records in Access
- In Access 2000 or 2003, normally records are automatically saved after editing. I’ve just developed a database application using MS Access + SQL Server 2000. Colleagues say that they hope to have prompt message before saving records, so as to avoid mistaken modifications.How can I realize this in MS Access?Do...
- Tags: Microsoft Office, Databases, Microsoft Access
- Q&A 2005-08-16
- Question on Images in Access + SQL
- I’m using Access + SQL Server to develop a database application, and now need to show pictures in the database. For example, customer can upload a scanned drawing in jpg or bmp format, and the all other users can view the drawing and make their comments.How can I realize this?...
- Tags: byte, database, hunter_jn_cn@..., Microsoft Access, Microsoft SQL Server, Null, software, SQL
- Q&A 2005-08-08
- set AllowBypassKey property to False
- In Access 2000 or 2003, user can hold down the Bypass key the SHIFT key while open the database. How to disable the bypass key? Can someone tell me the method step by step? Many thanks.http://www.mvps.org/access/general/gen0040.htm will show you hw to do this.This question was closed by the author
- Tags: Databases
- Q&A 2005-07-12
- firewall in windows server 2003
- Now I really feel confused on firewall in windows server 2003. I have installed windows server 2003 on our company’s server. Now within our Intranet, we can send and receive mails through our mail server (POP3). This mail server is also on the same server 2003. Also I can visit...
- Tags: firewall, hunter_jn_cn@..., it management, router, server, window
- Q&A 2005-06-07
- Question on windows server 2003 + IIS
- I have windows server 2003 installed on our company’s server. In that server, it also runs IIS Internet Information Services. I set up several web sites there.Now two web site work well – they just have .htm files. While another web site has many .asp files. When user tries to...
- Tags: hunter_jn_cn@..., it management, Microsoft IIS Server, server, Web, Web site, window, windows server
- Q&A 2005-06-07
- Question on windows server 2003
- I’ve just installed windows server 2003 on the server in our company, as NAT server, mail server, web server, and FTP server. The old system on that server was windows server 2000, and all services had been working properly.However after installing windows server 2003, I cannot access our server at...
- Tags: hunter_jn_cn@..., it management, server, window, windows server
- Q&A 2005-06-02
- Question on Online & Offline of Outlook
- In MS Outlook, if we set up an e-mail account with Exchange server type, can work offline and online. My colleague has a problem, when he works at home, with no connection to our mail server, has to reply or write mails in offline state; after he comes back to...
- Tags: hunter_jn_cn@..., Microsoft Outlook, OFFline, server, software
- Q&A 2005-03-15
- Question on Calendar Control in Access
- In Access 2002, I design a form with a field called "starting date", and want to add a calendar control beside this field: when user select a date in the calendar control, I hope the field "starting date" will automatically set its value same as calendar control. And user can...
- Tags: Microsoft Office, Databases
- Q&A 2005-02-24
- Question on Join Query in Access 2003
- In Access 2003, I’ve designed a database, let’s say, with three tables: one is basic info, with part number, description, and so on; second is process work, recording process work for items in first table, with ID, part number, amount, and so on (first table has a one-to-many relation with...
- Tags: first table, hunter_jn_cn@..., Microsoft Access, outsource, software, third table
- Q&A 2005-02-01
- My DHCP server is down! Urgent!
- In Windows 2000 server, when fresh installing, I set up DHCP service for machines in our Intranet. Now the DHCP service is down! In Services, I can start the service manually, but it will stop automatically in a few minutes. And in DHCP console, it always show that "Cannot find...
- Tags: DHCP, DHCP Server, hunter_jn_cn@..., server, windows
- Q&A 2005-01-27
- Question on Access 2000/XP Query
- In Access 2000, I build two Tables, for example, one for Items Basic Info: part number, description, and so on; another for Structure: ID, parent part number, child part number, Qty.Then I have a Query, select parent part number, its information from Basic Info table; based on this query design...
- Tags: hunter_jn_cn@..., Microsoft Access, new record, programming
- Q&A 2005-01-05
