I converted my Access97 to Access2k and tried running sql calls from the same asp pages.  I get the
following error.


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data.


The setup on my devel pc:  Login to win2kpro as administrator. All site files (html, asp, db) are in folders under wwwroot (IIS5).
Function ocon sets up my connection string.  Both of the strings below give the same error above.


function ocon()
set objcon = server.createobject("adodb.connection")
objCon.open "dsn=mg53r3db"
end function

function ocon()
set objcon = server.createobject("adodb.connection")
objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
end function


I triple-checked that the system dsn is set like I've always set it for use with Access 97.

Within Access 2k, all groups and users have full permissions.  (I know this probably isn't a good idea - I'll change this after I
get the connection working).

This is driving me bonkers - any advice?

Thanks in advance,
Mike

check the permission on the database
Iuser and Wanuser should have read and write rights on the database.

Greetings,
Vinnie

----- Original Message -----
From: "Mike" <mg188@c...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Friday, August 23, 2002 9:47 PM
Subject: [asp_database_setup] can't get asp to work with Access 2k


> I converted my Access97 to Access2k and tried running sql calls from the
same asp pages.  I get the following error.
>
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.
>
>
> The setup on my devel pc:  Login to win2kpro as administrator. All site
files (html, asp, db) are in folders under wwwroot (IIS5).
> Function ocon sets up my connection string.  Both of the strings below
give the same error above.
>
>
> function ocon()
> set objcon = server.createobject("adodb.connection")
> objCon.open "dsn=mg53r3db"
> end function
>
> function ocon()
> set objcon = server.createobject("adodb.connection")
> objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> end function
>
>
> I triple-checked that the system dsn is set like I've always set it for
use with Access 97.
>
> Within Access 2k, all groups and users have full permissions.  (I know
this probably isn't a good idea - I'll change this after I get the
connection working).
>
> This is driving me bonkers - any advice?
>
> Thanks in advance,
> Mike
>
>
%%email.unsub%%
>
>

Thanks Vinnie.  I'm still having trouble with this.  It started working this
morning with the dsn conn string, but just stopped after a couple hours with
the following message.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.

I next created an iuser account in Access 2000 (should it be
iuser-[machinename] or just iuser), and put it in the Access user group,
which has data read/write permission (but not to modify the design).  I
rebooted but get the same error.  IIS still works because asp pages that
don't interact with the database work fine.

Should I create an iuser account at the operating system level too?

This pc isn't running on a lan - it just has a dialup internet connection.
What's the wanuser account for?

Could you recommend a good article on the ins and outs of security setup for
a development machine with win2k pro, iis, asp3, Access2k, and eventually
msde?  I've read some already, and understand authentication and
permissions, but am having trouble with setting up the various pieces.  I've
recently migrated from win98se/pws/access97.

Thanks again,
Mike

----- Original Message -----
From: "Vinnie (Mailinglists Only)" <vinnie@j...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Saturday, August 24, 2002 4:54 AM
Subject: [asp_database_setup] Re: can't get asp to work with Access 2k


> check the permission on the database
> Iuser and Wanuser should have read and write rights on the database.
>
> Greetings,
> Vinnie
>
> ----- Original Message -----
> From: "Mike" <mg188@c...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Friday, August 23, 2002 9:47 PM
> Subject: [asp_database_setup] can't get asp to work with Access 2k
>
>
> > I converted my Access97 to Access2k and tried running sql calls from the
> same asp pages.  I get the following error.
> >
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened exclusively
by
> another user, or you need permission to view its data.
> >
> >
> > The setup on my devel pc:  Login to win2kpro as administrator. All site
> files (html, asp, db) are in folders under wwwroot (IIS5).
> > Function ocon sets up my connection string.  Both of the strings below
> give the same error above.
> >
> >
> > function ocon()
> > set objcon = server.createobject("adodb.connection")
> > objCon.open "dsn=mg53r3db"
> > end function
> >
> > function ocon()
> > set objcon = server.createobject("adodb.connection")
> > objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> > end function
> >
> >
> > I triple-checked that the system dsn is set like I've always set it for
> use with Access 97.
> >
> > Within Access 2k, all groups and users have full permissions.  (I know
> this probably isn't a good idea - I'll change this after I get the
> connection working).
> >
> > This is driving me bonkers - any advice?
> >
> > Thanks in advance,
> > Mike
> >
> >
vinnie@j...
> %%email.unsub%%
> >
> >
>
>
%%email.unsub%%
>
>
>

>Thanks Vinnie.  I'm still having trouble with this.  It started working
this
> morning with the dsn conn string, but just stopped after a couple hours
with
> the following message.

 Error Type:
 Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
cannot open the file '(unknown)'. It is already opened exclusively by
another user, or you need permission to view its data.

=> you still have a permission problem

I next created an iuser account in Access 2000 (should it be
iuser-[machinename] or just iuser), and put it in the Access user group,
which has data read/write permission (but not to modify the design).  I
rebooted but get the same error.  IIS still works because asp pages that
don't interact with the database work fine.
=> you don't create in acces an Iuser. if you want to set the permission
correct you go to the directory where your database is standing and there
you ask the properties of that directory. Once you have done that you should
have there somewhere an Iuser and wanuser (I'm working now with XP and thats
also diffrent from win2k.) There shall stand iuser: read + wanuser: change
(=read + write). they should have both change rights.

I will check it on monday when I'm at the office

>
> Should I create an iuser account at the operating system level too?
=> he is already there
>
> This pc isn't running on a lan - it just has a dialup internet connection.
> What's the wanuser account for?
wanuser = the editor, the one who can make changes. you needs that account
also

> Could you recommend a good article on the ins and outs of security setup
for
> a development machine with win2k pro, iis, asp3, Access2k, and eventually
> msde?  I've read some already, and understand authentication and
> permissions, but am having trouble with setting up the various pieces.
I've
> recently migrated from win98se/pws/access97.
>
> Thanks again,
> Mike

good links are:

www.4guysfromrolla.com
www.aspin.com
http://www.internet.com/sections/asp.html



----- Original Message -----
From: "Mike" <mg188@c...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Saturday, August 24, 2002 11:55 PM
Subject: [asp_database_setup] Re: can't get asp to work with Access 2k


> Thanks Vinnie.  I'm still having trouble with this.  It started working
this
> morning with the dsn conn string, but just stopped after a couple hours
with
> the following message.
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine
> cannot open the file '(unknown)'. It is already opened exclusively by
> another user, or you need permission to view its data.
>
> I next created an iuser account in Access 2000 (should it be
> iuser-[machinename] or just iuser), and put it in the Access user group,
> which has data read/write permission (but not to modify the design).  I
> rebooted but get the same error.  IIS still works because asp pages that
> don't interact with the database work fine.
>
> Should I create an iuser account at the operating system level too?
>
> This pc isn't running on a lan - it just has a dialup internet connection.
> What's the wanuser account for?
>
> Could you recommend a good article on the ins and outs of security setup
for
> a development machine with win2k pro, iis, asp3, Access2k, and eventually
> msde?  I've read some already, and understand authentication and
> permissions, but am having trouble with setting up the various pieces.
I've
> recently migrated from win98se/pws/access97.
>
> Thanks again,
> Mike
>
> ----- Original Message -----
> From: "Vinnie (Mailinglists Only)" <vinnie@j...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Saturday, August 24, 2002 4:54 AM
> Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
>
>
> > check the permission on the database
> > Iuser and Wanuser should have read and write rights on the database.
> >
> > Greetings,
> > Vinnie
> >
> > ----- Original Message -----
> > From: "Mike" <mg188@c...>
> > To: "ASP Database Setup" <asp_database_setup@p...>
> > Sent: Friday, August 23, 2002 9:47 PM
> > Subject: [asp_database_setup] can't get asp to work with Access 2k
> >
> >
> > > I converted my Access97 to Access2k and tried running sql calls from
the
> > same asp pages.  I get the following error.
> > >
> > >
> > > Error Type:
> > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> > engine cannot open the file '(unknown)'. It is already opened
exclusively
> by
> > another user, or you need permission to view its data.
> > >
> > >
> > > The setup on my devel pc:  Login to win2kpro as administrator. All
site
> > files (html, asp, db) are in folders under wwwroot (IIS5).
> > > Function ocon sets up my connection string.  Both of the strings below
> > give the same error above.
> > >
> > >
> > > function ocon()
> > > set objcon = server.createobject("adodb.connection")
> > > objCon.open "dsn=mg53r3db"
> > > end function
> > >
> > > function ocon()
> > > set objcon = server.createobject("adodb.connection")
> > > objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > > Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> > > end function
> > >
> > >
> > > I triple-checked that the system dsn is set like I've always set it
for
> > use with Access 97.
> > >
> > > Within Access 2k, all groups and users have full permissions.  (I know
> > this probably isn't a good idea - I'll change this after I get the
> > connection working).
> > >
> > > This is driving me bonkers - any advice?
> > >
> > > Thanks in advance,
> > > Mike
> > >
> > >
> vinnie@j...
> > %%email.unsub%%
> > >
> > >
> >
> >
> %%email.unsub%%
> >
> >
> >
>
>
%%email.unsub%%
>
>

Hi Vinnie - I created the iuser & wanuser accts and set permissions at the
directory level (where the db is stored).  Still didn't work, but when I set
the permissions for those 2 users directly in the properties of the .mdb
file, it started working.

Thanks for putting me on the right track.

----- Original Message -----
From: "Vinnie (Mailinglists Only)" <vinnie@j...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Sunday, August 25, 2002 1:23 AM
Subject: [asp_database_setup] Re: can't get asp to work with Access 2k


> >Thanks Vinnie.  I'm still having trouble with this.  It started working
> this
> > morning with the dsn conn string, but just stopped after a couple hours
> with
> > the following message.
>
>  Error Type:
>  Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine
> cannot open the file '(unknown)'. It is already opened exclusively by
> another user, or you need permission to view its data.
>
> => you still have a permission problem
>
> I next created an iuser account in Access 2000 (should it be
> iuser-[machinename] or just iuser), and put it in the Access user group,
> which has data read/write permission (but not to modify the design).  I
> rebooted but get the same error.  IIS still works because asp pages that
> don't interact with the database work fine.
> => you don't create in acces an Iuser. if you want to set the permission
> correct you go to the directory where your database is standing and there
> you ask the properties of that directory. Once you have done that you
should
> have there somewhere an Iuser and wanuser (I'm working now with XP and
thats
> also diffrent from win2k.) There shall stand iuser: read + wanuser: change
> (=read + write). they should have both change rights.
>
> I will check it on monday when I'm at the office
>
> >
> > Should I create an iuser account at the operating system level too?
> => he is already there
> >
> > This pc isn't running on a lan - it just has a dialup internet
connection.
> > What's the wanuser account for?
> wanuser = the editor, the one who can make changes. you needs that account
> also
>
> > Could you recommend a good article on the ins and outs of security setup
> for
> > a development machine with win2k pro, iis, asp3, Access2k, and
eventually
> > msde?  I've read some already, and understand authentication and
> > permissions, but am having trouble with setting up the various pieces.
> I've
> > recently migrated from win98se/pws/access97.
> >
> > Thanks again,
> > Mike
>
> good links are:
>
> www.4guysfromrolla.com
> www.aspin.com
> http://www.internet.com/sections/asp.html
>
>
>
> ----- Original Message -----
> From: "Mike" <mg188@c...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Saturday, August 24, 2002 11:55 PM
> Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
>
>
> > Thanks Vinnie.  I'm still having trouble with this.  It started working
> this
> > morning with the dsn conn string, but just stopped after a couple hours
> with
> > the following message.
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine
> > cannot open the file '(unknown)'. It is already opened exclusively by
> > another user, or you need permission to view its data.
> >
> > I next created an iuser account in Access 2000 (should it be
> > iuser-[machinename] or just iuser), and put it in the Access user group,
> > which has data read/write permission (but not to modify the design).  I
> > rebooted but get the same error.  IIS still works because asp pages that
> > don't interact with the database work fine.
> >
> > Should I create an iuser account at the operating system level too?
> >
> > This pc isn't running on a lan - it just has a dialup internet
connection.
> > What's the wanuser account for?
> >
> > Could you recommend a good article on the ins and outs of security setup
> for
> > a development machine with win2k pro, iis, asp3, Access2k, and
eventually
> > msde?  I've read some already, and understand authentication and
> > permissions, but am having trouble with setting up the various pieces.
> I've
> > recently migrated from win98se/pws/access97.
> >
> > Thanks again,
> > Mike
> >
> > ----- Original Message -----
> > From: "Vinnie (Mailinglists Only)" <vinnie@j...>
> > To: "ASP Database Setup" <asp_database_setup@p...>
> > Sent: Saturday, August 24, 2002 4:54 AM
> > Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
> >
> >
> > > check the permission on the database
> > > Iuser and Wanuser should have read and write rights on the database.
> > >
> > > Greetings,
> > > Vinnie
> > >
> > > ----- Original Message -----
> > > From: "Mike" <mg188@c...>
> > > To: "ASP Database Setup" <asp_database_setup@p...>
> > > Sent: Friday, August 23, 2002 9:47 PM
> > > Subject: [asp_database_setup] can't get asp to work with Access 2k
> > >
> > >
> > > > I converted my Access97 to Access2k and tried running sql calls from
> the
> > > same asp pages.  I get the following error.
> > > >
> > > >
> > > > Error Type:
> > > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> > > engine cannot open the file '(unknown)'. It is already opened
> exclusively
> > by
> > > another user, or you need permission to view its data.
> > > >
> > > >
> > > > The setup on my devel pc:  Login to win2kpro as administrator. All
> site
> > > files (html, asp, db) are in folders under wwwroot (IIS5).
> > > > Function ocon sets up my connection string.  Both of the strings
below
> > > give the same error above.
> > > >
> > > >
> > > > function ocon()
> > > > set objcon = server.createobject("adodb.connection")
> > > > objCon.open "dsn=mg53r3db"
> > > > end function
> > > >
> > > > function ocon()
> > > > set objcon = server.createobject("adodb.connection")
> > > > objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > > > Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> > > > end function
> > > >
> > > >
> > > > I triple-checked that the system dsn is set like I've always set it
> for
> > > use with Access 97.
> > > >
> > > > Within Access 2k, all groups and users have full permissions.  (I
know
> > > this probably isn't a good idea - I'll change this after I get the
> > > connection working).
> > > >
> > > > This is driving me bonkers - any advice?
> > > >
> > > > Thanks in advance,
> > > > Mike
> > > >
> > > >
> > vinnie@j...
> > > %%email.unsub%%
> > > >
> > > >
> > >
> > >
> > %%email.unsub%%
> > >
> > >
> > >
> >
> >
vinnie@j...
> %%email.unsub%%
> >
> >
>
>
%%email.unsub%%
>
>
>

Hi Mike
your welcome !!

Greetings,
Vinnie
----- Original Message -----
From: "Mike" <mg188@c...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Wednesday, August 28, 2002 4:52 AM
Subject: [asp_database_setup] Re: can't get asp to work with Access 2k


> Hi Vinnie - I created the iuser & wanuser accts and set permissions at the
> directory level (where the db is stored).  Still didn't work, but when I
set
> the permissions for those 2 users directly in the properties of the .mdb
> file, it started working.
>
> Thanks for putting me on the right track.
>
> ----- Original Message -----
> From: "Vinnie (Mailinglists Only)" <vinnie@j...>
> To: "ASP Database Setup" <asp_database_setup@p...>
> Sent: Sunday, August 25, 2002 1:23 AM
> Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
>
>
> > >Thanks Vinnie.  I'm still having trouble with this.  It started working
> > this
> > > morning with the dsn conn string, but just stopped after a couple
hours
> > with
> > > the following message.
> >
> >  Error Type:
> >  Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine
> > cannot open the file '(unknown)'. It is already opened exclusively by
> > another user, or you need permission to view its data.
> >
> > => you still have a permission problem
> >
> > I next created an iuser account in Access 2000 (should it be
> > iuser-[machinename] or just iuser), and put it in the Access user group,
> > which has data read/write permission (but not to modify the design).  I
> > rebooted but get the same error.  IIS still works because asp pages that
> > don't interact with the database work fine.
> > => you don't create in acces an Iuser. if you want to set the permission
> > correct you go to the directory where your database is standing and
there
> > you ask the properties of that directory. Once you have done that you
> should
> > have there somewhere an Iuser and wanuser (I'm working now with XP and
> thats
> > also diffrent from win2k.) There shall stand iuser: read + wanuser:
change
> > (=read + write). they should have both change rights.
> >
> > I will check it on monday when I'm at the office
> >
> > >
> > > Should I create an iuser account at the operating system level too?
> > => he is already there
> > >
> > > This pc isn't running on a lan - it just has a dialup internet
> connection.
> > > What's the wanuser account for?
> > wanuser = the editor, the one who can make changes. you needs that
account
> > also
> >
> > > Could you recommend a good article on the ins and outs of security
setup
> > for
> > > a development machine with win2k pro, iis, asp3, Access2k, and
> eventually
> > > msde?  I've read some already, and understand authentication and
> > > permissions, but am having trouble with setting up the various pieces.
> > I've
> > > recently migrated from win98se/pws/access97.
> > >
> > > Thanks again,
> > > Mike
> >
> > good links are:
> >
> > www.4guysfromrolla.com
> > www.aspin.com
> > http://www.internet.com/sections/asp.html
> >
> >
> >
> > ----- Original Message -----
> > From: "Mike" <mg188@c...>
> > To: "ASP Database Setup" <asp_database_setup@p...>
> > Sent: Saturday, August 24, 2002 11:55 PM
> > Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
> >
> >
> > > Thanks Vinnie.  I'm still having trouble with this.  It started
working
> > this
> > > morning with the dsn conn string, but just stopped after a couple
hours
> > with
> > > the following message.
> > >
> > > Error Type:
> > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> > engine
> > > cannot open the file '(unknown)'. It is already opened exclusively by
> > > another user, or you need permission to view its data.
> > >
> > > I next created an iuser account in Access 2000 (should it be
> > > iuser-[machinename] or just iuser), and put it in the Access user
group,
> > > which has data read/write permission (but not to modify the design).
I
> > > rebooted but get the same error.  IIS still works because asp pages
that
> > > don't interact with the database work fine.
> > >
> > > Should I create an iuser account at the operating system level too?
> > >
> > > This pc isn't running on a lan - it just has a dialup internet
> connection.
> > > What's the wanuser account for?
> > >
> > > Could you recommend a good article on the ins and outs of security
setup
> > for
> > > a development machine with win2k pro, iis, asp3, Access2k, and
> eventually
> > > msde?  I've read some already, and understand authentication and
> > > permissions, but am having trouble with setting up the various pieces.
> > I've
> > > recently migrated from win98se/pws/access97.
> > >
> > > Thanks again,
> > > Mike
> > >
> > > ----- Original Message -----
> > > From: "Vinnie (Mailinglists Only)" <vinnie@j...>
> > > To: "ASP Database Setup" <asp_database_setup@p...>
> > > Sent: Saturday, August 24, 2002 4:54 AM
> > > Subject: [asp_database_setup] Re: can't get asp to work with Access 2k
> > >
> > >
> > > > check the permission on the database
> > > > Iuser and Wanuser should have read and write rights on the database.
> > > >
> > > > Greetings,
> > > > Vinnie
> > > >
> > > > ----- Original Message -----
> > > > From: "Mike" <mg188@c...>
> > > > To: "ASP Database Setup" <asp_database_setup@p...>
> > > > Sent: Friday, August 23, 2002 9:47 PM
> > > > Subject: [asp_database_setup] can't get asp to work with Access 2k
> > > >
> > > >
> > > > > I converted my Access97 to Access2k and tried running sql calls
from
> > the
> > > > same asp pages.  I get the following error.
> > > > >
> > > > >
> > > > > Error Type:
> > > > > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > > > > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet
database
> > > > engine cannot open the file '(unknown)'. It is already opened
> > exclusively
> > > by
> > > > another user, or you need permission to view its data.
> > > > >
> > > > >
> > > > > The setup on my devel pc:  Login to win2kpro as administrator. All
> > site
> > > > files (html, asp, db) are in folders under wwwroot (IIS5).
> > > > > Function ocon sets up my connection string.  Both of the strings
> below
> > > > give the same error above.
> > > > >
> > > > >
> > > > > function ocon()
> > > > > set objcon = server.createobject("adodb.connection")
> > > > > objCon.open "dsn=mg53r3db"
> > > > > end function
> > > > >
> > > > > function ocon()
> > > > > set objcon = server.createobject("adodb.connection")
> > > > > objcon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > > > > Source=c:\inetpub\wwwroot\mg53r3\mg53r3.mdb;"
> > > > > end function
> > > > >
> > > > >
> > > > > I triple-checked that the system dsn is set like I've always set
it
> > for
> > > > use with Access 97.
> > > > >
> > > > > Within Access 2k, all groups and users have full permissions.  (I
> know
> > > > this probably isn't a good idea - I'll change this after I get the
> > > > connection working).
> > > > >
> > > > > This is driving me bonkers - any advice?
> > > > >
> > > > > Thanks in advance,
> > > > > Mike
> > > > >
> > > > >
> > > vinnie@j...
> > > > %%email.unsub%%
> > > > >
> > > > >
> > > >
> > > >
mg188@c...
> > > %%email.unsub%%
> > > >
> > > >
> > > >
> > >
> > >
> vinnie@j...
> > %%email.unsub%%
> > >
> > >
> >
> >
> %%email.unsub%%
> >
> >
> >
>
>
%%email.unsub%%
>