Dynamically join a workgroup on db load

[martinmike2]

Hello,

What I would like to do is: When the user opens the database, I would
like it to dynamically join a custom workgroup. I know this can be
accomplished by creating a shortcut, but is that the only way?

 

[Douglas J. Steele]

Yes, it's the only way because once you've opened the database, you can't
change the workgroup to which its associated.

 

[martinmike2]

Yes, it's the only way because once you've opened the database, you can't
change the workgroup to which its associated.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)







- Show quoted text -

darn, ok, thnx.

 

[a a r o n . k e m p f]

SQL Server has a much better security model, you should lose the
training wheels.

ULS was removed from Access when 2007 was released, so it's best to
move to something with a future (SQL Server is the worlds most popular
database).

-Aaron

 

[Douglas J. Steele]

ULS was NOT "removed from Access when 2007 was released". ULS works (as well
as it ever did) in Access 2007 if you leave the database in MDB format, as
opposed to using the new ACCDB format.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


message
SQL Server has a much better security model, you should lose the
training wheels.

ULS was removed from Access when 2007 was released, so it's best to
move to something with a future (SQL Server is the worlds most popular
database).

-Aaron

 

[a a r o n . k e m p f]

uh yah it was, same with replication.

Anyone wanting to use those features needs to use Access Data
Projects.

-Aaron

 

[Douglas J. Steele]

Ignoring facts again, Aaron?

http://office.microsoft.com/en-us/access/HA101662271033.aspx

"If you created a database in a previous version of Access and you applied
user-level security to that database, those security settings remain in
place when you open that file in Microsoft Office Access 2007. In addition,
you can start the security tools provided by Microsoft Office Access 2003 -
the User-Level Security Wizard and the various user and group permission
dialog boxes - from Office Access 2007. "

http://msdn.microsoft.com/en-us/library/bb203849.aspx

"Replication is not supported by the .accdb format. The tools to create and
synchronize masters and replicas are still available in Access 2007 when you
are working with an .mdb database. They are located on the Database Tools
tab of the Ribbon."

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


message
uh yah it was, same with replication.

Anyone wanting to use those features needs to use Access Data
Projects.

-Aaron

 

[martinmike2]

wow, training wheels?

lol, I dont want to start a flame war here. The reason I am using
Access instead of a more robust technology is because the application
is being used in one office on one military base. If the pilot
project tests good and the project is picked up by the overriding
command, then I will move to a more robust technology. Until then, it
is not cost-efficient to buy/lease a server, or buy/lease SQL. The
ultimate goal is to move to a webbased system running on mySQL (since
I know it) across all if not most of the military branch's.

Besides, learning Access and VBA has been a fun and exciting
experiance.

Thank You,
Michael Martin

P.S. If it is possible, i request this topic be locked.

 

[a a r o n . k e m p f]

SQL Server is free. And the development is _EASIER_ not harder than
Jet.

Do it right or do it twice. Our country is relying on you to make
the correct decision.

mySQL is harder for development than MS SQL Server, and the
performance is not adequate. Does mySQL even support more than 2 CPU
cores these days? has 5.1 even shipped? Can you use MS Access as a
frontend to mySQL Server?

Or do you need to install drivers and 3rd party apps?

Do you have the 'index tuning wizard' or 'database tuning advisor' or
'Select * from sys.dm_db_missing_index_details'?

Does mySql help you find which indexes you're missing?

-Aaron

 

[a a r o n . k e m p f]

Douglas;

You really don't get it do you --

These pieces are not available in Access 2007 (format).
Thus, in order to use those technologies, you need to move to ADP.

-Aaron

 

[Tony Toews [MVP]]

wow, training wheels?

lol, I dont want to start a flame war here.

No, you didn't start any flame war. Aaron is solely responsible for
any such. Although, of course, he will never see it that way.

P.S. If it is possible, i request this topic be locked.

That can't be done with the distributed nature of NNTP newsgroups.
We'd quite like it if Aaron was locked out of these newsgroups as
well.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

Tony;

I'd quite like it if you became educated on SQL Server before you
purposefully scare people away from it (without reason)