Access and M$SQL server kicking my a@@

[acemcmac]

I have a very, very large table that multiple users need to be able to create, read and modify different records simultanously from forms in Access. I have been trying to establish an SQL server to host the table and allow this, but I am totally lost. I have "installed" MSDE2000A, and there is an SQL process running in my system tray, but I can't figure out where any of the control applications are, and microsoft's help is a dead end, albeit an informative one. There are no applets in the control panel.... any ideas?

 

[WannaFly]

MSDE does not come with a GUI frontend. you can use access or the .exe command line to alter the database - or perhaps find a 3rd party utility.

 

[Firus]

Search for a utility called DBMGR2k (I think thats how its spelled) it's a really toned down version of MS SQL Enterprise manager for MSDE

edit: or use OSQL at the command line.

 

[Crusty]

You could just write a simple .asp page and use that to access the db.

 

[acemcmac]

Originally posted by: Firus
Search for a utility called DBMGR2k (I think thats how its spelled) it's a really toned down version of MS SQL Enterprise manager for MSDE

edit: or use OSQL at the command line.

That sounds exactly like what I need, but without a better spelling, teh googles isn't helping me find it. Thanks again for the help guys!

 

[skace]

The full license MS SQL comes with the awesome GUI. Otherwise you get ganked into using command line.

 

[tkdkid]

You can use access. Just create a new data access project and point it to the sql/msde server. It's pretty straightforward.