Not having to have the drive mapped for database...

[Jeffshex]

I have a form on our sharepoint site and it grabs data from a database that's
on the same server. However, if you do NOT have your X: drive mapped to the
location of the database...it pops up with a box wanting a username and
password for some Read_Write_Mode.
Basically, I'm wondering if there is a way to not have to have your drive
mapped for this to work.

Thanks,
Jeff

 

[Mike G.]

Just use the server name: \\servername\sharename\databasename.mdb

Mike G.

 

[Jeffshex]

Where would I define that?

Just use the server name: \\servername\sharename\databasename.mdb

Mike G.

 

[Mike G.]

Whereever you specified the X drive to begin with.

If it's an access database, and you're designing a form based on a data
connection, just type in the server name (\\server\share) into the "Select
Access Database" file dialog, instead of browsing through the mapped drive.

Mike G.

 

[Jeffshex]

I think I have it figured out. I opened up my Data Connections and changed
the path that they were used to being opened.
Thanks for the help Mike!!

Jeff