Tables
in [Access]
|
Make Query or Linked Table Read Only In Access 03 & 07 I have tables linked via ODBC to a MySQL database. Due to many security, DB, and vendor issues, I do not have an option to change the MySQL permissions or change the ODBC driver. I need to find a way to make the linked tables read-only (preferred) or at least make queries to those tables rea... 28 Feb 2010 02:24
Church Database Trying to put together a simple database for our church directory and records. We need contact info as well as DOB and group involvement etc. Make directories, labels, email groups and basic reports. Which I had no problems with. What I am having issues with is the family relationship thing. We often need to ... 4 Mar 2010 16:58
Conversion To Acc2007 or beyond Suggestions ? I am currently still using Access 2000 for my database development. The Acc 2000 also works with no problem with Acc 2003. I have also made some minor changes to resolve some issues with Access 2007 and it works with Access 2007. There is a Office 2010 coming out soon and I assume the Access 2007 will work ... 24 Feb 2010 16:35
Assistance with Many-to-Many Relationships I'm looking into correcting a previously developed database that was originally done and works like an excel spreadsheet (all fields are currently in one table). In looking at it, there appear to be many many-to-many relationships involved. This is used to keep records relating to force used against suspects ... 24 Feb 2010 14:18
Append Query and Autonumbering Using Access 2007; have 2 student db last year and this year, using autonumber as identifier. when i append old student to new db so that they keep old number; it causes the new db to change the autonumber when i add a new record to the 1 plus the old number instead of using new new numbers; did not have this p... 24 Feb 2010 13:10
Auto Complete field I am using Access 2010 and I have a datasheet which records Invoice data: Invoice number Client ID Client surname Invoice date Invoice amount Date paid Invoice number is the primary key and the table is linked to the Client datasheet. I would like to be able to enter the Client ID in the Invoice Datashe... 23 Feb 2010 22:45
Remote control of tabls I have a database tables on the back end and multiple versions of front end users. Is there a way to access the table from a remote location though the internet or upload the tables to the internet and have the front end access the information in a way that the updated tables will be available to all? Thanks -... 23 Feb 2010 23:52
Modify existing table for more details? I have a table of estimates. Each estimate can have multiple locations stored as a text field. New need: I want to store the sizes of each location. Example is -Old method: EstNo= 200 which has Location = bedroom, Location= Family room. New need is: EstNo 200, Location = bedroom with Size= 100 and Location= ... 25 Feb 2010 19:25
Efficient Table Design Questions I'm working on a Project Manager DBase for our engineering department. One of the things they want to be able to record within each project is the Size, Length and Material of the pipes installed. They also want to be able to run reports that would provide them totals based upon region, year, etc. So I'm loo... 23 Feb 2010 13:36 |