Networking Access

[paul79]

does anyone know where i would get info on networking access, i want to have an access database on a server and be able to have the clients on the desktops to be able to delete, add entries, and read data.

 

[rajeessh]

Just Configure a DSN for the DATA Access MDB on server
Link the tables in the Client Access MDB
Run the Client MDB

 

[paul79]

Thats under data sources (ODBC) right? i'm gonna have to read up on that if it is, i've always seen it there but never have experimented. do u know were i could get white papers or any type of web site that explains how to use it and set it up

 

[WildHare]

You shouldn't need ODBC to connect to another Access db on a server drive. Just split the database (see various help sources on that), put the DATA database on the server, and give everyone the front end database, after you've linked to the data database tables.

There are some minor programming issues, but nothing that can't be worked out. There are lots of people here who can help as they pop up.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[rajeessh]

One Small Doubt Wild:

Wont we be needing DSN if we need to relink by using Code
Else we must open up the Connection and do that.Which would be better

 

[WildHare]

Unless you move the source data database around or alter it somehow, why would you need to re-link in the first place? I've never had to do that in systems I've assembled. As long as the network mappings and logical arrangements stay constant, why bother? I've had a networked, WAN-based system running at a previous employer for over 4 years and there's not one line of re-linking code in it.

If you have to re-link your data database on a regular basis, I guess I do not have the answer for you. It is an area with which I am not familiar.

Jim

How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[rajeessh]

Mostly we fix the bugs and other stuff at our site and upload mde for clients.The client m/c the links should point to his m/c and in case of ours we need our m/c's to be pointed to.So we were using dsn's and relinking the stuff