I am trying to speed up some operations in my database.
I have an Idea I want to test
I want to change the link of a table from one txt file to the next. I can’t seem to figure it out.
I am currently importing the txt file using TextTransfer for each record and deleting it. I think that changing the link will be faster than importing 1000+ records and deleting them each time. Code is as follows. I have named the path with a test name for example. I have this code in a function where it gets the path in order to know what to change the link to.
This is urgent any help is appreciated.
'for example only
varTestFilePathNew = "\\testing\test\er5-s1.txt"
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = DBEngine.Workspaces(0).Databases(0)
Set tdf = db.TableDefs("tblRawDiePassiveLink")
tdf.Connect = ";DATABASE=" & varTestFilePathNew & "; specDieImportPassiveRev1"
MsgBox "" & tdf.SourceTableName & ""
OK, in case you’re curious, here is some code using the Connect Property. Paste it behind a button and try it. The gist of my last post was, although I am frustrated that I can’t get the Connection Object
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Database tuning – How to start and what to tune.
This question is frequently asked by many people, both online and offline.
There is no hard and fast rule-of-thumb for performance tuning, however, before beginning the tuning process one should a…
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library. Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…