Tables In Access That Are Linked To .CSV Files

[jsparks]

I have 3 .CSV files that are created on a UNIX server at 5:00PM every day. Those 3 .CSV files are copied to the NT server running our Intranet at 5:15PM every day. In my Microsoft Access database, I have 3 tables that are linked to those .CSV files.

This method of getting new data every day has worked great until I got to the reporting stage.

First, when doing a blank report and choosing my datasource, if I choose ODBC and find the database as it is setup as a system DSN, the 3 tables are not available to add to the report, they do not show up in the list.

Second, I can choose "Find Database" and go point to the actual .MDB file, and the three tables show up. But when I try to add them to the report I am asked for an Access Password.

I do not have any passwords setup on this database at all. I am not using any security on it at the Access level. In fact, the database file itself is pretty much open to every user on the network. It has to be an Access/CR8 issue because the database itself works fine without any authentication, as does every other table in the database.

Any suggestions on how to get to this data? These tables contain the data I need to perform important calculations in my reports. The only other suggestion has been to write some sort of VBA code to automatically import the data every day and stop using linked tables. I'm hoping for a simpler solution before I head down that road.

Any help is greatly appreciated. Thanks!

Jim Sparks

 

[tc3596]

not sure about the password deal, but you could create an odbc datasource directly to the *.csv files. As long as they are in the same directory and the fields are the same. I've used this method before and it's worked ok.