Hold the fortress!!
Doing your search is OK
storing the absolute position is OK
Adding or subtracting 1 is NOT ok, if you think that the next or previous ABSOLUTE record is the next or previous IN SEQUENCE.
The very nature of access is to store records in whatever way it can, and the absolute...
you could do it in your app terminate routine by having something like "copyfile <yourdatabase> backuppath & "Backup.mdb"
ie
assuming your database is in the app directiry, and you want to save it to a backup directory on the "c:" drive
if...
Oops!- Missed a step.
Once you select "ODBC()" as the file type, a pop-up screen will be displayed, showing all the ODBC .dsn files. "Topspeed.dsn" should be listed.
Select it and then you'll get your list of .tps tables to import.
Be prepared to have a coffee break - my...
you need to create an ODBC NDS that points to .TPS files. Once created, all you have to do is open access, create an access database, select "file", "Get external data","import" and change the file type to "ODBC()".
You will then get a list of files and...
We have a program commercially written using topspeed. Using the ODBC drivers was OK to extract data into Access until last week, when we now get an error."Internal error: tpsbt:cpp line 2172"
In the details - "MSACCESS caused an invalid page fault in module C40TRX.DLL....."...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.