Rabu, 21 Maret 2018

Re: [MS_AccessPros] Re: New project - I will need some help I'm sure

 

I had added a file several months ago to our group site with code for creating the temp Access file.


https://xa.yimg.com/df/MS_Access_Professionals/CreateTableDemo.zip?token=OE_ZnIOyiH6tYd0vV1Nvr2xL2LlOyQHqkP3S5ppc3YzabtiLZf8VDcBE4e_wLYNmWu5EEbH2KDSwkH4OzK7ridI7v33UjYZ3hyRXtK05KS5e7E6UyMvtbxz8l1Y&type=download


Duane


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of nigel@pegasusconsulting.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, March 21, 2018 10:39 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: New project - I will need some help I'm sure
 


Thanks Duane...


---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Nigel,

A - The Dir() function can be used to find if files exist in a folder. I would save the folder locations in a table, NOT IN YOUR CODE. You might also store the character patterns like HZN, IDA, etc.

NJ - hadn't thought of that, thanks! So if a file exists, what is a recommended function/steps to import the data from txt file into a temporary accdb or table?

B - There are tons of conversion functions for strings and numerics.

NJ - thanks

C - I would create a temporary import accdb or possibly create links to the text files. I try not to import directly into my files since will cause bloat. I also prefer to not pull directly into the main data tables.

NJ - no idea how I would use links here. Does using links mean than all operations e.g. reports would access the data and recalculate every time they run?

D - Adding an date/time field with a default value of Now() should work.

NJ - already done, thanks

E - Update queries could possibly be used.

NJ - done this too!

F - I would probably set up an Archive folder and use VBA to move the files.
G - Access can handle lots of records. This might depend on how you have created your tables and how you use them. SQL Server is a good alternative if your Access file gets too large.

NJ - does Access have a max number of records, or is it memory-dependant?

Thanks for advice so far - N



__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar