Hotel database (Rooms availability) using Access 2007
Hi there… I’m working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

Answer Question   |  November 24, 2008  1:55 PM
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007

Random values selection
how i can select random values from a coloumn from a given table

Answer Question   |  November 25, 2008  5:12 AM
Database programming, tables

E-mail Notification
Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?

Answer Question   |  November 26, 2008  5:02 AM
Access 2007, Access 2007 alerts, Database alerts, Email alerts, Microsoft Access, Microsoft Access 2007

Create DB2 table relations
There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might not able to manually [...]

Answer Question   |  November 24, 2008  10:34 AM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships

Beginner – How to move a table
I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I’d like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP [...]

Answer Question   |  November 25, 2008  7:32 AM
Microsoft Access, Microsoft Access tables

Converting SQL data to Microsoft Access through coding in VB.NET
I have tables in SQL and i want to port them to MS access through coding in VB.NET

Answer Question   |  November 26, 2008  7:01 AM
Data migration, Database, Microsoft Access, SQL, Visual Basic .NET

Connect DBF
How can i connect DBF By VB.NET

Answer Question   |  November 21, 2008  5:02 AM
Database connectivity, dBASE, FoxPro, VB, VB.NET, Visual Basic, Visual Basic .NET

How do I convert a Unix text file from IFS to a DB file on AS400?
I’ve got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. [...]

Answer Question   |  December 1, 2008  12:22 AM
AS/400 FTP, Copy From Import File, CPYFRMIMPF, Database conversion, Flat files, IFS, Integrated File System, Unix

How do I read in the comma delimited files by SAS
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed “sheet 1″ and second for the sheet tabbed “sheet 2″? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read [...]

Answer Question   |  February 9, 2010  5:36 PM
CSV, Delimited function, Microsoft Excel, SAS

Knowledge management (KM) system for large organisation?
We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries directly in a database and thereby make the summaries available to all members of the [...]

Answer Question   |  November 21, 2008  12:56 PM
Database, Knowledge management, Knowledge management applications, Knowledge Management Software

Two programs with separate SQL Databases
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

Answer Question   |  November 21, 2008  11:07 PM
Database, SQL, SQL Database

Limit SQL Admin Access to a single DB
I need to set up admin access on a MS SQL server but limit the access to a particular db.

Answer Question   |  November 21, 2008  10:09 PM
SQL 2005 admin, SQL Security

Mirror Database
Is it possible to test mirror database logic with a single machine?

Answer Question   |  November 26, 2008  1:37 PM
Database, Mirror, Server

Microsoft Access QueryDef problem with numeric column anme
I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in [...]

Answer Question   |  November 20, 2008  12:15 PM
Database programming, Microsoft Access, Microsoft Access forms, Microsoft Access queries, Microsoft Access QueryDef, Query Definition, QueryDef

SQL query to select highest test score
I am writing a sql to bring someone’s highest test score into a table. The sql is bringing in the highest test score possible, rather than the person’s test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What [...]

Answer Question   |  November 21, 2008  11:42 PM
Distinct Records, MAX, SQL, SQL Query, SQL tables

Sort Access Query From Variable
I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it’s sorted by the field name I type in the text box. [...]

Answer Question   |  November 19, 2008  9:12 PM
Access query, Microsoft Access

Export Attachmets
How do you export all attachments for all records from Access 2007 database?

Answer Question   |  November 19, 2008  6:44 PM
Access 2007, Access Database, Access Database Attachments, Export, Microsoft Access

Adding new entries to a table via a combo box in a form
I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can’t add new attendees via that same combo box. [...]

Answer Question   |  November 19, 2008  5:41 PM
Access 2003, Access Database, Database issues, Microsoft Access

Is Networking right option for MCA student
i am doing mca. i am not having networking as subject . but i want to choose networking as career. what are the different ways to learn networking..

Answer Question   |  November 17, 2008  12:02 PM
IT careers, IT education, Masters in Computer Application, MCA, Networking careers

Appeon for PowerBuilder on Linux
I’ve installed Appeon for Powerbuilder on win2000 server, and I’m trying to access it from linux with Ies4linux, but it doesn’t work, my page is blank ( I’ve install wine,cabextraxt & Ies4linux ), why it happen, have I lost my steps ?

Answer Question   |  November 17, 2008  7:33 AM
Appeon for PowerBuilder, CABextract, IEs4Linux, Linux, Linux interoperability, PowerBuilder, Sybase, Web enabling, Windows 2000 Server, Windows interoperability, Windows on Linux, Windows on Unix, Wine