Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-21-2012, 09:01 AM   #1
Beta Member
 
Join Date: Sep 2012
Location: USA
Posts: 3
Exclamation MS Access & VB Coding

Hey guys,

The company I'm working for has a microsoft office access database they use to record/edit information in their inventory. One of my tasks is to edit and modify the database, however whenever I make any changes to the back end (when I make a local copy of the database) it affects the database on the server as well. Is there any way in which I can link the database as a relative path as opposed to absolute path? I want to be able to edit and work with a copied version of the database without affecting the original copy on the server. The front end is just a forum with VB coding to support it but how do I link that to a locally copied back end?

- West
__________________

west9510 is offline   Reply With Quote
Old 09-21-2012, 09:23 AM   #2
In Runtime
 
OS-Wiz's Avatar
 
Join Date: Sep 2012
Location: USA
Posts: 334
Default Re: MS Access & VB Coding

Just copy the .accdb/.mdb to another folder for which you have permissions. Then use a copy of the VB to edit/modify it or do it directly in Access.
__________________

__________________
i7-3930K - Corsair H100 push/pull fans - ASUS Rampage IV Extreme - 4 x 4GB G.Skill DDR3 2133 - 2 x EVGA GTX680s in SLI - OS, 256GB Samsung 830 SSD - Games, 256GB Crucial M4 SSD - Antec TPC 1200W - Dell 27" IPS 2560x1440 - APC XS1500 UPS - Win7 Ultimate x64
OS-Wiz is offline   Reply With Quote
Old 10-23-2012, 09:03 AM   #3
Beta Member
 
Join Date: Sep 2012
Location: USA
Posts: 3
Default Re: MS Access & VB Coding

Sorry for the late reply, but thanks a lot
west9510 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0