Stack Overflow
Stack Overflow

Questions tagged [ms-access-97]

Microsoft Access 97 is an older version of Microsoft's entry-level, SQL, database application platform.

Microsoft Access 97 is an older version of Microsoft's entry-level, SQL, database application platform.

40 questions
35
votes
9 answers

Find the directory part (minus the filename) of a full path in access 97

For various reasons, I'm stuck in Access 97 and need to get only the path part of a full pathname. For example, the name c:\whatever dir\another dir\stuff.mdb should become c:\whatever dir\another dir\ This site has some suggestions on how to do…
apenwarr
  • 10,352
  • 5
  • 44
  • 58
5
votes
2 answers

Get tables/schema from access 97 database

I have an Access 97 database that I am trying to get the data schema and the data out of. I don't know how many tables there are, or what they're called, nor what column names there are. I have no problem getting into the database programmatically,…
Cyberherbalist
  • 11,515
  • 15
  • 77
  • 119
5
votes
2 answers

Accessing another password protected database in an SQL query in Access 97

I am currently working on an SQL query for Access 97. Given are the following tables (simplified for demonstration purposes), each of which are located in separate mdb files: Table1 in C:\db\db1.mdb: PartyId (PK) Name ------------ -------- …
Aurora
  • 1,274
  • 7
  • 17
3
votes
1 answer

Reading from an encrypted Access .mdb using Java / Jackcess

I need to read Data from an encrypted Access 97 Database and tried out Jackcess and UCanAccess. I'm using jackcess-2.1.2.jar, jackcess-encrypt-2.1.0 and bcprov-jdk15on-152.jar from bouncycastle.org As UCanAccess uses Jackcess internally I'm getting…
A. Rohmann
  • 91
  • 1
  • 8
3
votes
1 answer

How to use VBA to browse to file in Access 97?

I'm trying to write a message dialog to prompt the user to point to a TXT file that will be analysed by the program. How can I make this file explorer prompt in VBA 97? There's supposed to be a 'openfile' function somewhere but I can't find it.…
Johnny Bigoode
  • 500
  • 7
  • 29
3
votes
6 answers

I need to write an Access 97 .mdb file

I need to export data from a SQL server 2005 DB to an Access 97 .mdb file. The client that needs it, needs it to be Access 97 because the system that they're importing it into requires Access 97 file format (don't get me started). Any suggestions…
leebrandt
  • 1,788
  • 1
  • 13
  • 21
2
votes
0 answers

Programmatically add Column Comment to Microsoft Access-97 Database

I have to programmatically update a large number of Access-97 databases with new tables and columns, and wish to fill in the description for each of the new column. To this end I have created code along the following lines:- Dim MyTable As…
Brian Hooper
  • 20,414
  • 23
  • 82
  • 132
2
votes
2 answers

Creating Access 97 format Database

Most of the example codes on the internet use either access97 or 2000 format database.In a database creation code it was mentioned that if Jet OLEDB:Engine Type=4 is used the database created is access 97 format and if Type=5 than access 2000…
Dario Dias
  • 759
  • 4
  • 18
  • 31
2
votes
2 answers

A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll

I am building a C# application that reads a text file, writes the data read into an access 97 DB, it then reads the db and writes a file. I seem to be having some issues with my OLEDB connection string. Below is my code, anyone have any ideas why I…
GhostDZ9
  • 147
  • 1
  • 6
  • 18
2
votes
1 answer

How can you convert an ACCDB to an MDB programmatically?

Is there a way to programmatically convert an Access 2010 ACCDB file to an Access 95/97 MDB file?
CJ7
  • 20,640
  • 59
  • 173
  • 305
2
votes
2 answers

VB6 application keeps lock on Access (.mdb) database after creation, causing an error 3028

Our application builds an Access database (.mdb) and then starts a different application with the Shell command which needs Read/Write Access to this very database. The problem is that on some systems our application seems erratically to retain an…
Dabblernl
  • 14,939
  • 16
  • 90
  • 141
2
votes
2 answers

Convert Access Database to 97 format

Is there a way of converting an Access Database into a 97 file format, using Access 2007. I know the GUI cant do it, and I have tried: Application.ConvertAccessProject _ SourceFilename:="C:\cCentre\Database\CommDBBad.mdb", _ …
Stone
1
vote
2 answers

Access 97 databases

I had been told that if I open Access 97, the whole system or at least most of it are inside some database. Is it true? For example if I write some VB code into it, the whole code is inside some database. I thought before that only the data I fetch…
amateurprogrammer
  • 93
  • 6
1
vote
1 answer

Access 97 VBA writing code

I found that I can write code just by typing everything or activate element, then click for example OnClick property and write code to between the sub-end sub lines. One person I met said that one has always use mouse and select the property in…
puzzleenthusiast
  • 133
  • 1
  • 1
  • 5
1
vote
1 answer

Navigate programmatically through the records of a continuous form

I would like to navigate through the records of a continuous form in Access 97. I don't find how to do it. This is what I tried: Me.RecordSetClone.MoveFirst moves to the first record logically, but not in the UI. Also the CurrentRecord property does…
Lorenz Meyer
  • 17,418
  • 21
  • 68
  • 109
1
2 3