Re: Relink question

Hi Bruce

Yes, you should Dim dbBE as DAO.Database. (It could be declared as Object,
but every database should have a reference to DAO anyway, so early binding
is faster and gives better compile-time checking.) In any case, it will
need to be declared.

BTW, EVERY variable you use should be declared. using implicit declaration
is asking for trouble. EVERY module, including Form and Report modules
should have Option Explicit at the top.

The path to the backend is just that - the full file path - for example:
"\\MyServer\SomeShare\My App Folder\Back-end file.mdb"

BTW, there is no law that says an Access database must have the extension
"MDB". All my backends are .ABE files (Access Back-End). It at least
discourages users from double-clicking on them to open them!


--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"BruceM" <bamoob@xxxxxxxxxxxxxxxx> wrote in message
news:OiysMhoSJHA.5900@xxxxxxxxxxxxxxxxxxxxxxx
I'll give that a try when I have a chance to get back to it, which may not
be tomorrow. Two more questions for now: Is there any need to made the
dbBE variable a DAO.Database? And is the path to the back end a path
first to the Access executable, followed by a switch that includes the
path to the BE (like with decompile, etc.), or is it just a direct path to
the BE file?

BTW, I don't think I have a project so far with more than maybe 20 tables
in a single BE database.


.

Relevant Pages

  • Re: Performance concerns in SPs and Tables
    ... would expect memory to be allocated on declaration; for a varchar, ... procedural code; database access code should be declarative. ...
    (microsoft.public.sqlserver.programming)
  • Re: Access 97 - global variables??
    ... you can define variables in the declaration ... You can use a database property to get them remembered ... my database makes an ODBC connection to a back-end DB2 database ... where on the query properties a ODBC connect ...
    (microsoft.public.access.queries)
  • Re: Syntax to connect to A2K DB with a DB password using VBA
    ... You stated that your code below works for a database without a password, ... there are a few lines of code missing from the code snippet you posted ... Tom Wickerath's explanation of why you should _always_ use "Option Explicit" ... I'd also like to point out that your declaration of "strDBName" (which, ...
    (microsoft.public.access.externaldata)
  • Re: Accuracer C/S Database?
    ... > the database including the declaration of the referential integrity ... >, stored procedure, views, users, user groups and database object ... but also default value, validation, RI, FileEngine, RecordEngine, Encryption, ... > program it in code and re-compile the server. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Swapping Bullshit
    ... >>can't be initialized on declaration, ... >BTW, a variable doesn't even need to have a name or to be declared. ... correcting improper terminology is a must. ... welcome to clc: http://www.ungerhu.com/jxh/clc.welcome.txt ...
    (comp.lang.c)