Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database idendity

Status
Not open for further replies.

2ni

Programmer
Mar 21, 2002
36
FR
I have to built a database that i'll copy on three computers. Is there a way to identify each database ?

i know how to identify Access with 'Application.ProductCode' which gives me the Access GUID but what i need is a kind of Database GUID
 
2ni,

Are these machines all networked?

If so, split the database into a front end and a back end, install the front end to the client machines and link to the centralised backend on the server. That way you won't need to worry about the db id as there will only be one.

Tools > Database Utilities > Database Splitter.

Hope this helps.

Leigh Moore
Solutions 4 MS Office Ltd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top