Question Linking to another access backend (1 Viewer)

paulwhite986

New member
Local time
Yesterday, 23:39
Joined
Sep 3, 2007
Messages
2
Hi all. Hopefully someone can help me out.

I want to create a vb front end/access backend system. This is a project for work that I'm using to teach myself VB. I would like to be able to take information stored in an access backend from a seperate stock control system.

Is this possible? I only require read-only access but the database I want to link to will be open and locked by the stock control system. I can't mess around with the stock control system as it wasn't created by me and I can't risk corrupting or breaking it. Will linking to it work or is there another/better method?
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 07:39
Joined
Sep 12, 2006
Messages
15,634
no you can connect to tables in that database

you will have a "live" connection that you could use to update the stock data. if you want to avoid the possibility, you could copy the stock tables into your database - and then you would not be able to accidentally modify the "true" data
 

Users who are viewing this thread

Top Bottom