Re: Relink question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Bruce

Finally, if you use user-level security then I recommend you read the
section on linked tables (section 14) in the Access Security FAQ:
http://support.microsoft.com/support/access/content/secfaq.asp

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"BruceM" <bamoob@xxxxxxxxxxxxxxxx> wrote in message
news:u0vgJpwSJHA.5056@xxxxxxxxxxxxxxxxxxxxxxx
I declare every variable. I have chosen Option Explicit as the default
option, so Access won't let me implicitly declare. It has been a great
help with debugging.

I didn't know that about using an extension other that mdb for BE files.
ABE is not a registered file type on my machine, so I suppose that means I
would need to add it. I use user-level security for my split databases
(which is all of my newer ones), so a user who attempts to open the file,
either FE or BE, by double clicking the icon will receive a message about
insufficient permissions. The only way in is through a shortcut that
temporarily joins the user to the secure workgroup file.

Thanks again for the information. This is an area of Access with which I
have had little experience, due in large part to a lack of information. I
have lots of information now, so I can work on gaining experience.

"Graham Mandeno" <Graham.Mandeno@xxxxxxxxxxxxx> wrote in message
news:OTS5XKpSJHA.1908@xxxxxxxxxxxxxxxxxxxxxxx
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: splitting the database and securing the back-end file?
    ... Setting a database password is NOT user-level security. ... Graham Mandeno ... what goes in the back-end, ...
    (microsoft.public.access.security)
  • Re: splitting the database and securing the back-end file?
    ... Setting a database password is NOT user-level security. ... Graham Mandeno ... what goes in the back-end, ...
    (microsoft.public.access.security)
  • run stored proc from excel with a parameter
    ... declare @sql nvarchar ... [Database Name] ... [Custodian Name] ... [Near Dups File Count] ...
    (microsoft.public.excel.programming)
  • Re: CDatabase CRecordset - How to get the number of rows?
    ... What is the value of dataStr in the CRecordset::Open call. ... > // Declare a long to hold the row count for the fast method ... > // Declare a long to hold the row count for the slow method ... >>> I'm now testing my DLL with the real database. ...
    (microsoft.public.vc.mfc)
  • Re: Update databases
    ... Compares if all tables in one database have analog in second ... declare @sqlStr varchar ... exec ('declare @Name sysname select @Name=name from ... -- ##CompareStr - will be used to pass comparing strings into dynamic script ...
    (microsoft.public.sqlserver.programming)