Unable to share vba access database with 2nd desktop

[bhren1]

Trying to share a vba created access database with a 2nd desktop. Can't link the tables. Access version is 2007-2216. Even when I click "ok", still won't open tables.
Any ideas? Disclaimer: I am not a programmer. I am a rank amateur. So please pardon my ignorance. Thanks.

Error message is:

 

[theDBguy]

Hi. Welcome to AWF!

That error message looks like it's related to database corruption.

 

[Ranman256]

Put the BackEnd on a server folder
relink the FrontEnd to this spot using UNC paths (\\server\folder\) not Drive Letters (f:\folder)
then give each person a copy of the FE to use.

 

[isladogs]

Not sure what this means

Trying to share a vba created access database with a 2nd desktop.

Sorry to say that its probably too late to rescue. By the time that message is seen, corruption is probably so severe that its unlikely you can rescue much, if any code.

Do you have a recent backup? If not you could try purchasing database repair software but, from experience, its unlikely to help much.

 

[bhren1]

Thanks, in an attempt to increase clarity of my issue, let me try and elaborate. The database works fine on my primary computer. I'm trying to network the database with one other computer, so that 2 can use it simultaneously. Hence, I split the database using the included access tools. Front end, backend, etc. I can place random files (word, whatever) in a shared network folder and they function fine. Database, no. It was suggested that the access program version on computer #2 might not be compatible with the database. So, I tried to run a working database copy on #2 and lo and behold, it would not open the tables. Could the program be corrupted? So I have since (with some difficulty) un-installed Access and tomorrow I'll try and find a non "click to run" version to install and try again. Again, the database works fine on computer #1. So, hoping Access on #2 was just corrupted somehow. Much too easy of course. But who knows. Other than the shadow, perhaps I will tomorrow. Thanks!

 

[The_Doc_Man]

If the versions of Access on the two computers are not the same, the older one probably cannot read the back-end because Access automatically upconverts version-specific stuff when you open it with a newer version. That might leave you with library incompatibilities. If you and your partner both tried to open the same front-end or monolithic DB file at the same time from two different computers, that would also be risky business.

If EITHER version can read the DB, then IMMEDIATELY make a backup copy before you attempt anything else. At least that way you can try to recover content while you sort this out.

 

[June7]

What do you mean by "VBA created"?
What is nature of this network? Do you actually have a network file server? Or just a shared folder on your PC? Or an external drive connected to router?