Thread: Update Table
View Single Post
  #9  
Old May 6th, 2010, 11:33 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Update Table - stevie PIMPS again!

See where Steve says to rename a file from .mdb to .dbf to make it a dBase
III file.

Subject: Export an Access Table as an dbase III file 5/6/2010 1:55 PM
PST

By: Steve
In: microsoft.public.access



Hello Bill,

Try exporting your file with a .mdb extension then renaming the file to a
...dbf file. Put the following code after your DiCmd.TransferDatabase command:

Dim OldName, NewName
OldName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.md b"
NewName = "K:\CPANALYSIS\BusinessMgt\VP\Access\DBASE\tbs1.db f"
Name OldName As NewName

Steve


http://www.microsoft.com/communities...&lang=en&cr=US

--
Build a little, test a little.


"John... Visio MVP" wrote:

"Steve" wrote in message
...
Rob,

If you get this to work for you manually, I could automate it for you so
you click a button on your end and then your users click a button on their
end. I provide fee-based help with Access applications. There would be a
small fee to automate this for you. Contact me if you want it automated.

Steve



Stevie, if you were any good, you would have repeat customers that would
keep you busy. Pimping your services in a free support venue also shows that
you have no ethics and are definitely not someone to trust.



Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

.