Database Splitting
What other alternative do I have to split a lotus note database beside writing a code to copy document to newly created database? Software/Hardware used: Lotus Domino
What other alternative do I have to split a lotus note database beside writing a code to copy document to newly created database? Software/Hardware used: Lotus Domino
5 pts.
Closing Open Databases
I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...
I've been doing access for years, but only really developing one mdb at a time. My new job has me working on this product called UA, which does some pretty slick stuff that I haven't seen before.. Always fun to learn. Anyway, this product has multiple mde's that all are "called" from a main System...
Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
General question about Database Performance Management Software
I was just told that Database Performance Management Software apps are always stand-alone applications. That doesn't seem right to me. Are DPMS tools always stand-alone?
I was just told that Database Performance Management Software apps are always stand-alone applications. That doesn't seem right to me. Are DPMS tools always stand-alone?
T-SQL query to ACESS 2007 database
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks
Microsoft Access table dropped primary key and index
I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...
I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...
Access - Bound sub form trying to set the value of an unbound field
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.
database saves to new file
Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.
Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.
table from gridviewwith sql vs2008
hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the...
hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the...
conversion from FileMaker Pro to Microsoft Access database
How do you convert filmaker pro 7 database to an access 2007 database file
How do you convert filmaker pro 7 database to an access 2007 database file
With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form...
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form...
Microsoft Access Audit Report
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...
I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...
MS-Access
Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...
Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...
Query showing vbCRLF in string data
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....
Access database table linked to Excel file question
Can multiple instances of the same access database be open when linked to same excel file?
Can multiple instances of the same access database be open when linked to same excel file?
Retrieving Records based on Record Selection from another table
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...
Performance Issue with an Access File Updated through an .accde file with Linked Tables
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...
How a S/W in c# working in N/W accesses access database from other computer not having access
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?
Access Database update question
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database...
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database...
