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.
Questions tagged [ms-access-97]
41 questions
0
votes
1 answer
Access97 LEFT JOIN SELECT
I'm stuck with some access97 sql,
SELECT Master.Text, Sub.Cnt
FROM Master
INNER JOIN [
SELECT Number, COUNT(*) As Cnt FROM SubTable GROUP BY Number]. AS Sub
ON Master.Number=Sub.Number
WHERE Master.Number=1;
Behaves as I would expect however Where…
robpws
- 79
- 8
0
votes
1 answer
Open Winform based on result from SQL Query
I am currently in the process of transferring an Access97 Database Application to a new WinForms application.
We have a central form for all "Accounts" which shows the general account data, within that form there is a button that opens another…
JammoD
- 419
- 5
- 15
0
votes
0 answers
Left Join Loop in MS Access
Yet another MS Access Question!
I have a simple query where a quick left join is made to find relations of parts. My question is how can I loop this left join to continue until I end up with a empty column (As shown in the image)? The final column…
Tanishq dubey
- 1,522
- 7
- 19
- 42
0
votes
2 answers
Change DB that Access query points to
I'm trying to make a query in Access 97 point to a different database. I cannot find out how to change the db.
I've tried adding another odbc connection but it doesn't give me the option to choose it when running the query.
I've tried to create…
codingNightmares
- 313
- 2
- 9
- 19
0
votes
1 answer
Extract queries from MS access 97
I am working on an application coded with Microsoft access 97 the application is working so good but now I am migrating it to sql server but i need to extract queries in order to understand the content of the old database (Ms access 97) I am not…
Eskander
- 65
- 2
- 2
- 4
0
votes
2 answers
outer join in access
I've 3 tables in total, namely table1, table2 & 3.
Data in table2 & 3 are quite huge, so I wanna outer join table2 & 3 based on the keys e.g. member no & id no first before joining table1.
SELECT
A.field1,
A.field2,
A.field3,…
user2763639
- 9
- 7
0
votes
1 answer
Check directory file size to notify by email if it grows to a certain point
I have an access 97 server on windows that crashes if it's file size grows to be 1GB. I need to either find a software or write something(in java) that checks the directory and notifies us by email if the file size grows to 900MB so we can fix it.…
Taylor Bell
- 63
- 1
- 8
0
votes
1 answer
Error messages when converting access 2000 to access 97
When using access 2003 to convert an access 2000 database to access 97 I get the following 2 error messages right after the other
'invalid argument'
'Some errors happened during the conversion. No converted database was generated.'
Other than this…
kjack
- 2,004
- 3
- 26
- 41
-1
votes
1 answer
Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only
Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only. Error: UCAExc:::3.0.6 Access 97 is supported in read-only. Is there any solution for inserting values to access 97 db in java.
Brahma Dutt Sudhakaran
- 11
- 1
- 6
-1
votes
2 answers
Issues on update/insert a field that the data type is SINGLE
I can't believe in what is happening and is so simple to prove this issue.
You just need to execute the code below into a ACCESS DB using DAO.
CREATE TABLE Table1(Field1 Single)
INSERT INTO Table1 (Field1) VALUES(9.99)
Then
SELECT * FROM…
Paulo Paredes
- 3
- 2
-1
votes
1 answer
Upgrade to a higher version of Access MDB
I have to work with Access-97 databases on a daily basis. I made the mistake of updating to Access 2013 and now I'm stuck because 2013 does not read Access-97. Permanently upgrading these files is completely out of my hands. They are used as data…
Jordan
- 9,642
- 10
- 71
- 141