Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Attribute problems w/ Access database

Status
Not open for further replies.

dlingo

Programmer
Nov 19, 2001
60
US
I'm trying to export an Access database into an Excel spreadsheet. I have written a front-end that allows the client to specify which fields within the database table he wants to export into the Excel spreadsheet. The front end passes these values to the back-end, where a temporary table is created. A VB Standard .exe is used to export the values and is called using ASPExec. Everything works beautifully as long as I manually change the file attributes for the access database file to system (instead of archive) before each call to the .exe. This obviously will not work from the client machine. I've added VBScript code that changes the property while the back-end is executing and I've even written another VB .exe to change the file attribute during back-end execution, but for some reason the file attribute is automatically changed back to archive each time the Access database is accessed. This causes major problems. Instead of returning all the rows in the database, I'm only able to return one. I need to find a way to change this file attribute. Is there anything I can do about this?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top