Replies

Make a copy of your database first. Then try running a make table query. Then you could go back and delete any tables that are now of no use.

Copy the Excel data you want in the database to the clipboard. Then select a new record in the table and paste from the clipboard. This only works if you have the same number of fields and the data types match.

You will have to obtain the mdb version of the database to modify what toolbars / buttons are visible. Then the mdb will have to be converted to the runtime version to get you back to where you were.

While in report design place your cursor in the box at the junction of the two margins in the upper left. This is the place to select the report. Right click, properties, record source. Then use the down arrow to select your new query. I usually create a new query for each report. That should get you started.

In Access 97 you can read about the specifications in the help index.

Specifications
Microsoft Access
Microsoft Access Specifications
Read about table specifications

The max number of fields in A97 is 255.

I keep a Word file with the code I discover.
The code snippets are bookmarked.
I created an index that is hyperlinked to the bookmarks.
Plus the word file is searchable.
I also store demo databases in a directory called Access. Subdirectories under the Access directory
are named to reflect what the database addresses.

Here is some code that I found on one of the message boards. Don’t remember which one.

‘Print vertical lines on a report that will adjust in size (vertically) to match the size of a text box set to grow if necessary ‘(CanGrow is set to True). Put the following code into the Detail Section’s On Print event.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim sngKeyWordsTop As Single
Dim sngKeyWordsLeft As Single
Dim sngKeyWordsHeight As Single
Dim sngKeyWordsBottom As Single
sngKeyWordsTop = Me![txtTopicKeyWords].Top
sngKeyWordsHeight = Me![txtTopicKeyWords].Height
sngKeyWordsLeft = 1650
sngKeyWordsBottom = sngKeyWordsTop + Me![txtTopicKeyWords].Height
Me.DrawStyle = 6
Me.DrawWidth = 12
Me.Line (sngKeyWordsLeft, sngKeyWordsTop)- _
(sngKeyWordsLeft, sngKeyWordsBottom), RGB(0, 255, 0)
End Sub

I have a similar problem when linking Access97 to Lotus Notes databases. I run my reports once a month.
I import the data that I need via a make-table query each month. Then I run my reports / queries.
Maybe a similar approach would work for you.

Look for missing references in your 2000 mdb file.

Open any module. Select Tools / References.

I know enough to maybe get you started.

First determine what the database software is. For example DB2.
Then go to Settings / Control Panel / Datasources(ODBC) / Datasource.
Then install your ODBC driver. If the drivers are not on your list, you will have to obtain the driver.
Try a search on the internet. For example,use the following search terms: ODBC Driver DB2

After you have installed your driver do the following.
Open your Access database.
File / Get External Data / Link Tables / Files of type – select ODBC databases / Machine Data Source / Select a source name.
Then you should be able to select your table on the mainframe.

Good luck.

How about setting the hidden property of the file?

Try creating a query with your company field.

Then in design view right click on the field and select totals.

This will give you all of the company names once.

How about making the application an Access runtime?

This way the user would not need Access to run the application.

Surely that would satisfy the tax people.

Thank you, the both of you.

I will strive to do this on the report instead of the query.

I would try searching with google on the terms cracker and Access. Crackers enable you to extract the password. The following site looks promising. http://www.bokler.com/crak_body.html