database linked to txt files - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

database linked to txt files

Edward Mastoloni

5 years ago

I have a database I setup where the tables are linked to txt files. The txt files get deleted and rewritten every night by another program. Everything works fine, but now when I try to use the database in a multi-user environment, users are getting errors that the txt can only be used one user at a time. I was thinking about changing the database tables to be imported (not linked) from the text files but don't know how to automate that import process so it happens automatically in the middle of the night. Is there a way to schedule the task of firing off the saved imports or do you have another solution in mind?

Richard Rost @Reply

5 years ago

Yes, I always recommend importing the data if its stored in text files. Even a single-user database can corrupt a text file. There's a command called TransferText that can be used for this situation. I covered it back in Access 308, which you should have access to. It's on my list to also cover in an upcoming Developer lesson. You can put it in whatever automated nightly routine you have running.

	Edward Mastoloni OP @Reply 5 years ago
Hello Richard. I clicked your link but I am unable to view the class. I can only see a preview or have to buy it. I thought my level of membership would include these classes.

	Richard Rost @Reply 5 years ago
You're a Developer MYOLP student, so you should definitely have access to it. I just logged on to your account and I can see it just fine. Log OFF and back ON again.

	Adam Schwanz @Reply 5 years ago
Happens to me all the time, can't get to the actual video from that page. Go into "My Courses" Here or click on it at the top then go to Access -> Access Old -> Access 2003 300 Level -> Access 308

	Edward Mastoloni OP @Reply 5 years ago
Which Class is Access 308 in MYLOP?

	Edward Mastoloni OP @Reply 5 years ago
Cancel that last msg... I just needed to read Adam's message. Thanks Rich and Adam! :)

	Edward Mastoloni OP @Reply 5 years ago
First, I am using Office 365. Apparently, the TransferText macro has been renamed to ImportExportData. However, when I try to build the Macro, the action ImportExportData doesn't appear in the action dropdown menu. Any ideas?

	Kevin Robertson @Reply 5 years ago
You need to click on the Show All Actions Button.

	Kevin Robertson @Reply 5 years ago

	Edward Mastoloni OP @Reply 5 years ago
Thanks Kevin. That did it. Now I just need to figure out how to purge the table before importing the fresh data

	Richard Rost @Reply 5 years ago
Delete Query or SQL: "DELETE FROM MyTableT"

	Edward Mastoloni OP @Reply 5 years ago
Yep, that worked great. I also had to add an action to the top of the Macro for SetWarnings No and then at the bottom of the macro turn the warnings back on

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View