Search results

I have a couple of tables that exceed 200,000 and 500,000 records respectively. What views does anyone have .. is the number of records excessive for an Access '97 split database? Performance is adequate [defined as no complaints from users] so I wonder whether it is worth worrying about .. is...

Access '97 I have googled, searced M$ and these forums but have not found an answer to my question. Given the vintage of the software being used the problem must have been solved .. I just need to track down the solution. How can I review and document security in my split database? I have...

Access '97 I have hundreds of queries that I would like to export the actual query (not the resulting records) into a simple text file. How may I programatically extract the SQL code? What I would end up with query1_example SELECT tbl_temp_crosstab.* FROM tbl_temp_crosstab WHERE...

Objective: To open, read and close an Excel file. The code below works but does not close down the worksheet properly afterwards. The symptoms are: Double-click on the spreadsheet in Explorer and it 'flicks open' then instantly closes again. Double-click on any other spreadsheet in Explorer...

Access '97. We have daily data being added to a series of tables. Is there any way to build a daily running summary of this data automatically? tblEvents containing date time event duration cost summarised into tblEventSummary date event eventcount totalduration totalcost A summary table...

We want a table of standards that are valid between 2 dates so we can have 2 standards for the same part. Is there any way to build validation into the table to prevent standards for the same part having an overlapping date range? e.g. part 1 standard 1 Commences 1st January 2003, ends 1st June...

1 table, 1.5million records, login information date (mostly blank) Reading down the table we see a login date combination followed by several login information records. We wish to add the date to each information line, resetting date to blank on each change of login and changing date if the...

Access '97. Is there a way of querying a given database and reporting basic details (fieldname, size, type, index mode) regarding the structure of the tables? The Documenter can do it but gives too much information, isn't available except in the Developer edition AFAIK, and doesn't lend itself...

Opening a form which had an 'On Open' Event Procedure reveals error: "The expression On Open you entered as the event property setting produced the following error: Duplicate Option Statement" If I remove the open event the error appears on the load event, if I remove both open and load the...

Access '97. I have a series of nested select queries which ask for a date range. One of the queries doesn't re-ask for the date range but just reports what it once ran. This means, if I change the desired date range, the results are not as expected. Any idea how to stop the query persisting...

Access '97. I've built a report based on nested queries which require 5 parameters. I can run the report and have it ask for each parameter in turn or run the query with parameters from the form. How can I pass the form values into the report so I just have to call the report with the right...

I have a text file (a dump of a Unix system report) which I need to import. The file has several lines which can be discarded and relevant information about an item split between multiple lines e.g. Item Number: fred Gll+Bulk Past 12/11/01 19/11/01 Gross Reqs...

Access '97 I've got different back-end databases, all with a table e.g. tblProcess in them. How can I link to all of them simultaneously from VBA controlling their aliases? Access allows me to link, appending 1,2,3 suffixes depending on the link order from the Tables view: How do I mimic this...

Access 97 Which system fields are needed to report which 'back-end' databases tables are attached to a particular database front-end. Ideally listing attached table and the path to it. We can see them in 'linked table manager' but want a report our end users accounts can run

I'm trying to keep user level security organised between 40+ users and 10+ databases. Could someone please post a security query which summarises the security (similar to the documenter) but in a simpler format listing the settings in a single line for each item e.g. item user or group...

How can I link to a back-end table while keeping the same table alias depending on certain parameters? Specifically: I want to be able to link to tables staff1, staff2 or staff3 while calling whichever one I link to 'staff' I'm using Access 97

Novice question: Access '97 Module LRS has PUBLIC udb udb is assigned a value which can be seen in the debug window (just a text string, like "MH" etc). How can the value be seen on a form? All I want is to see the value that's been read from the command line.