|
 |
access thread: Accessing .DAT File From Access DB Table
Message #1 by "Matthew F. Davis" <matt@m...> on Thu, 18 Oct 2001 19:29:42
|
|
I have an access db that grabs two of it's tables from .DAT files. The
dat files are between 2mb and 80mb. We have a VB application that does
this, but the developer who wrote the code disappeared. Does anyone have
any idea how these files are used/queried by Access? We are at the point
of hiring someone to help us get this going, so any suggestions,
referrals, etc would be really helpful.
Message #2 by "John Ruff" <papparuff@c...> on Thu, 18 Oct 2001 13:03:25 -0700
|
|
The database will have to be analyzed to determine how the .dat files
are used. There's no way to determine this any other way.
John Ruff - The Eternal Optimist :-)
Message #3 by Walt Morgan <wmorgan@s...> on Thu, 18 Oct 2001 14:18:08 -0500
|
|
Matthew,
Do the files (.DAT) change or are they static? Is data being collected
elsewhere into these .DAT files? Do you have the source code from VB?
Answers to these questions will go a long way in determining what path you
will need to take.
Regards,
Walt Morgan
Message #4 by "Preethi" <preethi@s...> on Fri, 19 Oct 2001 08:50:28 +0600
|
|
It is nearly cracking the Fiel system of .DAT
The Programmer would have used any special characters to sperate fields,
records etc.
Even the too could be encrypted.
The commonly used method is a simple text file with a .DAT extension
If not so, you may have to find the special characters, encryption method
etc.
You may try using file opening methods like:
Open pathname [For Random] As filenumber Len = reclength
Message #5 by "Mike McCrossin" <mike_mccrossin@h...> on Fri, 19 Oct 2001 06:35:07 -0700
|
|
Hi Matthew,
Accessing .DAT files from Access DB Table
You need to determine how these files are being used by MS Access. The first thing to do is track down the code in MS Access to see
how the programmer linked to these files. It may be that the .DAT files are in an encypted format and MS Access is converting the
data as it reads it. Another method that might be happening is that MS Access is importing the .DAT data into a MS Access table.
Either way you need to determine what format the .DAT files are in. If you have a dba (data base administrator) they might be able
to tell you how or where the .DAT files come from.
One of the places to check is the Linked Table Manager.
This is is located in the Tools menu / Add-ins/Linked Table Manager
What you look for here is to see if any of the link paths points to the .DAT files. I am guessing that there won't be but you never
know.
that is all for now...Mike
>From: "Matthew F. Davis"
>Reply-To: "Access"
>To: "Access"
>Subject: [access] Accessing .DAT File From Access DB Table
>Date: Thu, 18 Oct 2001 19:29:42
>
>I have an access db that grabs two of it's tables from .DAT files. The
>dat files are between 2mb and 80mb. We have a VB application that does
>this, but the developer who wrote the code disappeared. Does anyone have
>any idea how these files are used/queried by Access? We are at the point
>of hiring someone to help us get this going, so any suggestions,
>referrals, etc would be really helpful.
|
|
|
View Cart
