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.

41 questions
1
vote
2 answers

Remove password of .mdb file in office2007, created in access97

So I have an access mdb file that was originally create using Access 97/Office 2003. Since I have recieved a new work that has 2007 Office installed. The file extension of the access database is still mdb + password protected. I opened it in 2007…
user8888885
1
vote
1 answer

Why does Join()-ing a Split() with limit 64 return more than 64 substrings?

I have to limit a string to a maximum of 64 substrings, which are divided by ;. The input string contains 113 substrings: x2BlackList =…
Marc Dingena
  • 556
  • 5
  • 19
1
vote
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
  • 145
  • 1
  • 6
  • 18
1
vote
1 answer

Converting Access 2000 database to Access 97 using Access 2003

I have an access databse (from an opensource project) that's in Access 2000 format. All text fields, I've looked at, have ALLOWZEROLENGTH set to TRUE and DEFAULT to "" (empty string). On conversion to Access 97 (using Access 2003) the…
kjack
  • 2,004
  • 3
  • 26
  • 41
1
vote
1 answer

Adding New Row Data from C1FlexGrid to Access 97 .mdb Database C#

As a quick background, I'm a beginner at database programming so forgive me if anything that I post here doesn't make sense or is outright dumb. I'm trying to make a WinForm application that will allow users to connect to a .mdb Access 97 database…
Danchez
  • 1,266
  • 2
  • 13
  • 28
1
vote
1 answer

Convert MS Access 97 TO MySQL 5.5 (Is there any Tools ?)

I have huge industry level database in MS Access 97, I am redesigning the application and want to migrate all my existing data to MySQL 5.5. Is there any tool available so that I can migrate all my existing data (MS Access 97) along-with schema to…
Shashank
  • 6,117
  • 20
  • 51
  • 72
1
vote
2 answers

How to increase size of MDB field via DAO?

How can you increase the size of a MDB field size using DAO?
Paul Lassiter
  • 2,641
  • 5
  • 22
  • 25
0
votes
2 answers

Open Access 97 MDB in Excel 2016 VBA - Trouble with my script

My company recently upgraded Office 2010 to 2016 which broke some of the automation made by a previous employee. We are running some old software that uses Access 97 and do daily exports of certain tables. I've figured out how to open the database…
error500
  • 15
  • 6
0
votes
1 answer

Avoid stopping on error when in debug mode Access 97

When I enter into debug mode in Access 97, the program will halt on any error, even if that error is occurring after On Error Resume Next. I have a function that tests if an element key is in a Collection Col using On Error Resume Next var =…
Lorenz Meyer
  • 19,166
  • 22
  • 75
  • 121
0
votes
1 answer

Reading unsigned tiny int from Access97 db

I have an ancient Access97 database that contains astronomical data that I would like to use in a telescope's pointing software. The Hour and Minute of Right Ascension are stored as UnsignedTinyInt. I am assuming UnsignedTinyInt is an unsigned…
Cyberherbalist
  • 12,061
  • 17
  • 83
  • 121
0
votes
1 answer

Access97: INSERT INTO if not exists

I need to do a very simple task: execute an INSERT INTO query only if the record doesn't exist in the table. I found a lot of hints out there but none of them work in SQL Access97. Example: IF NOT EXISTS ( SELECT 1 FROM Users WHERE FirstName =…
Mark
  • 4,338
  • 7
  • 58
  • 120
0
votes
2 answers

How to connect to MS Access 97 (with workgroup mdw) database using pyodbc

In a Python script with pyodbc, I am trying to connect to a still used Access 97 database on our network but I have problems to get the connection (or the connection string) to work. I keep getting the following error: pyodbc.Error: ('IM002',…
moster67
  • 830
  • 3
  • 12
  • 30
0
votes
0 answers

Recover VBA-code from an Access 95 database file

I need to recover VBA code from an old Access database file. I have tried the decomile trick without success: http://www.granite.ab.ca/access/decompile.htm I have also tried importing from the database file and everything except for the VBA-code…
Peter Wirdemo
  • 498
  • 2
  • 11
  • 25
0
votes
1 answer

How to copy a table's contents from an Access 97 file into an Access 2013 file

We have an VB6 application that used Ms-Access 97 database files in conjunction with a workgroup file. To keep users from accidentically opening the files directly, we have changed the extension of the files from mdb and mdw to sdb and sdw,…
AstaDev
  • 149
  • 1
  • 8
0
votes
1 answer

In Access 97, whats the quickest, surefire way to reveal and open the Tools->References window?

I'm writing some instructions on how to remove missing references that the later versions of Access do not tolerate when migrating from 97 to 2007 for instance. Right now I can reveal the references window by opening a code window by clicking on a…
Isaac Bolinger
  • 7,328
  • 11
  • 52
  • 90
1
2
3