Re: How To Open or Load ODBC Connection?
- From: "Dave Patrick" <DSPatrick@xxxxxxxxxxxxxxxx>
- Date: Tue, 4 Apr 2006 20:46:28 -0600
No, not design view. No don't change a thing. Just open the table to view
the records. The [Connect] column will be populated in the rows related to
your linked tables with the current connection string. Please post this.
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"la knight" wrote:
|I look in the Help menu to find out how to unhide MSysObjects Table and I
| found it but it says I can only open it as Read Only. In the table is a
| "Connect" field with "Memo" as its data type but it is blank. The only
| settings listed for "Connect" are as follows:
| Required: No
| Allow Zero Length: Yes
| Indexed: No
| Unicode Compression: No
| IME Mode: No Control
| IME Sentence Mode: None
| No Lookup value listed either.
| There's also a field name called "Database" which is setup exactly the
same
| as "Connect".
| Now if this file would need to be changed I'm not sure how I would do that
| if I can only open as Read Only?
|
|
| "Dave Patrick" wrote:
|
| > Can you post the string in the 'Connect' column of the hidden table
| > 'MSysObjects'
| >
| > --
| >
| > Regards,
| >
| > Dave Patrick ....Please no email replies - reply in newsgroup.
| > Microsoft Certified Professional
| > Microsoft MVP [Windows]
| > http://www.microsoft.com/protect
| >
| > "la knight" wrote:
| > | As far as I know I shouldn't have to setup individual client data
sources.
| > | That's what I'm trying to avoid. But I'm not exactly sure. If I define
| > Public
| > | or Global const is there a way to call on those as some type of Sub or
| > | Function in VBA? because I have these setup under General/Declarations
but
| > | I'm not sure how to call them into use:
| > | Public const (which describes sServerIP)
| > | Public const (which describes sDSN)
| > | Global const (which has a string defining the connection)
| >
| >
| >
.
- References:
- Re: How To Open or Load ODBC Connection?
- From: Dave Patrick
- Re: How To Open or Load ODBC Connection?
- From: Dave Patrick
- Re: How To Open or Load ODBC Connection?
- From: Dave Patrick
- Re: How To Open or Load ODBC Connection?
- Prev by Date: RE: Priority Change Update all records
- Next by Date: Re: Converting 97 mdb to 2003 mdb produces errors with MSysobjects and MsysACES
- Previous by thread: Re: How To Open or Load ODBC Connection?
- Next by thread: objEmail.HTMLBody inserting "! " characters into e-mail
- Index(es):
Relevant Pages
|
