Access and the intranet

Surjer

Registered User.
Local time
Today, 01:30
Joined
Sep 17, 2001
Messages
232
Hello all,
1st off, thanks for anytime that you spend replying to the post. I have a database that I connect to using VB6.0 for the front end. We have 21 different offices and most of them are connected at least through the WAN. My problem occurs with the offices that are connected with VPN.

The database sits at a location "//in/myfolder" but not everyone can see it. So I figured that maybe I should create more of an intranet based DB?

I see that Access 2000 supports Data Access Pages. But from what I can tell is that you have to use a record selector to cycle through the records?

I need to run code that loops through recordsets and updates several tables based on key variables...

Does anyone have any suggestions on how to get around my network access problem????

TIA

Jerry
 
VB (.NET)

Maybe I should go to a VB.NET front end?
Does anyone know where I can find an evaluation vopy of VS.NET?
 
Try using ODBC and create a DSN for the database.

It's what I use when I code the frontend in C++
 
The problem with that is they still have to be able to see the DB. Not everyone has access to the same servers...
 
Check and see if the VPN clients are part of the same workgroup. If they are not, this could cause errors in allowing them into the shared resources. Also, I would check with the network admin as to the specifics of the VPN connection. Maybe he could allow for a modification to the connection to allow for these shared resources.

Someitme individuals with a VPN connection dont run the same configuration scripts as those connected via WAN or LAN. You could create a batch file that would correct this and run it either at the time of connection or when the application is activated. One issue I came across in the past was similar to this, and I ran a small batch file when the FE started that established a connection to the shared network folder. This way, all of the users (Dial up, VPN, WAN, and LAN) were able to access it.
 
Ah. I got ya. Really no way around it. Whoeve is using it will need access to it. Why don' t you set up a group of users for that database. It's what I do also.
 
Now we are getting somewhere.....

We have 1000+ employees stretched across 21 offices. I dont want to have to go through our IT dept. That would take an act of GOD to get them to help out. We develope around them and we have no rights to modify any connections.....
 
See how restrictive the settings are. Assuming you are running a windows OS, open MY COMPUTER and see what drive letters are used. Pick a letter NOT in use and open the command prompt/DOS window. Type in this and substitute Z for whatever letter you picked

net use Z: \\YOURSERVERNAME\SHAREDFOLDER /persistent:yes

This will create a virtual drive to the shared folder and then you can have the application access it as if it were a local drive.
The persistent:yes will keep the drive after log offf, switch to NO if you dont want them having that access.
The \\YOURSERVERNAME\SHAREDFOLDER is simply the directory path to the BE.

If this works properly, enter the command in notepad and save as a .bat file. When you start your FE, have it execute the batch to establish the drives.
 
If you have that many emplyees then there should be a common drive that EVERYONE uses where you could put the database. Otherwise you will have to through the IT department. I'm the IT Systems Administrator at my company and will gladly make a group for someone if they need it.
 
I haven't had the chance to try it yet but by using the"net use t: \\IN\SHAREDFOLDER /persistent:NO"

Will that work even if IN is not in the TREE?
 
OK -

Just wanted to post a follow up with the currunt solution.

I did a netmeeting with the people that were having problems seeing the database. (Atlanta) office. I tried to ping the server and of course got a timeout.

So I went to the IT department and come to find out they created a TREE just for Atlanta becuase of some IT problems. Basically they are tied off from the other offices.

Solution -

I am going to create a replica of the database and send it to them and just have them send it back maybe once a week or so until IT gets them back on our TREE.

Thanks for all your help people.

PS,
Is there anything secial about replicas that maybe someone wants to point out?
 

Users who are viewing this thread

Back
Top Bottom