Re: ?Examples to create new .mdb file and its tables from code (and more)

On Aug 24, 1:58 am, "Dirk Goldgar" <d...@xxxxxxxxxxxxxxxxxxxxxx>
wrote:
<snip>
To link to a table in the new database, you can use the
DoCmd.TransferDatabase method:

DoCmd.TransferDatabase _
acLink, _
"Microsoft Access", _
strNewDBPath, _
acTable, _
"People", _
"People"

Dirk,

I have used the above code snippet (which suggested) with success.
Now I would like to unlink those tables just before I exist the
database, but I don't see which DoCmd command does that. Can you
help?

- Paul Schrum

.

Relevant Pages

  • ADO error (80004003) on 1 machine
    ... Microsoft Access. ... It was working fine for a lot of machines until ... Here's the code snippet: ... LPTSTR lpstrConnection = ...
    (microsoft.public.data.ado)
  • Re: GetSpellingSuggestions -- 9132
    ... Could you post a code snippet that demonstrates the problem? ... See Howard Kaikow's web site. ... > I have tried on word 2003 with no success. ...
    (microsoft.public.word.vba.general)
  • Re: Access reports create infinite blank pages
    ... printer; without success. ... from a certain point in time - I cannot put my finger on a specific time. ... However I still suspect the printer driver and not Access. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Embedding Java Link in Publisher Website
    ... Thanks for your quick response, I tried your suggestion without ... Code snippet below. ... I am testing the above with no success in preview mode. ...
    (microsoft.public.publisher.webdesign)
  • Re: Cross domain exchange server access, popup boxes....
    ... tried impersonation but not much success. ... Any code snippet will be very ... Prev by Date: ...
    (microsoft.public.win32.programmer.messaging)
Loading