Access 2000 forms

phydeaux · Post by **phydeaux** » Tue Jan 13, 2009 2:35 pm

Trying to open and edit a form in wine using Access 2000. Only problem is that the file I need is over the network on a win xp server. I can bring up Access just fine, click open, but when I click on network places I get this:

I have tried everything but I'm horribly new to this. Please help.[/img]

austin987 · Post by **austin987** » Tue Jan 13, 2009 3:19 pm

On Tue, Jan 13, 2009 at 1:35 PM, phydeaux <[email protected]> wrote:

Trying to open and edit a form in wine using Access 2000. Only problem is that the file I need is over the network on a win xp server. I can bring up Access just fine, click open, but when I click on network places I get this:

[Image: http://i283.photobucket.com/albums/kk31 ... enshot.png ]

I have tried everything but I'm horribly new to this. Please help.[/img]

Do you have samba installed and the network shares mapped?

--
-Austin

vitamin · Post by **vitamin** » Tue Jan 13, 2009 4:24 pm

phydeaux wrote:Only problem is that the file I need is over the network on a win xp server.

Wine does not support windows networking.

You have to map all remote shares with samba. Then point Wine to it using winecf to map each mounted dir to Wine's disk.

phydeaux · Post by **phydeaux** » Tue Jan 13, 2009 5:15 pm

vitamin wrote:
phydeaux wrote:Only problem is that the file I need is over the network on a win xp server.
Wine does not support windows networking.

You have to map all remote shares with samba. Then point Wine to it using winecf to map each mounted dir to Wine's disk.

Ok now I need some help with samba. Sorry for being such a noob.

Post by **DanKegel** » Tue Jan 13, 2009 7:25 pm

You can use gnome's "Connect to Server" menu item instead of samba...
see http://www.linuxtopia.org/online_books/ ... s-515.html

Then in winecfg map a drive to $HOME/.gvfs/<sharename>

And away you go!

We really need an FAQ on how to do this.

Daniel Kasak · Post by **Daniel Kasak** » Tue Jan 13, 2009 8:27 pm

On Tue, 2009-01-13 at 13:35 -0600, phydeaux wrote:

Trying to open and edit a form in wine using Access 2000. Only problem is that the file I need is over the network on a win xp server. I can bring up Access just fine, click open, but when I click on network places I get this:

[Image: http://i283.photobucket.com/albums/kk31 ... enshot.png ]

I have tried everything but I'm horribly new to this. Please help.[/img]

I bit off-topic, but maybe of use to you ...

I have written a set of Perl libraries ( open-source & fully
cross-platform ) that use Gtk2-Perl to replace MS Access forms,
datasheets and reports.

If you want to use this solution, you're looking at a rewrite of your MS
Access application, but it's worth it.

It's all up on my website: http://entropy.homelinux.org/axis/

Also available on cpan ( but versions haven't been updated in a while ):
- Gtk2::Ex::DBI
- Gtk2::Ex::Datasheet::DBI
- PDF::ReportWriter

There are screenshots of a production system that I ported from MS
Access because it was becoming unstable and unmanagable ( and very
slow ).

As for MS Access under wine, I tried that before embarking on developing
the above. At the time I was using a trial version of crossover office.
It was OK for running simple forms, but was prone to crashing quite
often, and would corrupt the mdb file when this happened, which wasn't
so good. Also getting ODBC drivers working in wine was a nightmare.
Maybe things have changed recently? Haven't bothered trying.

Dan

phydeaux · Post by **phydeaux** » Wed Jan 14, 2009 11:12 am

DanKegel wrote:You can use gnome's "Connect to Server" menu item instead of samba...
see http://www.linuxtopia.org/online_books/ ... s-515.html

Then in winecfg map a drive to $HOME/.gvfs/<sharename>

And away you go!

We really need an FAQ on how to do this.

Ok, so I don't have a /.gvfs/

under my home directory. ???

I was able to mount the network drive, navigate to the database form, right click and open under wine windows program loader

This is what I got:

I downloaded the .dll, navigated to the wine c:/ drive/windows/system32 but the .dll is already there!!! Now I'm really lost.

Please understand that I have the boss breathing down my neck and am trying to do this sink or swim style. Thanks for the continued help!!!

vitamin · Post by **vitamin** » Wed Jan 14, 2009 1:40 pm

phydeaux wrote:This is what I got:

Code: Select all

wget http://www.kegel.com/wine/winetricks
winetricks jet40

http://wiki.winehq.org/winetricks

phydeaux wrote:Please understand that I have the boss breathing down my neck and am trying to do this sink or swim style.

Then why the hell did you got into something you have no clue about?

Wine is not guaranteed to work with ANY windows application. If you got it to work - good for you. If not - oh well, something more for wine hackers to fix. If you absolutely have to have something working DO NOT use Wine as a possible solution.

phydeaux · Post by **phydeaux** » Wed Jan 14, 2009 1:45 pm

Thought this was a forum for help, not ass chewings. Forgive me for wanting to learn, I did not realize it was a crime until just now.

vitamin · Post by **vitamin** » Wed Jan 14, 2009 1:57 pm

phydeaux wrote:Thought this was a forum for help, not ass chewings. Forgive me for wanting to learn, I did not realize it was a crime until just now.

If you want to learn don't tell us your boss will chew your ass if you won't have it running by COB today.

austin987 · Post by **austin987** » Wed Jan 14, 2009 2:21 pm

On Wed, Jan 14, 2009 at 12:45 PM, phydeaux <[email protected]> wrote:

Vitamin, chill out, this IS the users forum. You can't blame a user
for trying to get an app to work.

Thought this was a forum for help, not ass chewings. Forgive me for wanting to learn, I did not realize it was a crime until just now.

It is, and you're right. The problem is that:

A) Microsoft Office (and Access especially) are pretty complex, so
they don't work quite right).
B) You really shouldn't be depending on Wine to do your job if you're
not sure it'll work.

That said, if you can get it to work, great!

If not, more bugs for us to fix

.

--
-Austin

vitamin · Post by **vitamin** » Wed Jan 14, 2009 5:49 pm

austin987 wrote:Vitamin, chill out, this IS the users forum. You can't blame a user for trying to get an app to work.

I don't blame anyone for anything.

If user have to have it working _NOW_ (pretty darn close to COB here) then use what known to work - windows. BTW you'll need it's license anyway if you install most anything through winetricks.

If you have all the time in the world to piddle with it, figure out how things work, learn how to use Linux, etc - then by all means. Just don't expect it to work RIGHT NOW. Or work at all for that matter in the current Wine version.

austin987 · Post by **austin987** » Wed Jan 14, 2009 5:56 pm

On Wed, Jan 14, 2009 at 4:49 PM, vitamin <[email protected]> wrote:

austin987 wrote:
Vitamin, chill out, this IS the users forum. You can't blame a user for trying to get an app to work.
I don't blame anyone for anything.

If user have to have it working _NOW_ (pretty darn close to COB here) then use what known to work - windows. BTW you'll need it's license anyway if you install most anything through winetricks.

If you have all the time in the world to piddle with it, figure out how things work, learn how to use Linux, etc - then by all means. Just don't expect it to work RIGHT NOW. Or work at all for that matter in the current Wine version.

I'm not disagreeing with that, I'm just asking to tone it down a
bit...it's the users forum, not wine-devel/bugzilla. People here
aren't necessarily as familiar with Wine, so we shouldn't be trying to
scare them off.

--
-Austin

Ben Okopnik · Post by **Ben Okopnik** » Thu Jan 15, 2009 6:06 am

On Wed, Jan 14, 2009 at 12:27:06PM +1100, Daniel Kasak wrote:

On Tue, 2009-01-13 at 13:35 -0600, phydeaux wrote:

Trying to open and edit a form in wine using Access 2000. Only problem is that the file I need is over the network on a win xp server. I can bring up Access just fine, click open, but when I click on network places I get this:

[Image: http://i283.photobucket.com/albums/kk31 ... enshot.png ]

I have tried everything but I'm horribly new to this. Please help.[/img]
I bit off-topic, but maybe of use to you ...

I have written a set of Perl libraries ( open-source & fully
cross-platform ) that use Gtk2-Perl to replace MS Access forms,
datasheets and reports.

Cool - it would be nice to have some of that functionality in Linux.
Thanks, Dan.

Speaking of useful bits of Perl - I threw this little hack together to
analyze the logfiles produced by my troubleshooting:

WINEDEBUG="+file,+comm,+serial" wine tsconfig.exe > tsconfig.LOG 2>&1

It keeps a list of whatever was reported as "not found" within the log,
then drops any of the entries that get found later - thus reporting only
the DLLs, etc. that were never found. Hopefully, some of you fine Wine
folks here will find it useful.

---------------------------- missing_libs starts here -----------------
#!/usr/bin/perl -wl
# Created by Ben Okopnik on Wed Jan 14 17:43:01 CST 2009
use strict;

my %coll;
while (<>){
$coll{$1}++ if /"([^"]+)" not found/;
delete $coll{$1} if m{[\\\/]([^"\\\/]+)" ->} && exists $coll{$1};
}

print "Missing libs, etc.:\n===================";
print for sort keys %coll;
------------------------------ missing_libs ends here ------------------

Make it executable, run it as "./missing_libs logfile", and watch the fun.

Best regards,
--
* Ben Okopnik * Editor-in-Chief, Linux Gazette * http://LinuxGazette.NET *